| Subject | Re: [firebird-support] Re: Cannot create tables in new FB 2.5 DB, fails with error 335544351 on commit |
|---|---|
| Author | Lester Caine |
| Post date | 2011-01-01T09:32:11Z |
Paul Vinkenoog wrote:
for indexes and it's trying to create a second 'RDB$PRIMARY11' for some reason.
I usually know straight away where I've cocked up, but when one is up in the
600's, a quick check on the system tables for the index often clears up the problem.
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
> Peter: there's something very weird going on in your database. FWIW, I also ran your DDL (on 2.5) and it worked flawlessly.I'd extend that by saying that I USUALLY see this error when I've left out names
>
> The message "cannot create index RDB$PRIMARY11" suggests there may be something wrong with your system tables.
for indexes and it's trying to create a second 'RDB$PRIMARY11' for some reason.
I usually know straight away where I've cocked up, but when one is up in the
600's, a quick check on the system tables for the index often clears up the problem.
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php