From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc:
Boszormenyi Zoltan <zb(at)cybertec(dot)at>,
Hans-Juergen Schoenig <hs(at)cybertec(dot)at>,
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: [PATCH] Provide rowcount for utility SELECTs
Date:
2009-12-28 16:20:19
Message-ID:
11409.1262017219@sss.pgh.pa.us (view raw or flat )
Thread:
2009-12-28 09:57:58 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2009-12-28 10:08:13 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2009-12-28 10:17:22 from Hans-Juergen Schoenig <hs(at)cybertec(dot)at>
2009-12-28 10:20:57 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2009-12-28 16:08:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-28 16:14:04 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-12-28 16:20:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-28 18:29:01 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2009-12-28 20:18:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-29 07:50:49 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2009-12-29 13:35:52 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-12-29 15:24:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-12 14:23:19 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-01 20:42:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-02 09:03:21 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-07 05:01:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-07 17:46:18 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-08 04:17:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-08 10:53:34 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-11 18:52:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-12 15:48:32 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-12 17:34:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-12 18:22:06 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-12 18:38:11 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-12 18:55:36 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-12 20:06:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-14 03:15:26 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-14 03:30:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-16 20:58:23 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-12 18:29:08 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-11 19:04:08 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-11 19:25:48 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-11 19:38:53 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-11 19:42:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-11 19:47:26 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-11 19:50:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-11 20:09:06 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-02-11 20:00:56 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2009-12-28 17:10:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-29 07:58:14 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2009-12-29 08:06:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> On mn, 2009-12-28 at 11:08 -0500, Tom Lane wrote:
>> And, by the same token, the scope for possibly breaking clients is nearly
>> unlimited ...
> Why is that? Are there programs out there that expect PQcmdTuples() to
> return something that is *not* the tuple count for these commands and
> will violently misbehave otherwise?
It's more the possibility of doing strcmp(tag, "SELECT") on the command
tag that worries me. Describing the API change here as being limited
to PQcmdTuples misses the point rather completely: this is a protocol
change, and could break both clients and non-libpq driver libraries.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2009-12-28 16:31:13
Subject : Re: Removing pg_migrator limitations
Previous :From : Simon RiggsDate : 2009-12-28 16:14:12
Subject : Re: updateMinRecoveryPoint bug?