Re: [NOVICE] SQL error code -601 <ECPG_WARNING_QUERY_IGNORED>

From: daq <daq(at)ugyvitelszolgaltato(dot)hu>
To: jason(dot)ctr(dot)alburger(at)faa(dot)gov
Cc: Pgsql-sql(at)postgresql(dot)org
Subject: Re: [NOVICE] SQL error code -601 <ECPG_WARNING_QUERY_IGNORED>
Date: 2005-08-03 13:59:38
Message-ID: 13029180406.20050803155938@ugyvitelszolgaltato.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

jcafg> All,

jcafg> I recevied the SQL error code -601 <ECPG_WARNING_QUERY_IGNORED> from an
jcafg> embedded C SQL EXEC statement

jcafg> ie, EXEC SQL DELETE FROM foo WHERE number = 999999;

jcafg> I've googled the error code, but the only thing I can come up with is
jcafg> "current transaction is aborted, queries ignored until the end of
jcafg> transaction block".

jcafg> Can anybody provide me with a better explanation of what the error means &
jcafg> what circumstances generate the error? Is this error just a warning that
jcafg> can be logged and ignored, or is there a major problem at this point?

jcafg> Thanks in advance!!

A query failed inside a transaction. All other DML query inside
this transaction skipped.

DAQ

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message jason.ctr.alburger 2005-08-03 14:19:25 Fw: SQL error code -601 <ECPG_WARNING_QUERY_IGNORED>
Previous Message jason.ctr.alburger 2005-08-03 12:53:37 SQL error code -601 <ECPG_WARNING_QUERY_IGNORED>

Browse pgsql-sql by date

  From Date Subject
Next Message codeWarrior 2005-08-03 15:38:18 Re: Breakdown results by month
Previous Message jason.ctr.alburger 2005-08-03 12:53:37 SQL error code -601 <ECPG_WARNING_QUERY_IGNORED>