Re: Command Triggers

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>
Subject: Re: Command Triggers
Date: 2012-02-28 02:12:08
Message-ID: 1330394958-sup-6995@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Excerpts from Tom Lane's message of lun feb 27 20:54:41 -0300 2012:
> Andres Freund <andres(at)anarazel(dot)de> writes:
> > On Tuesday, February 28, 2012 12:30:36 AM Tom Lane wrote:
> >> Ugh ... if that's currently allowed, we definitely need to fix it.
>
> > Btw, whats the danger youre seing?
>
> Well, I'm not sure that it would actively break anything, but we
> definitely meant to disallow the case. Also, I seem to recall some
> places that intuit a relation's shared marker in the opposite direction
> (if it's in pg_global it must be shared), and that could definitely
> cause issues if we treat a rel as shared when it isn't.

The list of shared rels is hardcoded -- see IsSharedRelation.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2012-02-28 02:18:22 Re: Trigger execution role (was: Triggers with DO functionality)
Previous Message anarazel@anarazel.de 2012-02-28 00:29:20 Re: Command Triggers, patch v11