Re: [PATCH] Return command tag 'REPLACE X' for CREATE OR REPLACE statements. - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [PATCH] Return command tag 'REPLACE X' for CREATE OR REPLACE statements.
Date
Msg-id AANLkTi=74_7=vAyXNo9bWujui7K_B+vPSxE5GTEbPMX8@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Return command tag 'REPLACE X' for CREATE OR REPLACE statements.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH] Return command tag 'REPLACE X' for CREATE OR REPLACE statements.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Jan 14, 2011 at 1:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> If we're going to reject this patch on backwards-compatibility
>> grounds, we need to make an argument that the backward-compatibility
>> hazards are a real concern.  So, again, has anyone complained about
>> the changes we made in this area in 9.0?
>
> That 9.0 change was far less invasive than this: it only added a count
> field to SELECT and CTAS result tags.  Quite aside from the fact that
> the tag name stayed the same, in the SELECT case it's unlikely anyone
> would have checked the tag at all rather than just testing for
> PQresultStatus() == PGRES_TUPLES_OK.  So it was basically only changing
> the result for *one* command type.  I don't think it's a good basis for
> arguing that this patch won't cause problems.

Yeah, but that one command tag was SELECT.  That's a pretty commonly
used command.  Most production environments probably use all of the
commands affected by this patch together an order of magnitude less
often than they use SELECT.

Again, on what basis are we arguing that people are going to be
looking at the command tag of a command that always returns the same
tag?  That seems pretty darn unlikely to me.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: limiting hint bit I/O
Next
From: Robert Haas
Date:
Subject: Re: Error code for "terminating connection due to conflict with recovery"