Thread

Syntax of stored procedures is not checked

Victor Wagner <vitus@ice.ru> — 2001-06-07T13:28:09Z

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@ice.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