> >>I am looking at having one of our guys write up the code to allow
> >>logging as insert statements. I have a couple of questions.
> >>What would we like the postgresql.conf option to be? I was thinking
> >>log_statements_as_inserts = (t/f)
log_destination = 'inserts' #not a new GUC!
insert_columns = '%u,%d,%r,%p, ... %$'
#this new GUC would define a list of comma-seperated columns as escape codes
defined via the same code set as log_line_prefix. The only change would be
the addition of %$, which would symbolize the "statement" being logged.
I'd also assert that this option should log the inserts to a "stderr" and thus
take advantage of all of the redirection, rotation, etc that we now support
for stderr logging.
Aglio Database Solutions
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2005-03-03 19:23:25|
|Subject: Re: logging as inserts |
|Previous:||From: Tom Lane||Date: 2005-03-03 16:56:32|
|Subject: Re: 8.0.X and the ARC patent |