Re: logging as inserts - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: logging as inserts
Date
Msg-id 200503031414.50818.josh@agliodbs.com
Whole thread Raw
In response to Re: logging as inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: logging as inserts  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tom,

> But log_line_prefix works fine for all destinations, which is exactly
> why this new facility isn't a destination.  You're just confusing
> matters by wanting to treat it as one.

Hmmm ... hey, if we just allowed extra text in log_line_prefix, and allowed %$ 
to enclose the statement with literal quoting, you could do this all through 
log_line_prefix, as:

log_line_prefix='INSERT INTO pg_log VALUES ( %u, %p, ''%t'', ''%$'')'

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Solving hash table overrun problems
Next
From: Andrew Dunstan
Date:
Subject: Re: logging as inserts