Re: FK NOT VALID can't be deferrable?

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FK NOT VALID can't be deferrable?
Date: 2011-06-15 21:46:26
Message-ID: BANLkTiktqimf603Ze4Cd4-jNQcawNQJzbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 15, 2011 at 9:59 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Excerpts from Simon Riggs's message of mié jun 15 16:31:45 -0400 2011:
>> On Wed, Jun 15, 2011 at 9:14 PM, Alvaro Herrera
>> <alvherre(at)commandprompt(dot)com> wrote:
>>
>> > So is somebody from 2nd Quadrant going to supply a patch to fix this?
>>
>> My understanding was that your patch had a bug, rather than the
>> existing code. If I misunderstood, please explain the bug.
>
> This is about FOREIGN KEY NOT VALID, which is your patch that's already
> in 9.1.  My patch doesn't touch foreign keys.  CHECK constraints cannot
> be deferrable anyway.

OK, thanks. My bug, my responsibility to provide a solution.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-06-15 21:50:15 Re: pg_upgrade using appname to lock out other users
Previous Message Tom Lane 2011-06-15 21:46:10 Re: Why polecat and colugos are failing to build back branches