On Thursday 30 April 2009, Sebastian Böhm wrote:
> when I do:
> alter table only payments drop constraint y;
>
> it says :
> ERROR: "" is an index
>
> note: the constraint in the error message in differed from the
> constraint in my drop statement !!! (I tried to drop the forei
Hi,
some days ago I removed all foreign keys from the database to speed up
an import.
Now I tried to create the keys again but it says:
ALTER TABLE ONLY xxx ADD CONSTRAINT y FOREIGN KEY (zz)
REFERENCES aaa(bb) ON UPDATE CASCADE;
ERROR: constraint "yyy" for