From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Irwan Hendra <overtaker(at)gmail(dot)com> |
Subject: | Re: postgres cascade weird behaviour |
Date: | 2009-04-17 13:00:33 |
Message-ID: | 200904170600.33672.aklaver@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 16 April 2009 6:50:46 pm Irwan Hendra wrote:
> Hi
>
> I have table A with pk that is being referenced by 5 other tables as
> foreign key
> I have put all those tables reference to be ON DELETE CASCADE
> However for some reason when I tried to delete one of the row in table A,
> out of 5 tables, 1 of them didn't actually get deleted
> but the transaction is completed successfully
> so I ended up with a table that has a foreign key referenced to a row that
> doesn't exist anymore in table A
>
> postgres is not reporting any error message, so I have no idea how to
> supply more information to this problem
>
> any idea?
>
> Thanks
Turn up the logging in postgresql.conf
--
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-04-17 13:11:44 | Re: Looking for advice on database encryption |
Previous Message | Grzegorz Jaśkiewicz | 2009-04-17 12:53:35 | Re: Common table expressions and threaded comments |