From: brendanl@iname.com
To: pgsql-sql@postgresql.org
Subject: Different query results in psql and Perl DBI with Postgres 7.2.1
Date: 7 Jan 2004 03:14:40 -0800
Message-ID: <cf7bc53b.0401070314.41bc05ad@posting.google.com> (raw)
I have a script that updates one record in a PostgreSQL 7.2.1 database
through the Perl DBI.
Here is the output from my log, which outputs the query sent to the
DBI and the return value:
---
Update query: UPDATE item SET status='SOLD' WHERE item_id=1129832
1 rows affected.
Update query: UPDATE item SET status='STORE' WHERE item_id=1130081
0E0 rows affected.
---
In both cases, the target record exists without question, and in the
latter case, I receive the expected "UPDATE 1" when I execute the same
query from within psql.
Even more perplexing: the "0E0" occurs ONLY when setting status to
'STORE', and not 100% of the time. (though it happens far more often
than not.) It seems to operate in stretches, too: when I am getting
1-row updates back from the latter query type, it happens several
times in succession.
Where do I even begin to attempt a diagnosis?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: brendanl@iname.com
Subject: Re: Different query results in psql and Perl DBI with Postgres 7.2.1
In-Reply-To: <cf7bc53b.0401070314.41bc05ad@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox