On Mon, Apr 18, 2005 at 09:20:37AM +0530, Dinesh Pandey wrote: > > Can any one tell me how to handle error in PL/TCL language.
What kind of error? Have you tried using catch? > On Error/Exception, > In the exception block I want to call a FUNCTION (written in PL/pgSQL). You could use spi_exec to SELECT the function. If you still have trouble, then please post a simple example that shows what you're trying to do. BTW, pgsql-sql probably isn't the best place to ask PL/Tcl questions since its description is "Discussion for users on SQL related matters." pgsql-general or pgsql-interfaces might be more appropriate. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
