Re: ALTER TABLE ... NOREWRITE option

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: Whole Thread | Raw Message | 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

In response to

Responses

Browse pgsql-hackers by date

  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)