Re: plpgsql exception handling

stupid me.
I edited a function with the same name, but different parameter types and
tested with the other function.
so everything works fine.

thanks everybody for help.

best regards,
Uwe

On 10 March 2011 11:53, Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com> wrote:

> same same.
> all errors including syntax_error match to others, but I checked it again.
> and the exception remains.
>
> Uwe
>
>
>
>
> On 10 March 2011 10:56, Samuel Gendler <sgendler(at)ideasculptor(dot)com> wrote:
>
>>
>>
>> On Thu, Mar 10, 2011 at 12:45 AM, Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com>wrote:
>>
>>> Hi,
>>>
>>> Yes, of course is this sql producing an error.
>>> The point is, I want to trap the error and handle it. Here in this case I
>>> set the variable l_state and l_message.
>>>
>>
>>
>> Doh! Of course. Sorry about that. What happens when you explicitly
>> catch the 42601 sql state or the syntax_error condition instead of 'others?'
>>
>>
>>
>