Re: DDL triggers?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: David Fetter <david(at)fetter(dot)org>, SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: DDL triggers?
Date: 2003-05-20 17:09:40
Message-ID: 200305201009.40124.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

David,

> > Alternately, we can raise this on -Hackers and see what the
> > difficulty would be for hacking some of the libraries to either:
> >
> > 1) save all DDL statements to a log, or:
>
> This would actually be a super-groovy thing in general, 'cause the
> stuff pg_dump spits out, while useful from a reloading point of view,
> is a royal PITA from a reverse-engineering point of view. Ideally,
> DDL's would get logged in the precise state (ideally, with "--"'s
> included) that they were in before they got executed.

I think this would be relatively easy; in fact, I'm sure that Joe Conway could
do it. Why don't you give him a buzz?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse sfpug by date

  From Date Subject
Next Message Stephan Szabo 2003-05-20 17:52:03 Re: DDL triggers?
Previous Message David Fetter 2003-05-20 16:59:14 Re: DDL triggers?