Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Quoting in stored procedures

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Quoting in stored procedures
Date: 1999-08-29 00:54:23
Message-ID: 9753.935888063@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-08-29 01:00:46
Subject: Re: [HACKERS] entries in pg_shadow
Previous:From: Tom LaneDate: 1999-08-29 00:49:28
Subject: Re: [HACKERS] [Fwd: bug ? get_groname: group 0 not found]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group