Tom Lane wrote:
Simple. Postmaster logs can roll over or otherwise be lost without
damaging the DB. This would provide a non-volatile log of DDLs.
In that case you have to provide a pretty strong argument why everyone
should be forced to have a non-volatile log of DDLs.
Conversely, why *only* DDL. As soon as we had this there would be a very
strong demand to log DML.
Maybe we need an optional asynch logging process as yet another member
of our growing band of specialist background processes.
What I would like to see is some builtin functions that give me the
table's DDL, just as pg_dump does. Extra nice would be complementary
functions that also give me skeleton select statements for each table or
view. I used to use such facilities a lot in years gone by, along with
c&p - maybe I'm just old-fashioned.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org