From:
Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
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-01-12 14:23:19
Message-ID:
4B4C85D7.1060409@cybertec.at (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
Tom Lane írta:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>
>> But it would be broken in very obvious ways, no? It's not like it would
>> be silently broken and thus escape testing ...
>>
>
> Well, if we wanted to adopt that approach, we should add the count to
> *all* SELECT tags not just a small subset. As the patch stands it
> seems entirely possible that a breakage would escape immediate notice.
>
> regards, tom lane
>
Can you give me an example that would return
plain "SELECT" after my new patch? I added
one more change to the patch, is it enough to return
"SELECT N" in every case now?
Best regards,
Zoltán Böszörményi
--
Bible has answers for everything. Proof:
"But let your communication be, Yea, yea; Nay, nay: for whatsoever is more
than these cometh of evil." (Matthew 5:37) - basics of digital technology.
"May your kingdom come" - superficial description of plate tectonics
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-01-12 14:25:59Subject : Re: NOT NULL violation and error-message Previous :From : Magnus HaganderDate : 2010-01-12 14:20:10Subject : Re: Streaming replication status
