Skip site navigation (1) Skip section navigation (2)

Re: ON DELETE CASCADE with multiple paths in PostgreSQL 9.x

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Anton Dedov <adedov(at)parallels(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ON DELETE CASCADE with multiple paths in PostgreSQL 9.x
Date: 2011-06-07 15:33:29
Message-ID: 14092.1307460809@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Anton Dedov <adedov(at)parallels(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-06-07 15:41:22
Subject: Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view
Previous:From: Robert HaasDate: 2011-06-07 15:28:40
Subject: Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group