pgtcl: Change in behavior of pg_result -oid, vs documentation

From: ljb <lbayuk(at)mindspring(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: pgtcl: Change in behavior of pg_result -oid, vs documentation
Date: 2002-11-07 01:26:46
Message-ID: aqcfgm$1bk4$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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:

--- 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>

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Payman 2002-11-07 14:23:32 Re: PQcmdTuples() declaration
Previous Message Stephen Whinston 2002-11-06 21:42:54 Simple compile question