Re: Use of systable_beginscan_ordered in event trigger patch

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Dimitri Fontaine <dimitri@2ndquadrant.fr>, pgsql-hackers@postgresql.org
Date: 2012-12-13T23:25:13Z
Lists: pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Dec 12, 2012 at 3:51 PM, Dimitri Fontaine
> <dimitri@2ndquadrant.fr> wrote:
>> Robert, does that ring a bell to you? I'm going to crawl the archives
>> tomorrow if not

> Yeah, I'm pretty sure you can't set event triggers of any kind on
> event triggers.  You proposed to allow some stuff that would affect
> "every command", but I yelled and screamed about that until we got rid
> of it, 'cuz it just seemed way too dangerous.

In that case the docs should probably mention it more prominently;
the example in CREATE EVENT TRIGGER is misleadingly described, for sure.

I suspect there are still ways to shoot yourself in the foot with a
broken event trigger, but it's not quite as trivial as I thought.

			regards, tom lane