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

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 (view raw or flat)
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

sfpug by date

Next:From: Stephan SzaboDate: 2003-05-20 17:52:03
Subject: Re: DDL triggers?
Previous:From: David FetterDate: 2003-05-20 16:59:14
Subject: Re: DDL triggers?

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