Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group