Re: CALL versus procedures with output-only arguments

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: CALL versus procedures with output-only arguments
Дата
в 11:21:34
Msg-id
cfc3c0c0-79c5-587a-68c2-651413899868@enterprisedb.com
Ответ на
Список
Дерево обсуждения
CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Andrew Dunstan <andrew@dunslane.net>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Robert Haas <robertmhaas@gmail.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Robert Haas <robertmhaas@gmail.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Andrew Dunstan <andrew@dunslane.net>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Andrew Dunstan <andrew@dunslane.net>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Andrew Dunstan <andrew@dunslane.net>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Andrew Dunstan <andrew@dunslane.net>
Re: CALL versus procedures with output-only arguments Laurenz Albe <laurenz.albe@cybertec.at>
Re: CALL versus procedures with output-only arguments "David G. Johnston" <david.g.johnston@gmail.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: CALL versus procedures with output-only arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: CALL versus procedures with output-only arguments Pavel Stehule <pavel.stehule@gmail.com>
On 24.05.21 02:01, Tom Lane wrote:
> I wrote:
>> I think we ought to fix this so that OUT-only arguments are ignored
>> when calling from SQL not plpgsql.
> 
> I'm working on a patch to make it act that way.  I've got some issues
> yet to fix with named arguments (which seem rather undertested BTW,
> since the patch is passing check-world even though I know it will
> crash instantly on cases with CALL+named-args+out-only-args).
> 
> Before I spend too much time on it though, I wanted to mention that
> it includes undoing 2453ea142's decision to include OUT arguments
> in pg_proc.proargtypes for procedures (but not for any other kind of
> routine).  I thought that was a terrible decision and I'm very happy
> to revert it, but is anyone likely to complain loudly?

I don't understand why you want to change this.  The argument resolution 
of CALL is specified in the SQL standard; we shouldn't just make up our 
own system.


В списке pgsql-hackers по дате отправления
От: Amit Kapila
Дата:
От: Magnus Hagander
Дата:
FAQ