> -----Original Message----- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Andres Freund > Sent: 06 December 2012 20:04 > To: Simon Riggs > Cc: Robert Haas; Dimitri Fontaine; Josh Berkus; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] ALTER TABLE ... NOREWRITE option > > I don't see any difference between an event trigger and these > statements... > > > > BEGIN; > > ALTER TABLE x ...; > > SELECT somefunction(); > > ALTER TABLE y ...; > > COMMIT; > > Event triggers get called *during* the ALTER TABLE. So if were not careful > they see something thats not easy to handle. >
I thought the point of this was to call the trigger *before* anything happens. Regards Petr Jelinek -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers