Re: [HACKERS] proposal and patch : support INSERT INTO...RETURNING with partitioned table using rule

2012-06-22 Thread Robert Haas
On Wed, Jun 20, 2012 at 12:24 PM, John Lumby johnlu...@hotmail.com wrote:     An INSERT which has a RETURNING clause and which is to be rewritten based on     a rule will be accepted if the rule is an unconditional DO INSTEAD.     In general I believe unconditional means no WHERE clause, but

[HACKERS] proposal and patch : support INSERT INTO...RETURNING with partitioned table using rule

2012-06-20 Thread John Lumby
--- Problem I'm trying to solve:     For partitioned tables,  make it possible to use RETURNING clause on INSERT INTO    together with DO INSTEAD rule [  Note  -  wherever I say INSERT I also mean UPDATE and DELETE ] ---

Re: [HACKERS] proposal and patch : support INSERT INTO...RETURNING with partitioned table using rule

2012-06-20 Thread Kevin Grittner
John Lumby johnlu...@hotmail.com wrote: I attach patch based on clone of postgresql.git as of yesterday Please read about the CommitFest process: http://wiki.postgresql.org/wiki/CommitFest and add your patch to the open CF: https://commitfest.postgresql.org/action/commitfest_view/open