Re: proposal: plpgsql - Assert statement - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: proposal: plpgsql - Assert statement
Date
Msg-id 5475C829.2050807@joh.to
Whole thread Raw
In response to Re: proposal: plpgsql - Assert statement  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: plpgsql - Assert statement  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On 11/26/14 8:55 AM, Pavel Stehule wrote:
> * should be assertions globally enabled/disabled? - I have no personal
> preference in this question.

I think so.  The way I would use this function is to put expensive 
checks into strategic locations which would only run when developing 
locally (and additionally perhaps in one of the test environments.)  And 
in that case I'd like to globally disable them for the live environment.

> * can be ASSERT exception handled ? - I prefer this be unhandled exception
> - like query_canceled because It should not be masked by plpgsql EXCEPTION
> WHEN OTHERS ...

I don't care much either way, as long as we get good information about 
what went wrong.  A stack trace and hopefully something like 
print_strict_params for parameters to the "expr".


.marko



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [pgsql-packagers] Palle Girgensohn's ICU patch
Next
From: Albe Laurenz
Date:
Subject: Re: Using RTLD_DEEPBIND to handle symbol conflicts in loaded libraries