Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Josh BerkusDate: 2005-07-26 22:39:46
Subject: Re: ENUM type
Previous:From: Jim C. NasbyDate: 2005-07-26 22:34:11
Subject: Re: ENUM type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group