| From: | Lewis Bergman <lbergman(at)[nospam] abi(dot)tconline(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | ALTER TABLE table DROP CONSTRAINT problem |
| Date: | 2002-04-30 13:27:07 |
| Message-ID: | 200204301327.g3UDR8x13248@lewis.abi.tconline.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I have a strange problem on 7.2.1
I am trying to drop a constraint that was set up by this SQL
ALTER TABLE customer_main ADD CONSTRAINT cust_main_agent
FOREIGN KEY ( agent )
REFERENCES customer_main ( id )
NOT DEFERRABLE;
So I do this:
ALTER TABLE customer_main DROP CONSTRAINT cust_main_agent RESTRICT;
And get this error:
ERROR: ALTER TABLE / DROP CONSTRAINT: cust_main_agent does not exist
So I try to violate the constraint and I get this:
ERROR: cust_main_agent referential integrity violation - key referenced from
customer_main not found in customer_main
Any ideas? I am wondering if postgres doesn't like the fact that I have a
constraint going from one column to the id (serial) column of the same table.
--
Lewis Bergman
Texas Communications
4309 Maple St.
Abilene, TX 79602-8044
915-695-6962 ext 115
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob | 2002-04-30 13:51:15 | Tricky query |
| Previous Message | Alberto Bolchini | 2002-04-30 10:57:15 | Re: Tricky query |