| From: | Culley Harrelson <culley(at)easystreet(dot)com> |
|---|---|
| To: | sszabo(at)megazone23(dot)bigpanda(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fwd: Re: deleting a child table |
| Date: | 2001-11-03 13:49:54 |
| Message-ID: | 5.1.0.14.2.20011103054801.00a2c8a0@pop.easystreet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
So in pg_trigger all I have is a mess of RI contraints. How can I figure
out what is the offending trigger?
culley
>On Fri, 2 Nov 2001, Culley Harrelson wrote:
>
> > I have dropped the child table in a one to many relationship. Now when
> > I try to update the parent table I get a message that the child table
> > doesn't exist. Any idea what I missed?
>
>Is it possible you have a dangling foreign key reference? I believe
>this could be caused if you'd dumped with a 7.0 or 7.1.(up to 2 I think)
>pg_dump, because it didn't restore the portion of the trigger which
>let it know to be dropped when the other table was dropped.
>If so, you'll probably need to look at pg_trigger and find the two
>triggers associated with the broken constraint and do a
>drop trigger "<trigger name>"; for them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Konstantinos Agouros | 2001-11-03 16:45:21 | Sum(time) possible? |
| Previous Message | Tatsuo Ishii | 2001-11-03 12:15:16 | Re: CP1250 to and from Unicode conversion, how? |