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

Re: Triggers on system catalog

From: David Fetter <david(at)fetter(dot)org>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Christopher Browne <cbbrowne(at)gmail(dot)com>,Shridhar Polas <shridharpolas(at)gmail(dot)com>,"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Triggers on system catalog
Date: 2011-03-30 13:59:43
Message-ID: 20110330135943.GD10993@fetter.org (view raw or flat)
Thread:
Lists: 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(at)gmail(dot)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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Merlin MoncureDate: 2011-03-30 14:05:51
Subject: Re: Process local hint bit cache
Previous:From: Robert HaasDate: 2011-03-30 13:54:08
Subject: Re: Replication server timeout patch

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