Re: [HACKERS] Quoting in stored procedures

pgsql-hackers(at)mail(dot)remote(dot)org writes:
> The syntax needed for defining functions is quite annoying because of the
> needed quoting.

Actually, considering that you probably don't want to be typing (and
retyping) procedure definitions right into psql, it seems to me that
what's really wanted is a procedure editor. Once you've got that,
it could mask annoying little details like doubling quotes.

Another thing that I'd like to see along these same lines is an "UPDATE
FUNCTION" command that allows the stored text for a PL function
definition to be replaced, without dropping/recreating the function
definition. Drop/recreate changes the function OID, thereby breaking
triggers that use it, and is generally a real pain when you're trying
to debug a bit of plpgsql...

regards, tom lane