Thread: deleting a child table

deleting a child table

From
"Culley Harrelson"
Date:
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?

Culley
 
p.s. hopefully I am not double posting...

Re: deleting a child table

From
"Culley Harrelson"
Date:
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.


Re: deleting a child table

From
Stephan Szabo
Date:
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.