Syntax of stored procedures is not checked

From: Victor Wagner <vitus(at)ice(dot)ru>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Syntax of stored procedures is not checked
Date: 2001-06-07 13:28:09
Message-ID: Pine.LNX.4.30.0106071631490.15432-100000@party.ice.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


In some languages used for stored procedures in PostgreSQL it is possible
to catch some programming errors statically.
At least Perl has this property (see -c in perldoc perlrun ) and it
seems that PL/PGsql and SQL too allows to parse a function definition
and catch errors in it without actual execution

It would be be very nice feature if upon CREATE FUNCTION statement
these checks would be performed.

--
Victor Wagner vitus(at)ice(dot)ru
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46-61
http://www.communiware.net http://www.ice.ru/~vitus

Browse pgsql-bugs by date

  From Date Subject
Next Message Victor Wagner 2001-06-07 13:54:12 Problem with locale on Solaris 8.0 intel
Previous Message Ilan Fait 2001-06-07 13:01:57 help - Installing