From: ljb <lbayuk@mindspring.com>
To: pgsql-interfaces@postgresql.org
Subject: pgtcl: Change in behavior of pg_result -oid, vs documentation
Date: Thu, 7 Nov 2002 01:26:46 +0000 (UTC)
Message-ID: <aqcfgm$1bk4$1@news.hub.org> (raw)
I'm using libpgtcl with PostgreSQL-7.2.3.
There is a discrepancy between the documentation and behavior of
"pg_result $res -oid" when $res is not from an INSERT. The documentation
says it should return an empty string, but in fact it returns 0. I think
it used to return an empty string around PostgreSQL-7.1.3 when PQoidStatus()
was used, but now it uses PQoidValue() which returns InvalidOid, 0 in this
case.
Assuming the current behavior is desired, here is a patch to the
documentation doc/src/sgml/libpgtcl.sgml to match what really happens:
inline patch 1: libpgtcl.sgml (+1/-1 lines) download inline-1.patch--- libpgtcl.sgml.orig 2002-01-20 17:19:56.000000000 -0500+++ libpgtcl.sgml 2002-11-04 21:36:22.000000000 -0500@@ -704,7 +704,7 @@
<LISTITEM>
<PARA>
if the command was an INSERT, the OID of the
-inserted tuple; otherwise an empty string.+inserted tuple; otherwise 0.
</PARA>
</LISTITEM>
</VARLISTENTRY>
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-interfaces@postgresql.org
Cc: lbayuk@mindspring.com
Subject: Re: pgtcl: Change in behavior of pg_result -oid, vs documentation
In-Reply-To: <aqcfgm$1bk4$1@news.hub.org>
* 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