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

Re: Table rewrites vs. pending AFTER triggers

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Table rewrites vs. pending AFTER triggers
Date: 2008-01-03 14:35:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Simon Riggs wrote:
> On Tue, 2008-01-01 at 16:09 -0500, Tom Lane wrote:
> > Paranoia would
> > suggest forbidding *any* form of ALTER TABLE when there are pending
> > trigger events, but maybe that's unnecessarily strong.
> That works for me. Such a combination makes no sense, so banning it is
> the right thing to do.

I disagree.  This is an implementation limitation, so it makes sense to
try to restrict the user as least as possible.

Alvaro Herrera                      
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to


pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2008-01-03 14:39:26
Subject: Re: Autovacuum & Table List Ordering
Previous:From: Glyn AstillDate: 2008-01-03 13:39:56

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