On Tue, Jul 05, 2005 at 10:55:38PM -0400, Tom Lane wrote: > Andrew - Supernews <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
