Re: log_line_info plan

Joshua D. Drake <jd@commandprompt.com>

From: "Joshua D. Drake" <jd@commandprompt.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2004-02-18T03:08:42Z
Lists: pgsql-hackers

Attachments

Andrew Dunstan wrote:
> 
> I am about to redo the patch that would allow tagging of log lines with 
> info via a printf-style string.
> 
> Current plans are to call the config parameter "log_line_info" and 
> implement the following escapes:
> 
> %U = user
> %D = database
> %T = timestamp
> %P = pid
> %L = session log line number
> %C = sessionid cookie (hex encoded session start time + pid)
> %S = session start timestamp
> %I = Command Tag (e.g. "CREATE TABLE")
> 
> Any comments or suggestions before I start?

My be kind of cool if we a a duration variable in there, especially if 
combined with %I

J



> 
> cheers
> 
> andrew
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL