Re: procedures and plpgsql PERFORM - Mailing list pgsql-hackers

From Tom Lane
Subject Re: procedures and plpgsql PERFORM
Date
Msg-id 10998.1513262319@sss.pgh.pa.us
Whole thread Raw
In response to procedures and plpgsql PERFORM  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Responses Re: procedures and plpgsql PERFORM  (Merlin Moncure <mmoncure@gmail.com>)
Re: procedures and plpgsql PERFORM  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List 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 by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: [HACKERS] pgbench more operators & functions
Next
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] pgbench more operators & functions