Re: Triggers on system catalog - Mailing list pgsql-hackers

From David Fetter
Subject Re: Triggers on system catalog
Date
Msg-id 20110330135943.GD10993@fetter.org
Whole thread Raw
In response to Re: Triggers on system catalog  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Triggers on system catalog
List pgsql-hackers
On Tue, Mar 29, 2011 at 08:21:04PM -0400, Robert Haas wrote:
> On Mar 29, 2011, at 2:17 PM, Christopher Browne <cbbrowne@gmail.com> wrote:
> > A proposal to adding triggers to system catalog tables won't be
> > terribly popular.
> 
> Well, I'd support it if I thought it had any chance of actually
> working, but I don't.
> 
> I do think we need some kind way of capturing DDL events, though. I
> wonder if the object-access-hook stuff KaiGai and I did to support
> SE-PostgreSQL could be extended to meet this need...

Jan Wieck sketched out a proposal, which I'll post in more detail when
I've transcribed it and checked that with him.  Part of it is to fire
triggers on the command completion code, and there are some code
cleanups that that would depend on.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Replication server timeout patch
Next
From: Merlin Moncure
Date:
Subject: Re: Process local hint bit cache