Vang wrote:
Hello,
I'm using PostgreSQL 8.0 and Java in NetBeans IDE. In java I have a
method that does a "insert into" and it throws a "duplicate key
violates unique constraint." I call that method once and then call
another method which does a "select." However, when the select
method gets
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
be
On 19.04.2005 02:33 Kris Jurka wrote:
Is this a problem with the JDBC interface that I'm using, or is this a
general Postgres problem?
>>>
>
> This is an open todo item for the JDBC driver. It could be done by
> automatically wrapping all statements in savepoints behind the scenes.
>
On Tue, 19 Apr 2005, Thomas Kellerer wrote:
> Joshua D. Drake wrote on 19.04.2005 00:21:
> >> I'm having a bit of trouble with the error message from the subject.
> >> Is there a way to simply go on with my commands if I hit this error?
> >
> > Only if you are using savepoints (nested transact
Joshua D. Drake wrote on 19.04.2005 00:21:
I'm having a bit of trouble with the error message from the subject.
Is there a way to simply go on with my commands if I hit this error?
Only if you are using savepoints (nested transactions) otherwise you
must rollback.
Is this a problem with the JDBC
Thomas Kellerer wrote:
Hello,
I'm having a bit of trouble with the error message from the subject. Is
there a way to simply go on with my commands if I hit this error?
Only if you are using savepoints (nested transactions) otherwise you
must rollback.
Is this a problem with the JDBC interface th
Hi Michael:
Michael Fuhr wrote:
After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
are having intermitent issues with certain online PHP transactions,
returning this error:
"Warning: pg_exec() query failed: ERROR: current transaction is aborted,
commands ignored until end of
On Tue, Oct 05, 2004 at 07:54:23AM +0200, ruben wrote:
> After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
> are having intermitent issues with certain online PHP transactions,
> returning this error:
>
> "Warning: pg_exec() query failed: ERROR: current transaction is abort
