Re: CALL versus procedures with output-only arguments
От
Peter Eisentraut
Тема
Re: CALL versus procedures with output-only arguments
Дата
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 по дате отправления