drop constraint problem
От | Wolfgang.Fuertbauer@ebewe.com |
---|---|
Тема | drop constraint problem |
Дата | |
Msg-id | OFD1BA750D.F628C5CE-ONC1256BC0.00276082@ebewe.co.at обсуждение исходный текст |
Ответы |
Re: drop constraint problem
Re: drop constraint problem |
Список | pgsql-sql |
Hi all, i'm running 7.2.1 and have problems with dropping constraints: fakt32=# alter table wkfaktzeilen add constraint printjobfk foreign key (printjob) references wkfaktdruck(printjob) match full on delete cascade on update cascade; >ALTER fakt32=# alter table wkfaktzeilen drop constraint printjobfk restrict; >ERROR: ALTER TABLE / DROP CONSTRAINT: printjobfk does not exist fakt32=# alter table wkfaktdruck drop constraint printjobfk restrict; >ERROR: ALTER TABLE / DROP CONSTRAINT: printjobfk does not exist but when dropping the table, the triggers are deleted and i can see the entries in pg_triggers?? please help Wolfgang
В списке pgsql-sql по дате отправления: