Re: oids vs composite types, in cvs head - Mailing list pgsql-hackers

From Tom Lane
Subject Re: oids vs composite types, in cvs head
Date
Msg-id 21067.1120618538@sss.pgh.pa.us
Whole thread Raw
In response to oids vs composite types, in cvs head  (Andrew - Supernews <andrew+nonews@supernews.com>)
Responses Re: oids vs composite types, in cvs head
List pgsql-hackers
Andrew - Supernews <andrew+nonews@supernews.com> writes:
> This works on 7.4 and 8.0 but not in cvs head:
> create function foo(pg_type) returns oid as 'select $1.oid' language sql;
> ERROR:  column "oid" not found in data type pg_type
> CONTEXT:  SQL function "foo"

> Is this intentional, or did the no-oids-by-default changes cut too deep?

Hmm ... offhand, I'd say that if it worked in 8.0 it was only by chance.
In general a tuple that matches the signature of a pg_type row need not
contain an OID.  Still it does seem that we have broken some specific
cases that used to work.  Anyone want to dig into the details?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Dbsize backend integration
Next
From: Bruce Momjian
Date:
Subject: Re: timezone changes break windows and cygwin