Re: ON DELETE CASCADE with multiple paths in PostgreSQL 9.x - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ON DELETE CASCADE with multiple paths in PostgreSQL 9.x
Date
Msg-id 14092.1307460809@sss.pgh.pa.us
Whole thread Raw
In response to ON DELETE CASCADE with multiple paths in PostgreSQL 9.x  (Anton Dedov <adedov@parallels.com>)
Responses Re: ON DELETE CASCADE with multiple paths in PostgreSQL 9.x
List pgsql-bugs
Anton Dedov <adedov@parallels.com> writes:
> We are using patched version of PostgreSQL 8.1 in order to work-around
> bug described in
> http://archives.postgresql.org/pgsql-bugs/2007-05/msg00130.php. Now, we
> are going to upgrade to 9.0 and it also would be great to get rid of
> patch as it makes keeping database engine current too expensive task.
> I've checked 9.0 and it seems that undesirable behavior is still there.
> Is there any plans to fix it in future releases?

It wasn't a bug then, and it isn't a bug now.  There is no guarantee of
the order in which FK constraints will be checked.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view
Next
From: Tom Lane
Date:
Subject: Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view