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