Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update) - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)
Date
Msg-id 1317826416-sup-836@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)  (Daniel Cristian Cruz <danielcristian@gmail.com>)
Responses Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)  (Daniel Cristian Cruz <danielcristian@gmail.com>)
List pgsql-bugs
Excerpts from Daniel Cristian Cruz's message of mié oct 05 10:00:36 -0300 2011:
> 2011/9/26 Alvaro Herrera <alvherre@commandprompt.com>
>
> >
> > Please see if bug #6123 applies to this case.
> > http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg181541.html
>
>
> I guess, yes, it's related, because we had a trigger that deletes a row,
> while other foreign key constraint is updating the row setting null.
>
> But the thread is almost a book, and I am confused. It's a bug or do I need
> to change my schema?

Well, some people say it's a bug, others say it's not; and even if it
is, changing it means backwards incompatible behavior, so *if* it is
patched, it will only change the behavior on a future release, not
whatever you're using.

> Where can I change it to avoid it?

I don't know enough about the problem to help you there, sorry.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: "Pavel Holec"
Date:
Subject: Re: BUG #6233: pg_dump hangs with Access Violation C0000005
Next
From: Tom Lane
Date:
Subject: Re: BUG #6240: About - postgreswdinit.sql