No, we don't. Right now you have to add log_connections, then link the query pid back to the user connection. Not sure how else we would do it because log_duration has to do the same linking. Ideas?
--------------------------------------------------------------------------- Christopher Kings-Lynne wrote: > Do we have log_username as an option? Would log the username that tried to > execute each query? > > Would be a useful option! > > Chris > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian > > - CVS > > Sent: Monday, 2 September 2002 7:26 AM > > To: [EMAIL PROTECTED] > > Subject: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ... > > > > > > CVSROOT: /cvsroot > > Module name: pgsql-server > > Changes by: [EMAIL PROTECTED] 02/09/01 19:26:06 > > > > Modified files: > > doc/src/sgml : func.sgml runtime.sgml > > src/backend/tcop: postgres.c > > src/backend/utils/misc: guc.c postgresql.conf.sample > > src/bin/psql : tab-complete.c > > src/include/utils: guc.h > > > > Log message: > > Add log_duration to GUC/postgresql.conf. > > > > Rename debug_print_query to log_statement and rename > > show_query_stats to > > show_statement_stats. > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
