> create view pg_locks as select l.relation, l.database, l.backendpid,
Bruce Momjian <bruce@momjian.us>
> 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. Joe Conway
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/nodes/outfuncs.c | modified | +2 −2 |
| src/backend/nodes/readfuncs.c | modified | +79 −1 |