On 8/15/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jaime Casanova" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
