From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Boszormenyi Zoltan <zb(at)cybertec(dot)at>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, 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:
2010-02-12 17:34:21
Message-ID:
603c8f071002120934t3476e01evd4686ad2b343f640@mail.gmail.com (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
On Fri, Feb 12, 2010 at 10:48 AM, Boszormenyi Zoltan <zb(at)cybertec(dot)at> wrote:
> I added a small change to protocol.sgml for the
> "CommandComplete" message describing the change.
> Is it enough?
Ah, I didn't even see that that section needed to be updated. Good
catch. I'd suggest the following wording:
For a <command>SELECT</command> or <command>CREATE TABLE AS</command>
command, the tag is SELECT rows... [and the rest as you have it]
We should probably also retitle that section from "Retrieving Result
Information for Other Commands" to "Retrieving Other Result
Information" and adjust the text of the opening sentence similarly.
Also I think you need to update the docs for PQcmdtuples to mention
that it not works for SELECT and CTAS.
...Robert
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-02-12 17:47:19Subject : Re: review: More frame options in window functions Previous :From : Dimitri FontaineDate : 2010-02-12 17:25:02Subject : Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL
