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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings