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
|
- [HACKERS] RESULT_OID Bug Kevin McArthur
- Re: [HACKERS] RESULT_OID Bug Michael Fuhr
- Re: [HACKERS] RESULT_OID Bug Kevin McArthur
- Re: [HACKERS] RESULT_OID Bug Michael Fuhr
- Re: [HACKERS] RESULT_OID Bug Kevin McArthur
- Re: [HACKERS] RESULT_OID Bug Michael Fuhr
- Re: [HACKERS] RESULT_OID Bug Tom Lane
- Re: [HACKERS] RESULT_OID Bug Michael Fuhr
- Re: [HACKERS] RESULT_OID Bug Tom Lane
- Re: [HACKERS] RESULT_OID Bug Michael Fuhr
- Re: [HACKERS] RESULT_OID Bug Neil Conway