Re: procedures and plpgsql PERFORM

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: procedures and plpgsql PERFORM
Дата
Msg-id 10998.1513262319@sss.pgh.pa.us
обсуждение исходный текст
Ответ на procedures and plpgsql PERFORM  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Ответы Re: procedures and plpgsql PERFORM  (Merlin Moncure <mmoncure@gmail.com>)
Re: procedures and plpgsql PERFORM  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers
Ashutosh Bapat <ashutosh.bapat@enterprisedb.com> writes:
> We allow a function to be invoked as part of PERFORM statement in plpgsql
> ...
> But we do not allow a procedure to be invoked this way

> Procedures fit that category and like functions, I think, we should
> allow them be invoked directly without any quoting and CALL
> decoration.

How is that going to work?  What if the procedure tries to commit the
current transaction?

IOW, this is not merely a syntactic-sugar question.

            regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: [HACKERS] pgbench more operators & functions
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: [HACKERS] pgbench more operators & functions