Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: spi and error messages
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Bart Degryse <Bart(dot)Degryse(at)indicator(dot)be>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: spi and error messages
- Date: Wed, 30 May 2007 08:13:49 -0600
On Wed, May 30, 2007 at 09:33:40AM +0200, Bart Degryse wrote:
> In general how should I catch the error message generated if one
> of the spi functions (spi_exec_query, spi_query, spi_fetchrow,
> spi_prepare,...) fails?
In PL/Perl functions you can use eval to catch errors just as you
would in an ordinary Perl script:
eval { do something };
if ($@) { handle the error }
--
Michael Fuhr
- References:
- spi and error messages
- From: Bart Degryse
- spi and error messages
- Prev by Date: spi and error messages
- Next by Date: logging amount rows retrieved?
- Previous by thread: spi and error messages
- Next by thread: logging amount rows retrieved?
- Indexes: