RESULT_OID Bug

From: "Kevin McArthur" <postgresql-list(at)stormtide(dot)ca>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: RESULT_OID Bug
Date: 2005-07-26 22:36:26
Message-ID: 009501c59232$766185d0$0701a8c0@kdesktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Recent cvs versions are failing the following script;

create table oidtest(a time default now()) with oids;

CREATE OR REPLACE FUNCTION oidtest() RETURNS integer AS $oidtest$
DECLARE
insert_oid_var INTEGER;
BEGIN
INSERT INTO oidtest DEFAULT VALUES;
GET DIAGNOSTICS insert_oid_var = RESULT_OID;
RETURN insert_oid_var;
END;
$oidtest$ Language plpgsql;

select oidtest();

if its working you will see an oid, if its failing you will see 1 row with blank data.

Kevin McArthur

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2005-07-26 22:39:46 Re: ENUM type
Previous Message Jim C. Nasby 2005-07-26 22:34:11 Re: ENUM type