Subject Re: Foreign key problems
Author Alexander V.Nevsky
--- In ib-support@y..., douglasht@i... wrote:
> CREATE TABLE TEST1
> ( FIELD1 INTEGER NOT NULL);
> commit;
> CREATE UNIQUE INDEX PK_TEST1 ON TEST1(FIELD1);

Hi, Douglas, for a long time have'nt met you :) You forgot Foreign
constraint is reffered to Constraint (Primary or Unique) not to
general index even it's name is PK :)

Best regards, Ded.