From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Kevin McArthur <postgresql-list(at)stormtide(dot)ca> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RESULT_OID Bug |
Date: | 2005-07-26 23:19:57 |
Message-ID: | 20050726231957.GA85084@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-07-26 23:24:02 | pgsql: Basic documentation for ROLEs. |
Previous Message | Tom Lane | 2005-07-26 23:15:24 | Re: Checkpoint cost, looks like it is WAL/CRC |