From: | Sebastian Böhm <seb(at)exse(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | possible consistency problem |
Date: | 2009-04-30 14:42:13 |
Message-ID: | 48CDD95D-C12F-436F-AE2D-EE4FE53C4744@exse.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 xxxxxxx ADD CONSTRAINT yyyyyyyyy FOREIGN KEY (zzzzzz)
REFERENCES aaaaaaa(bbbbbb) ON UPDATE CASCADE;
ERROR: constraint "yyyyyyyyyyy" for relation "xxxxxxxx" already
exists, but it's not in the schema
when I do:
alter table only payments drop constraint yyyyyyyyy;
it says :
ERROR: "cccccccccccc" is an index
note: the constraint in the error message in differed from the
constraint in my drop statement !!! (I tried to drop the foreign key
but in the error message it speaks of the primary key)
what is this ?
Thank you and Kind Regards
Sebastian
From | Date | Subject | |
---|---|---|---|
Next Message | Keaton Adams | 2009-04-30 16:16:19 | How to begin to debug FATAL: invalid frontend message type 77 error messages? |
Previous Message | paulo matadr | 2009-04-30 13:00:54 | Understand this error |