Re: User's exception plpgsql - Mailing list pgsql-patches

From Pavel Stehule
Subject Re: User's exception plpgsql
Date
Msg-id Pine.LNX.4.44.0507061937070.23774-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to Re: User's exception plpgsql  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
>
> I really don't like the idea of introducing a new concept into the
> language ("exception variables") to resolve some ambiguous syntax. It
> would be another matter if exception variables actually provided
> something that strings do not...
>

In this time e.variables does it - only holds sqlstate and name.

You see only raise stmt. But there is part of begin exception block too.
without e.v. you have to catch users exception only via OTHERS or you have
to change syntax.

EXCEPTION WHEN SQLSTATE('0000') THEN

e.v. solve this problem. And I hope so can hold others info in future

Pavel


pgsql-patches by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: User's exception plpgsql
Next
From: Mark Deric
Date:
Subject: More to Bad link Makefile patch