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

Re: RESULT_OID Bug

From: "Kevin McArthur" <postgresql-list(at)stormtide(dot)ca>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RESULT_OID Bug
Date: 2005-07-26 23:38:21
Message-ID: 00ec01c5923b$1c3cce80$0701a8c0@kdesktop (view raw or flat)
Thread:
Lists: pgsql-hackers
I cannot repoduce your experience with this bug. No matter what I do,
reconnect session or otherwise, it never returns a proper oid on the newer
cvs vers (I suspect it may be related to the roles update)

Kevin

----- Original Message ----- 
From: "Michael Fuhr" <mike(at)fuhr(dot)org>
To: "Kevin McArthur" <postgresql-list(at)stormtide(dot)ca>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Sent: Tuesday, July 26, 2005 4:19 PM
Subject: Re: [HACKERS] RESULT_OID Bug


> On Tue, Jul 26, 2005 at 03:36:26PM -0700, Kevin McArthur wrote:
>> 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.
>
> The function appears to work in a session until you replace it (or
> drop and recreate it), after which you get NULL.  If you exit the
> session and reconnect then it works again.  I checked 8.0.3 and it
> doesn't have this problem.
>
> -- 
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly
> 


In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2005-07-26 23:57:49
Subject: Re: ENUM type
Previous:From: Kevin McArthurDate: 2005-07-26 23:36:59
Subject: Re: RESULT_OID Bug

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