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
 

Reply via email to