Re: Dropped table screws referential integrity?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Joel Mc Graw <jmcgraw(at)databill(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Dropped table screws referential integrity?
Date: 2002-03-07 16:57:08
Message-ID: 20020307085622.Y77313-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Srinivasa R Chava 2002-03-07 17:21:23 Re: pg_restore problem.
Previous Message Chad R. Larson 2002-03-07 16:35:40 Re: Solaris x86 vs Linux vs *BSD for PostgreSQL?