On Thu, Jan 20, 2011 at 8:46 AM, Scott Marlowe <[email protected]> wrote: > On Thu, Jan 20, 2011 at 5:00 AM, French, Martin <[email protected]> > wrote: > >> Personally, I'd rather >> not go trawling through what can only be described as hundreds of >> thousands of lines of PostgreSQL log to find THE RIGHT DDL statements. > > Oh that's easy. Grep out the statements that start with alter etc, > ptu them all in a big email, send them to all the developers and tell > them to let you know which ones need applying to QA / Staging / etc. > Can't get your DDL to the DBA? Your code won't work. You break the > build because of that, you get to fix it.
Note that I also mentioned turning on logging JUST ddl statements. Assumiing you're not logging EVERYTHING in development (and why would you) you should only have a few dozen lines of log to grep, and little or none of it will be things other than DDL. -- To understand recursion, one must first understand recursion. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
