On Wed, Mar 30, 2011 at 9:59 AM, David Fetter <da...@fetter.org> wrote: > On Tue, Mar 29, 2011 at 08:21:04PM -0400, Robert Haas wrote: >> On Mar 29, 2011, at 2:17 PM, Christopher Browne <cbbro...@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.
See <http://wiki.postgresql.org/wiki/DDL_Triggers> That already captured an understanding of this, which might already be nearly adequate. -- http://linuxfinances.info/info/linuxdistributions.html -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
