Обсуждение: Fw: SQL error code -601

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

Maybe meaning that the row I was trying to delete didn't exist?

Jason Alburger
609-485-7225
HID/NAS/LAN Engineer
Joseph Sheairs Associates, Inc.
FAA/AOS-330
----- Forwarded by Jason CTR Alburger/ACT/CNTR/FAA on 08/03/2005 10:18 AM
-----

             daq
             <daq@ugyvitelszol
             galtato.hu>                                                To
                                       Jason CTR Alburger/ACT/CNTR/FAA@FAA
             08/03/2005 09:59                                           cc
             AM                        Pgsql-sql@postgresql.org
                                                                   Subject
                                       Re: [NOVICE] SQL error code -601
             Please respond to         <ECPG_WARNING_QUERY_IGNORED>
                   daq16
             <daq@ugyvitelszol
                galtato.hu>







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

my relation works as follows...

serial_number is linked to job_number is linked to
product_nubmer (ie, job_number_id in serial number
table and product_id in job_number table).

the following query makes sense to me...

select t_serial_number.serial_number_id,
t_serial_number.serial_number
from t_serial_number, t_job_number, t_product
where t_product.product_id=2

however, this query also works...

select t_serial_number.serial_number_id,
t_serial_number.serial_number
from t_serial_number, t_product
where t_product.product_id=2

the difference is i ommitted any mention of the table
that links product to serial number (ie,
t_job_number).

which query is faster?  is the latter query ok to use
in a production environment or is the former query
"safer?"

also, in pgadmin, the query view clock (lower right)
is in the form of 10+20ms.  what does this "time"
format mean?

tia...



____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs