Re: anonymous composite types

From: Joe Conway <mail(at)joeconway(dot)com>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: anonymous composite types
Date: 2002-08-07 02:14:45
Message-ID: 3D508295.5070500@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Neil Conway wrote:
> This does not:
>
> create view pg_locks as select l.relation, l.database, l.backendpid,
> l.mode, l.isgranted from pg_lock_info() as l(relation oid, database oid,
> backendpid int4, mode text, isgranted bool);
> ERROR: badly formatted planstring "COLUMNDEF "...
>

Reported by Neil Conway -- I never implemented readfuncs.c support for
ColumnDef or TypeName, which is needed so that views can be created on
functions returning type RECORD. Here's a patch.

If there are no objections, please apply.

Thanks,

Joe

Attachment Content-Type Size
pseudo-type-viewsupp.2002.08.06.1.patch text/plain 4.2 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-08-07 02:32:22 Re: anonymous composite types
Previous Message Bruce Momjian 2002-08-07 01:40:53 Re: CLUSTER patch and regression test