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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Commits 8de72b and 5457a1 (COPY FREEZE)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: ALTER TABLE ... NOREWRITE option