Re: WIP: Deferrable unique constraints - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: WIP: Deferrable unique constraints
Date
Msg-id 20090720023951.GI4938@alvh.no-ip.org
Whole thread Raw
In response to Re: WIP: Deferrable unique constraints  (Dean Rasheed <dean.a.rasheed@googlemail.com>)
Responses Re: WIP: Deferrable unique constraints  (Dean Rasheed <dean.a.rasheed@googlemail.com>)
Re: WIP: Deferrable unique constraints  (Dean Rasheed <dean.a.rasheed@googlemail.com>)
List pgsql-hackers
Dean Rasheed wrote:
> Thanks for the thorough review. I attach an new version of the patch,
> updated to HEAD, and with the index AM change discussed.

Wow, this is a large patch.

I didn't do a thorough review, but some quickies I noticed:

* Please move the code that says that it should be in a new file to a new file.

* Please don't mimic the silliness of RI_FKey_check of an unused return value.  Just make it return void, and have the
calleruse the proper PG_RETURN_FOO macro.  (Unless there's a specific reason to not do things that way)
 

* I'm not sure about the changes in trigger.h and related elsewhere. Seems related to the new list in
AfterTriggerSaveEvent,which is used in ways that seem to conflict with its header comment ... I wonder if we should be
doingthat in the executor itself instead. In any case it's inconsistent that the list is added to ExecARInsertTriggers
butnot to ExecARUpdateTrigger et al ...
 


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: join removal
Next
From: Alvaro Herrera
Date:
Subject: Re: make check failure for 8.4.0