Re: [HACKERS] log_line_info

2004-03-03 Thread Bruce Momjian
Andrew Dunstan wrote: > >> defaulting to the beginning if not found. > >> Examples: "%T [%P]: " (everybody gets timestamp and pid) > >> "%T [%P]: [EMAIL PROTECTED](%C:%S %I line:%L %X%T [%P]:" (same > >> effect > >> as example under previous point) > >> - something

Re: [HACKERS] log_line_info

2004-03-03 Thread Andrew Dunstan
Bruce Momjian said: > Andrew Dunstan wrote: >> >> I haven't had any other feedback on this patch that I posted. However, >> I'm a bit dissatisfied with it for a couple of reasons: >> >> . when a connection is logged we don't yet know the user and database, >> because we haven't processed the init

Re: [HACKERS] log_line_info

2004-03-02 Thread Bruce Momjian
Andrew Dunstan wrote: > > I haven't had any other feedback on this patch that I posted. However, > I'm a bit dissatisfied with it for a couple of reasons: > > . when a connection is logged we don't yet know the user and database, > because we haven't processed the initial packet yet. That cause

Re: [HACKERS] log_line_info plan

2004-02-18 Thread Andrew Dunstan
Tom Lane said: > Andrew Dunstan <[EMAIL PROTECTED]> writes: >> I am about to redo the patch that would allow tagging of log lines >> with info via a printf-style string. > >> Any comments or suggestions before I start? > > I think Bruce already applied the previous version of your patch. Not that

Re: [HACKERS] log_line_info plan

2004-02-17 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > I am about to redo the patch that would allow tagging of log lines with > info via a printf-style string. > Any comments or suggestions before I start? I think Bruce already applied the previous version of your patch. No problem with yanking it out f

Re: [HACKERS] log_line_info plan

2004-02-17 Thread Andrew Dunstan
Joshua D. Drake wrote: 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

Re: [HACKERS] log_line_info plan

2004-02-17 Thread Bruce Momjian
Joshua D. Drake wrote: > 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 >

Re: [HACKERS] log_line_info plan

2004-02-17 Thread Joshua D. Drake
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

Re: [HACKERS] log_line_info

2004-02-17 Thread Bruce Momjian
Andrew Dunstan wrote: > Rod Taylor wrote: > > >>and I'm willing to entertain other suggestions. > >> > >> > > > >Very nice, but you missed the most important. Command Tag. > > > > > > I've had a brief look at this proposal (to allow reporting of the > command tag along with username, datab