Skip site navigation (1) Skip section navigation (2)

Re: logging as inserts

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, jd(at)commandprompt(dot)com
Subject: Re: logging as inserts
Date: 2005-03-03 22:14:50
Message-ID: 200503031414.50818.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2005-03-03 22:45:29
Subject: Re: logging as inserts
Previous:From: Tom LaneDate: 2005-03-03 22:05:40
Subject: Solving hash table overrun problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group