Re: [SQL] Error handling in pltcl

2005-04-17 Thread Dinesh Pandey
I have attached below an e-mail program. I want to log messages into a table from a function written in 'plpgsql' whenever any exception occurs (like unable to connect/invalid email etc..) Pls update the code attached below Thanks Dinesh Pandey CREATE OR REPLACE FUNCTIO

Re: [SQL] Error handling in pltcl

2005-04-17 Thread Michael Fuhr
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_exe

[SQL] Error handling in pltcl

2005-04-17 Thread Dinesh Pandey
Hi,   Can any one tell me how to handle error in PL/TCL language.   On Error/Exception, In the exception block I want to call a FUNCTION (written in PL/pgSQL).   ThanksDinesh Pandey