Syntax of stored procedures is not checked - Mailing list pgsql-bugs

From Victor Wagner
Subject Syntax of stored procedures is not checked
Date
Msg-id Pine.LNX.4.30.0106071631490.15432-100000@party.ice.ru
Whole thread Raw
List 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@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

pgsql-bugs by date:

Previous
From: Arcady Genkin
Date:
Subject: REPOST: redefining location of the socket file /tmp/.s.PGSQL.5432
Next
From: Michael Nguyen
Date:
Subject: column check constraint