Re: [GENERAL] Newbie to Postgres - Urgent query

2004-01-16 Thread Ritu Khetan
Hi, Oh ok..my conf didnt show the log_statement option. Thanks, should be helpful some other time. Regards, Ritu On Fri, 2004-01-16 at 17:39, Shridhar Daithankar wrote: On Friday 16 January 2004 16:43, Ritu Khetan wrote: > Hi, > > No such option found. There is the "S" switch for silent mod

Re: [GENERAL] Newbie to Postgres - Urgent query

2004-01-16 Thread Shridhar Daithankar
On Friday 16 January 2004 16:43, Ritu Khetan wrote: > Hi, > > No such option found. There is the "S" switch for silent mode which is > off by default anyways. In my local installation I have following relevant options. #log_connections = false #log_duration = false #log_pid = false #log_statemen

Re: [GENERAL] Newbie to Postgres - Urgent query

2004-01-16 Thread Ritu Khetan
Hi all,   I discovered the problem, AutoCommit is off by default and I did not commit the transaction..it works fine now. Thanks, Ritu On Fri, 2004-01-16 at 16:56, Csaba Nagy wrote: Have you read the documentation about configuring the postgres server: http://www.postgresql.org/docs/view.ph

Re: [GENERAL] Newbie to Postgres - Urgent query

2004-01-16 Thread Csaba Nagy
Have you read the documentation about configuring the postgres server: http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=runtime.html Actually there is a very fine suite of documentation on that site. HTH, Csaba. On Fri, 2004-01-16 at 12:13, Ritu Khetan wrote: > Hi, > > No such opt

Re: [GENERAL] Newbie to Postgres - Urgent query

2004-01-16 Thread Ritu Khetan
Hi, No such option found. There is the "S" switch for silent mode which is off by default anyways. Regards, Ritu On Fri, 2004-01-16 at 16:34, Shridhar Daithankar wrote: On Friday 16 January 2004 16:03, Ritu Khetan wrote: > Hello Richard, > >How do I switch on statement logging...? > >

Re: [GENERAL] Newbie to Postgres - Urgent query

2004-01-16 Thread Shridhar Daithankar
On Friday 16 January 2004 16:03, Ritu Khetan wrote: > Hello Richard, > >How do I switch on statement logging...? > >postmaster --help doesn't talk of any such switch. Check options in postgresql.conf. Shridhar ---(end of broadcast)--- TI

Re: [GENERAL] Newbie to Postgres - Urgent query

2004-01-16 Thread Ritu Khetan
Hello Richard,    How do I switch on statement logging...?    postmaster --help doesn't talk of any such switch. Regards, Ritu On Fri, 2004-01-16 at 15:25, Richard Huxton wrote: On Friday 16 January 2004 09:18, Ritu Khetan wrote: > Hello all, > > I am trying to use DBI in perl to conne

Re: [GENERAL] Newbie to Postgres - Urgent query

2004-01-16 Thread Richard Huxton
On Friday 16 January 2004 09:18, Ritu Khetan wrote: > Hello all, > > I am trying to use DBI in perl to connect to my Postgres database. I > am able to connect to the database but when any further queries are made > using the database handle, I see the following message in my error logs > and no