Re: Triggers with DO functionality - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Triggers with DO functionality
Date
Msg-id 1329499608.28565.19.camel@vanquo.pezone.net
Whole thread Raw
In response to Triggers with DO functionality  (Thom Brown <thom@linux.com>)
Responses Re: Triggers with DO functionality  (Thom Brown <thom@linux.com>)
List pgsql-hackers
On fre, 2012-02-17 at 13:22 +0000, Thom Brown wrote:
> So instead of
> 
> CREATE TRIGGER...
> EXECUTE PROCEDURE functioname();
> 
> you'd have:
> 
> CREATE TRIGGER...
> DO $$
> ...
> $$; 

I had wished for this many times and was about to propose something
similar.

We might wish to review the SQL standard and other implementations to
make porting triggers a bit easier too.

Also, whatever ALTER functionality functions have would have to be made
available here as well.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Displaying accumulated autovacuum cost
Next
From: "Kevin Grittner"
Date:
Subject: Re: MySQL search query is not executing in Postgres DB