Re: Newbie to Postgres - Urgent query

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ritu Khetan <ritu(at)netcore(dot)co(dot)in>, pgsql-general(at)postgresql(dot)org
Subject: Re: Newbie to Postgres - Urgent query
Date: 2004-01-16 09:55:23
Message-ID: 200401160955.23040.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2004-01-16 10:28:41 Re: tinterval operators and functions
Previous Message Richard Huxton 2004-01-16 09:46:59 Re: tinterval operators and functions