Re: FK NOT VALID can't be deferrable? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: FK NOT VALID can't be deferrable?
Date
Msg-id 1308171285-sup-5007@alvh.no-ip.org
Whole thread Raw
In response to Re: FK NOT VALID can't be deferrable?  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: FK NOT VALID can't be deferrable?
List pgsql-hackers
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@commandprompt.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.

> In terms of "2ndQuadrant" supplying patches, you may not be aware that
> we all work independently on community contributions...

I wasn't, but that doesn't change anything -- I mean, you were from 2nd
Quadrant last time I checked.  If Jaime is going to submit a patch to
fix the bug, I assume you're fine with that too?

(The other alternative is to leave the bug open until Robert or Tom fix
it, I guess)

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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: creating CHECK constraints as NOT VALID
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade using appname to lock out other users