From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>,
Darren Duncan <darren(at)darrenduncan(dot)net>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: returning multiple result sets from a stored procedure
Date:
2010-09-09 21:07:41
Message-ID:
6465.1284066461@sss.pgh.pa.us (view raw or flat )
Thread:
2010-09-02 22:25:45 from John Adams <john_adams_mail(at)yahoo(dot)com>
2010-09-02 23:17:00 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-09-03 19:27:19 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-03 20:07:03 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-09-03 20:18:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-05 18:26:03 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-09-07 12:27:23 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-03 20:40:56 from John Adams <john_adams_mail(at)yahoo(dot)com>
2010-09-03 21:20:32 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-09-03 21:24:46 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-09-06 07:07:54 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-06 18:07:18 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-06 21:40:38 from David Fetter <david(at)fetter(dot)org>
2010-09-06 21:58:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-04 13:39:16 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-04 14:10:14 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-04 14:16:15 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-04 15:00:55 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-05 18:05:18 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-05 18:18:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-05 23:56:42 from Andrew Chernow <ac(at)esilo(dot)com>
2010-09-08 23:44:07 from John Adams <john_adams_mail(at)yahoo(dot)com>
2010-09-09 07:12:47 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 15:58:25 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-09 17:13:11 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 17:51:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 17:55:52 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 18:29:57 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 18:37:39 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-09-09 18:43:44 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:08:31 from Darren Duncan <darren(at)darrenduncan(dot)net>
2010-09-09 20:16:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 20:22:42 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-10 15:27:40 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-09-09 20:25:58 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-09 20:59:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 21:09:42 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-09 21:51:57 from Darren Duncan <darren(at)darrenduncan(dot)net>
2010-09-09 21:12:24 from Darren Duncan <darren(at)darrenduncan(dot)net>
2010-09-09 21:52:46 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:35:07 from Darren Duncan <darren(at)darrenduncan(dot)net>
2010-09-09 20:44:18 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-10 04:49:16 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-09-09 20:17:43 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:22:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-09 20:29:45 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:46:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-09 20:53:05 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:59:02 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 21:07:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 21:13:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 21:26:11 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-09 21:47:28 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 21:40:40 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-10 04:47:27 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-09-10 05:02:14 from Darren Duncan <darren(at)darrenduncan(dot)net>
Lists:
pgsql-hackers
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> To be honest, I am already pretty unhappy with
> the changes that make it impossible to redefined foo(a int) as
> foo(anteater int), which is a perfectly reasonable thing to want to do
> but which is now forbidden because someone MIGHT have called the
> function as foo(a := 3), and I certainly don't want to make it any
> worse. Whether there are actually any stored queries that call the
> function this way (or at all) is doesn't matter: it's not allowed.
BTW, before anyone suggests it: it wouldn't really improve matters if
we were to allow renaming so long as we couldn't find any such calls in
stored queries. We don't have any ability to track calls occuring in
stored procedures, let alone on the client side; so a rename would still
put you at very substantial risk of breaking things.
regards, tom lane
In response to
pgsql-hackers by date
Next :From: Kevin GrittnerDate: 2010-09-09 21:09:42Subject : Re: returning multiple result sets from a stored procedurePrevious :From : Tom LaneDate : 2010-09-09 20:59:28Subject : Re: returning multiple result sets from a stored procedure
