Thread: 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