psql and INSERT/UPDATE/DELETE RETURNING
Currently, psql does not show the command completion tag if it gets a
PGRES_TUPLES_OK result. This means you won't see the tag for a command
with RETURNING, eg
regression=# insert into int8_tbl values(1,2),(3,4);
INSERT 0 2
regression=# insert into int8_tbl values(1,2),(3,4) returning *;
q1 | q2
----+----
1 | 2
3 | 4
(2 rows)
regression=#
The tag is actually being sent by the backend, it's just not displayed.
Do we like this behavior? The number-of-tuples part of the tag is
certainly redundant with the table display, but perhaps it's good to
have a reminder that the rows you are looking at were just INSERTed,
UPDATEd, or DELETEd. I haven't checked the code but I imagine it'd
not be very difficult to change the behavior if we wish.
Comments?
regards, tom lane
On Fri, Aug 11, 2006 at 10:58:12PM -0400, Tom Lane wrote:
Currently, psql does not show the command completion tag if it gets a
PGRES_TUPLES_OK result. This means you won't see the tag for a command
with RETURNING, egregression=# insert into int8_tbl values(1,2),(3,4);
INSERT 0 2
regression=# insert into int8_tbl values(1,2),(3,4) returning *;
q1 | q2
----+----
1 | 2
3 | 4
(2 rows)regression=#
The tag is actually being sent by the backend, it's just not displayed.
Do we like this behavior? The number-of-tuples part of the tag is
certainly redundant with the table display, but perhaps it's good to
have a reminder that the rows you are looking at were just INSERTed,
UPDATEd, or DELETEd. I haven't checked the code but I imagine it'd
not be very difficult to change the behavior if we wish.Comments?
Having both would be good :)
Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!