Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: fmgr_info: function 0: cache lookup failed - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: fmgr_info: function 0: cache lookup failed
Date
Msg-id 27847.994263561@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: fmgr_info: function 0: cache lookup failed  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-general
Tree view 
Alex Pilosov <alex@pilosoft.com> writes:
> Currently, you must do:
> CREATE FUNCTION tabrecord (OID) returns tab1 AS '...

Right, "returns record" is bogus.  The reason for the peculiar
error message seems to be that plpgsql is sloppy about checking
pg_type.typisdefined before believing that it has a valid type name.
I suspect this oversight is widespread :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: lo wrappers - still working on it
Next
From: Philip Molter
Date:
Subject: Re: Determining scan types