Dropped table screws referential integrity?

From: Joel Mc Graw <jmcgraw(at)databill(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Dropped table screws referential integrity?
Date: 2002-03-07 14:56:22
Message-ID: TradeClient.0.9.0.FreeBSD-4.2-RELEASE.0203070756222A.71014@jmcgraw.databill.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

PostgreSQL 7.1.3/FreeBSD 4.2R

TIA

------------------------------------------------------
Joel Mc Graw
DataBill, LLC
602-415-1234 ext. 13

-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCS d-@ s: a C++++ UB++++ P-- L- E? W++ N w--- O? M+ V
PS+++ PE++ Y+ PGP++ t+ 5++ X tv+ b+ DI++ G e++ h---- r+++ y++++
-----END GEEK CODE BLOCK-----

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Judy Jecelin 2002-03-07 15:03:16 Adding date components to a date
Previous Message Jeff Self 2002-03-07 14:20:51 Re: Debian packages of 7.2