
> Removing the special-case logic in ExecTypeFromTL yields
> 
> regression=# SELECT update_pg_pwd();
> ERROR:  getTypeOutputInfo: Cache lookup of type 0 failed

Wouldn't it be nice to make this a feature that allows
stored procedures (void update_pg_pwd ()) ? Correctly register
this function to not return anything ? This is what the 0 is actually
supposed to mean here, no ? Such a proc would need a fmgr, that generates 
an empty resultset.

Andreas

Thu, 21 Mar 2002 14:34:41 +0100
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
Re: Function call crashes server 
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
>> regression=# SELECT update_pg_pwd();
>> ERROR:  getTypeOutputInfo: Cache lookup of type 0 failed

> Wouldn't it be nice to make this a feature that allows
> stored procedures (void update_pg_pwd ()) ? Correctly register
> this function to not return anything ? This is what the 0 is actually
> supposed to mean here, no ?

No, in this case the procedure is a trigger procedure and is not
supposed to be called directly at all.  But we don't have a
distinguishable signature for triggers as yet.  One of the changes
I'd like to make eventually is that trigger procs take and return
some special pseudo-type, so that the type system can catch this
sort of mistake explicitly.

			regards, tom lane

Thu, 21 Mar 2002 11:19:14 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Function call crashes server 