| Subject | Re: [firebird-support] Re: could not find UNIQUE INDEX with specified columns |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-10-16T10:56:32Z |
At 19:20 16/10/2008, you wrote:
./heLen
>HiYou need to commit the first statement before the second one will work.
>
>CREATE TABLE test (field1 integer, field2 char(1024), field3 integer,
>PRIMARY KEY (field1))
>
>After:
>
>ALTER TABLE test ADD FOREIGN KEY (field3) REFERENCES test(field1)
>
>Throws: could not find UNIQUE INDEX with specified columns
./heLen