Simon Riggs <si...@2ndquadrant.com> writes: > On 5 December 2012 09:46, John R Pierce <pie...@hogranch.com> wrote: >> On 12/5/2012 1:42 AM, Simon Riggs wrote: >>> >>> I think we need a parameter called >>> >>> schema_change_reporting = off (default) | on [USERSET] >>> >>> which displays relevant statistics/reports about the actions taken by >>> DDL statements. That will also highlight locks and the need to reduce >>> their lock levels. >> >> >> where does this get displayed? is it just tossed into the postgres log >> files? > > Good question. Where would you like?
What about pg_stat_ddl, a new system's view? It would maybe need to have some xid/cid like ordering to be able to reproduce the script. It could also maybe use the ddl_rewrite module I'm working on for the event triggers framework, as far as "normalized SQL" goes. The rewrite information would be a boolean column in that view, I guess. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
