Postgres Pro
Downloads
Home   >   mailing lists

Re: foreign key problem - Mailing list pgsql-sql

From Josh Berkus
Subject Re: foreign key problem
Date
Msg-id 200210061711.08667.josh@agliodbs.com
Whole thread Raw
In response to foreign key problem  (Laurette Cisneros <laurette@nextbus.com>)
List pgsql-sql
Tree view 
Laurette,

> How is this possible?  I've tried to reproduce this, but haven't been able
> to yet.  This has happened to use several times.

Question 1:  Can you experimentally create a record in table1, a matching
record in table 2, and then delete the record in table1?  It's possible that
your "ON DELETE CASCADE" trigger got wiped out somehow.


--
-Josh BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: Laurette Cisneros
Date:
Subject: foreign key problem
Next
From: Josh Berkus
Date:
Subject: Re: foreign key problem