Re: Newbie to Postgres - Urgent query - Mailing list pgsql-general

From Ritu Khetan
Subject Re: Newbie to Postgres - Urgent query
Date
Msg-id 1074249213.3623.15.camel@efv2.netcore.co.in
Whole thread Raw
In response to Re: Newbie to Postgres - Urgent query  (Richard Huxton <dev@archonet.com>)
Responses Re: Newbie to Postgres - Urgent query
dynamic queries
List pgsql-general
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
----------------------------------------------------------------

pgsql-general by date:

Previous
From: Paul Ganainm
Date:
Subject: How to become a Windows beta-tester?
Next
From: Shridhar Daithankar
Date:
Subject: Re: Newbie to Postgres - Urgent query