RESULT_OID Bug - Mailing list pgsql-hackers

From Kevin McArthur
Subject RESULT_OID Bug
Date
Msg-id 009501c59232$766185d0$0701a8c0@kdesktop
Whole thread Raw
Responses Re: RESULT_OID Bug
List 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
 

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC
Next
From: "Jim C. Nasby"
Date:
Subject: Re: ENUM type