Database script fails for Firebird 2.5+ due to existing RDB$ADMIN role

motaz / turbobird

FireBird admin tool

http://code.sd/turbobird

57 stars 28 forks source link

Database script fails for Firebird 2.5+ due to existing RDB$ADMIN role #29

Closed reiniero closed 10 years ago

reiniero commented 10 years ago

Firebird 2.5 has a system-generated role named RDB$ADMIN. TurboBird generates a CREATE ROLE statement for the RDB$ADMIN role, which would be necessary when running on Firebird < 2.5.

It is impossible to know in advance on what Firebird server version/ODS level the create db script will be run; the only solution would be to catch and ignore the error within the SQL script itself.

reiniero commented 10 years ago

Fixed in aba698f5dd1a9650a9adf3f1a01052615ed68e97 with relevant comments in script output