Re: Newbie to Postgres - Urgent query

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 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 results are generated -
> >
> > "NOTICE: current transaction is aborted, queries ignored until end of
> > transaction block"
>
> 1. Check the return-values of your calls (e.g. connect, exectute...)
> 2. Turn on statement logging in PG to see what is happening.
>
> If the return values and the logs don't seem to help, post both back here and
> we'll see what we can do.

----------------------------------------------------------------

NETCORE SOLUTIONS *** Ph: +91 22 5662 8000 Fax: +91 22 5662 8134

MailServ and FlexiMail: Messaging Solutions: http://netcore.co.in

Pragatee: Integrated Server-Software Suite: http://www.pragatee.com

Emergic Freedom: Server-centric Computing: http://www.emergic.com

BlogStreet: Blog Profiles and RSS Ecosystem: http://blogstreet.com

Deeshaa: Rural Development: http://www.deeshaa.com

Rajesh Jain's Weblog on Technology: http://www.emergic.org
----------------------------------------------------------------