Re: [GENERAL] exception handling support in pgSQL

2004-08-15 Thread Tom Lane
[EMAIL PROTECTED] writes: > Have I done something wrong? Yes, misspelled the condition name. > Exception codes are also absent from the 8.0 > documentation (which looks like it needs an upgrade). One wonders if you've actually read the 8.0 documentation... see http://developer.postgresql.org/do

Re: [GENERAL] exception handling support in pgSQL

2004-08-15 Thread Paramveer . Singh
thanks paraM Jeff <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 15/08/2004 07:00 PM                 To:        [EMAIL PROTECTED]         cc:        "pgSQL General" <[EMAIL PROTECTED]>         Subject:        Re: [GENERAL] exception handling support in pgSQL On Au

Re: [GENERAL] exception handling support in pgSQL

2004-08-15 Thread Jeff
On Aug 15, 2004, at 1:57 AM, [EMAIL PROTECTED] wrote: Instead of porting each of these procedures by hand, we would like to add exception handling support to pgSQL if possible. Today is your lucky day! 8.0 adds exceptions to plpgsql! 8.0 however is in beta. But testers are greatly wanted! I looked

[GENERAL] exception handling support in pgSQL

2004-08-14 Thread Paramveer . Singh
Hi! I am a developer working for a company which typically deploys apps on Oracle. We would like to move to postgres for obvious reasons. However, most of  our legacy apps use the exception handling support provided by PL/SQL. Instead of porting each of these procedures by hand, we would like to a