Lists: | pgsql-novicepgsql-sql |
---|
From: | jason(dot)ctr(dot)alburger(at)faa(dot)gov |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | SQL error code -601 <ECPG_WARNING_QUERY_IGNORED> |
Date: | 2005-08-03 12:53:37 |
Message-ID: | OF3DD80DBD.05E66B2E-ON85257052.0043F81A-85257052.0046D3ED@faa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice pgsql-sql |
All,
I recevied the SQL error code -601 <ECPG_WARNING_QUERY_IGNORED> from an
embedded C SQL EXEC statement
ie, EXEC SQL DELETE FROM foo WHERE number = 999999;
I've googled the error code, but the only thing I can come up with is
"current transaction is aborted, queries ignored until the end of
transaction block".
Can anybody provide me with a better explanation of what the error means &
what circumstances generate the error? Is this error just a warning that
can be logged and ignored, or is there a major problem at this point?
Thanks in advance!!
Jason Alburger
609-485-7225
HID/NAS/LAN Engineer
Joseph Sheairs Associates, Inc.
FAA/AOS-330
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 |
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