Re: [GENERAL] possible consistency problem

2009-04-30 Thread Alan Hodgson
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

[GENERAL] possible consistency problem

2009-04-30 Thread Sebastian Böhm
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