> --- In firebird-support@yahoogroups.com, Svein Erling Tysvær<svein.erling.tysvaer@...> wrote:
>>
>> You said you also had Database Workbench. Have you tried connecting through DBW to your database, right clicking 'Schema' and choose Extract DDL? It works fine for me, but then we don't use very complex dependencies...
>>
>
> I now tried to edit a flamerobin db script (took a LOT of changes) and got it to run in one transaction. However, when trying to commit the transaction I get a 'deadlock' error.
>
> I then tried to add objects one by one and succeeded with procedure sceletons, domains, functions, generators and roles.
> When coming to the tables, I can add the columns but when trying to add a primary key I get an error:
>
> *** IBPP::SQLException ***
> Context: Transaction::Commit
>
> SQL Message : -607
> This operation is not defined for system tables.
>
> Engine Code : 335544351
> Engine Message :
> unsuccessful metadata update
> cannot create index PK_TEST_1
>
> This is a very simple index on an not null integer column (and no data in table, of course).
>
> Any clues?

Care to send me a metadata backup of your database privately and I will
give it go with the most recent versio of DBW?


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!