troubleshooting PGError

From: slavix <mikerin(dot)slava(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: troubleshooting PGError
Date: 2011-11-09 05:02:40
Message-ID: 766d6fc7-c1c7-40c4-bd30-1989b9e0e590@j19g2000pro.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I am new to postgres, but need to resolve this error:

PGError: ERROR: current transaction is aborted, commands ignored
until end of transaction block
: SELECT 1 FROM "trades" WHERE ("trades"."uuid" =
'bc8d86e6-0a8d-11e1-a345-001d09203579' AND "trades"."id" != 25) LIMIT
1

Don't know what is the problem, tried running the same query in
pgAdmin and the query runs fine..
I don't know what the error actually is since the error message is not
clear. Any ideas on how to investigate this?

thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Markus 2011-11-09 06:33:44 Re: Grouping logs by ip and time
Previous Message Ondrej Ivanič 2011-11-09 00:43:53 Re: Postgres vs other Postgres based MPP implementations