Re: oids vs composite types, in cvs head

On Tue, Jul 05, 2005 at 10:55:38PM -0400, Tom Lane wrote:
> 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?

It fails for any system column -- weren't there some changes recently
in how system columns are handled?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/