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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
