Re: Dropped table screws referential integrity? - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Dropped table screws referential integrity?
Date
Msg-id 20020307085622.Y77313-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Dropped table screws referential integrity?  (Joel Mc Graw <jmcgraw@databill.com>)
Responses Re: Dropped table screws referential integrity?  (Joel Burton <joel@joelburton.com>)
List pgsql-admin
On Thu, 7 Mar 2002, Joel Mc Graw wrote:

> I had a table (job_documents) that referenced another (jobs).  I no
> longer needed job_documents, so I dropped it.  Now, any attempt to
> delete rows from jobs fails--it complains that job_documents doesn't
> exist.  Is there a way to fix this?

You'll need to find the two triggers on jobs that reference job_documents
(do a select * from pg_trigger and look at the argument list to find
them) and drop them and you should be fine.


pgsql-admin by date:

Previous
From: Joel Mc Graw
Date:
Subject: Dropped table screws referential integrity?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] PGSTAT Error from Postmaster