From: | Harry Yau <harry(dot)yau(at)regaltronic(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem with dropping a FOREIGN KEY |
Date: | 2001-03-26 09:48:14 |
Message-ID: | 3ABF105E.7D9B70D@regaltronic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear:
Hi, everybody. I've got some problem with dropping constraint trigger.
I've added a foreign key to my table by something likes below:
ALTER TABLE tableA
ADD CONSTRAINT testtrigger
FOREIGN KEY (columnA)
REFERENCES tableb(columnB)
ON UPDATE CASCADE
ON DELETE CASCADE
After that, I found out that I got three more Create Constraint Trigger
statment in the dump. Now, I wanna drop this foreign key and add another
one. Then I tried the following:
DROP CONSTRAINT testtrigger ON tableA.
However, I keep getting error message as:
PostgreSQL said: ERROR: DropTrigger: there is no trigger testrigger on
relation tableA.
I have surfed around the mail list.
I saw someone have the same problem or similar problem with me.
They can solve it by deleting the corresponding row in pg_trigger on
adjusting the retriggers counts in assoicated pg_class.
However, I can't find those files.
I am wondering that is there any other way to drop that constraint
trigger without invoking the pg_trigger and pg_class file??
Thank you for your patientness
Harry Yau
From | Date | Subject | |
---|---|---|---|
Next Message | Harry Yau | 2001-03-26 10:17:33 | Adjustment to "Problem with dropping a FOREIGN KEY" |
Previous Message | Einar Karttunen | 2001-03-26 09:43:52 | Re: query problem |