470,647 Members | 1,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Different query results in psql and Perl DBI with Postgres 7.2.1

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?
Jul 19 '05 #1
0 1911

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Phil Campaigne | last post: by
6 posts views Thread by Uros | last post: by
4 posts views Thread by Brendan Jurd | last post: by
5 posts views Thread by Madison Kelly | last post: by
1 post views Thread by Josué Maldonado | last post: by
2 posts views Thread by Ron St-Pierre | last post: by
2 posts views Thread by Russ Brown | last post: by
33 posts views Thread by John Sidney-Woollett | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.