Postgres Pro
Downloads
Home   >   mailing lists

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

From Joel Mc Graw
Subject Dropped table screws referential integrity?
Date
Msg-id TradeClient.0.9.0.FreeBSD-4.2-RELEASE.0203070756222A.71014@jmcgraw.databill.com
Whole thread Raw
Responses Re: Dropped table screws referential integrity?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Dropped table screws referential integrity?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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-----

pgsql-admin by date:

Previous
From: Judy Jecelin
Date:
Subject: Adding date components to a date
Next
From: Stephan Szabo
Date:
Subject: Re: Dropped table screws referential integrity?