Re: "current transaction is aborted, commands ignored until

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: "current transaction is aborted, commands ignored until
Date: 2005-05-06 08:12:11
Message-ID: 427B26DB.4010505@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ying Lu wrote:
> Greetings,
>
> Through java - JDBC, trying to do "select * from Table" using "lock
> table IN SHARE MODE"; Always got this error:
>
> "current transaction is aborted, commands ignored until end of
> transaction block"

One of your commands has an error, and the transaction has been aborted
because of that. PostgreSQL will have returned an error message telling
you what the problem was.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Wilson 2005-05-06 08:36:46 Re: Slony v. DBMirror
Previous Message Richard Huxton 2005-05-06 07:10:48 Re: Howto prevent write based on date