Re: ALTER TABLE ... NOREWRITE option
От | Petr Jelinek |
---|---|
Тема | Re: ALTER TABLE ... NOREWRITE option |
Дата | |
Msg-id | 004101cdd3e7$be1b51e0$3a51f5a0$@pjmodos.net обсуждение исходный текст |
Ответ на | Re: ALTER TABLE ... NOREWRITE option (Andres Freund <andres@2ndquadrant.com>) |
Ответы |
Re: ALTER TABLE ... NOREWRITE option
|
Список | pgsql-hackers |
> -----Original Message----- > From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers- > owner@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
В списке pgsql-hackers по дате отправления: