Re: BUG #13269: "alter constraint child_parent deferrable initially deferred" sometimes does not make FK deferred

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: piotr(dot)findeisen(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13269: "alter constraint child_parent deferrable initially deferred" sometimes does not make FK deferred
Date: 2015-05-11 14:41:39
Message-ID: 25350.1431355299@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

piotr(dot)findeisen(at)gmail(dot)com writes:
> Below follows SQL that in my opinion should fail at 'commit', i.e. after 6 s
> sleep. However, when run with psql, it fails immediately, as if FK was not
> made deferred.

This example works for me in current sources. I think it's probably a
duplicate of bug #13224 which was fixed last week.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2015-05-11 15:00:10 Re: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Previous Message Tom Lane 2015-05-11 14:37:32 Re: BUG #13267: Some timezones in pg_timezone_names are missing in pg_timezone_abbrevs