[HACKERS] oids vs composite types, in cvs head

2005-07-05 Thread Andrew - Supernews
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? -- Andrew, Supernews

Re: [HACKERS] oids vs composite types, in cvs head

2005-07-05 Thread Tom Lane
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

Re: [HACKERS] oids vs composite types, in cvs head

2005-07-05 Thread Michael Fuhr
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

Re: [HACKERS] oids vs composite types, in cvs head

2005-07-05 Thread Michael Fuhr
On Tue, Jul 05, 2005 at 09:22:37PM -0600, Michael Fuhr wrote: It fails for any system column -- weren't there some changes recently in how system columns are handled? ...or was that just discussion that never resulted in any changes? I'm still digging through the archives trying to find what

Re: [HACKERS] oids vs composite types, in cvs head

2005-07-05 Thread Andrew - Supernews
On 2005-07-06, Tom Lane [EMAIL PROTECTED] 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