| From: | Wolfgang(dot)Fuertbauer(at)ebewe(dot)com |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | drop constraint problem |
| Date: | 2002-05-21 07:12:51 |
| Message-ID: | OFD1BA750D.F628C5CE-ONC1256BC0.00276082@ebewe.co.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Wagner | 2002-05-21 10:08:08 | constraints for ensuring relationships |
| Previous Message | Josh Berkus | 2002-05-21 05:57:46 | Re: [SQL] Bug with Daylight Savings Time & Interval |