Re: insert/update/delete returning and rules

On 8/15/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Jaime Casanova" <systemguards@gmail.com> writes:
> > I'm doing some tests of Bernd's updatable views patch and found
> > something interesting about the RETURNING behavior
> > ...
> > but if i insert using the rules the returning clause is ignored
> > testing_uv=# insert into v_bar values (3), (4) returning *;
> > INSERT 0 2
>
> What are you testing exactly?  I think this recent fix might be
> relevant:
> http://archives.postgresql.org/pgsql-committers/2006-08/msg00299.php
>

i have tested again against current HEAD... what i do is to create a
table and then a view against that table... then the rules... you can
use the exact case i posted earlier...

then the insert into view (view + rules defined on it) returning will
not have the same behavior that insert into table...

-- 
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."                                      Richard Cook