Re: [SQL] Different query results in psql and Perl DBI with Postgres 7.2.1

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brendan LeFebvre writes: > 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 upd

[SQL] 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

Re: [SQL] Different query results in psql and Perl DBI with Postgres 7.2.1

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Brendan LeFebvre) wrote: > I have a script that updates one record in a PostgreSQL 7.2.1 database > through the Perl DBI. > > Where do I even begin to attempt a diagnosis? Here is the output from a script I ran with no problems under 7.2.1, f