Обсуждение: "current transaction is aborted, commands ignored until end of transaction block" Error

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"

Some clues about it?

Thanks a lot!
Emi

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