psql and INSERT/UPDATE/DELETE RETURNING

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: psql and INSERT/UPDATE/DELETE RETURNING
Date: 2006-08-12 02:58:12
Message-ID: 23362.1155351492@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Perez 2006-08-12 03:10:32 Re: An Idea for planner hints
Previous Message Tzahi Fadida 2006-08-12 01:52:01 Re: [PATCHES] Adding fulldisjunctions to the contrib