deleting a child table

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.

Yup it was loaded on the server from a 7.1.2 pg_dump. Thanks!

Stephan Szabo <sszabo@megazone23.bigpanda.com> 11/02/01 11:59AM >>>

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.

So in pg_trigger all I have is a mess of RI contraints. How can I figure
out what is the offending trigger?

culley