| From: | "Petr Jelinek" <pjmodos(at)pjmodos(dot)net> |
|---|---|
| To: | "'Andres Freund'" <andres(at)2ndquadrant(dot)com>, "'Simon Riggs'" <simon(at)2ndQuadrant(dot)com> |
| Cc: | "'Robert Haas'" <robertmhaas(at)gmail(dot)com>, "'Dimitri Fontaine'" <dimitri(at)2ndquadrant(dot)fr>, "'Josh Berkus'" <josh(at)agliodbs(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE ... NOREWRITE option |
| Date: | 2012-12-06 19:27:33 |
| Message-ID: | 004101cdd3e7$be1b51e0$3a51f5a0$@pjmodos.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)org] On Behalf Of Andres Freund
> Sent: 06 December 2012 20:04
> To: Simon Riggs
> Cc: Robert Haas; Dimitri Fontaine; Josh Berkus;
pgsql-hackers(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2012-12-06 19:43:42 | Re: ALTER TABLE ... NOREWRITE option |
| Previous Message | Stephen Frost | 2012-12-06 19:18:23 | Re: Commits 8de72b and 5457a1 (COPY FREEZE) |