> -----Original Message----- > From: [email protected] [mailto:pgsql-hackers- > [email protected]] On Behalf Of Andres Freund > Sent: 06 December 2012 20:04 > To: Simon Riggs > Cc: Robert Haas; Dimitri Fontaine; Josh Berkus; [email protected] > 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
