From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-sql@postgresql.org
Subject: Re: Different query results in psql and Perl DBI with Postgres 7.2.1
Date: Sun, 11 Jan 2004 19:17:26 -0000
Message-ID: <1e889f069f95de5a2abbb10bb4229457@biglumber.com> (raw)
In-Reply-To: <tbmoore-BAFC5F.07051008012004@news.ispnews.com>
-----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 updates back from the latter query type, it happens several
> times in succession.
"0E0" is perl's way of saying "0 but true", which means that the
statement succeeded, but did not return any rows. If it simply
returned a "0", we would not be able to differentiate between
an error (false) and no rows affected (0).
> Where do I even begin to attempt a diagnosis?
It looks as thogh the row you are trying to update does not
exist. Not much more advice is possible without seeing a more
complete sample of the code.
"boyd" writes:
> $info =~ s/0//g; # the get_info adds extraneous '0' to the version number
It is not extraneous: it is required per the ODBC spec. For a simpler
number, try using this:
my $pgversion = $dbh->{private_dbdpg}{server_version};
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200401111401
-----BEGIN PGP SIGNATURE-----
iD8DBQFAAaEwvJuQZxSWSsgRAk59AJ4zeNNm225TdecB2wgcQnFIJNqpmgCePmdX
XAPC7vVv+517CR2g3p/6U6c=
=oSYK
-----END PGP SIGNATURE-----
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: greg@turnstep.com
Subject: Re: Different query results in psql and Perl DBI with Postgres 7.2.1
In-Reply-To: <1e889f069f95de5a2abbb10bb4229457@biglumber.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