Re: ERROR: fmgr_info: function 0: cache lookup failed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Pilosov <alex(at)pilosoft(dot)com>
Cc: Mourad EL HADJ MIMOUNE <mimoune(at)ensma(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: fmgr_info: function 0: cache lookup failed
Date: 2001-07-04 16:19:21
Message-ID: 27847.994263561@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alex Pilosov <alex(at)pilosoft(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Holmes 2001-07-04 16:38:04 Re: Re: lo wrappers - still working on it
Previous Message Philip Molter 2001-07-04 16:17:55 Re: Determining scan types