--- In firebird-support@yahoogroups.com, Lester Caine <lester@...> wrote:

>
> Paul Vinkenoog wrote:
> > Peter: there's something very weird going on in your database. FWIW, I also ran your DDL (on 2.5) and it worked flawlessly.
> >
> > The message "cannot create index RDB$PRIMARY11" suggests there may be something wrong with your system tables.
>
> I'd extend that by saying that I USUALLY see this error when I've left out names
> 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.
>

Thanks for the hint, Lester. I could not find any indices with names like the above, but there definitely was something corrupted in my database, probably due to my first bungled attempts to create this table. I followed Paul's advice to start with a new database, and this now seems to work:

ISQL Version: WI-V2.5.0.26074 Firebird 2.5
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'c:\daten\datenbanken\sf\test.fdb'
CON> user 'peter'
CON> password 'perry';
Server version:
WI-V2.5.0.26074 Firebird 2.5
WI-V2.5.0.26074 Firebird 2.5/XNet (PBDELL)/P12
WI-V2.5.0.26074 Firebird 2.5/XNet (PBDELL)/P12
SQL> CREATE DOMAIN OidKey AS CHAR(22);
SQL> commit;
SQL> CREATE TABLE HL_Oids (
CON> OID OidKey NOT NULL CONSTRAINT PK_OIDs PRIMARY KEY
CON> );
SQL> commit;
SQL> show table HL_Oids;
OID (OIDKEY) CHAR(22) Not Null
CONSTRAINT PK_OIDS:
Primary key (OID)
SQL>

So I'm now hopefully able to proceed with this project.

Thanks to all who participated in this thread, and a happy and successful 2011!

--
Peter