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/