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

From Pavel Stehule
Subject Re: proposal: plpgsql - Assert statement
Date
Msg-id CAFj8pRDrNUXwHVe1pfzmOO1SQK0AJ_wBsGzERb9fw3JkdAfrsA@mail.gmail.com
Whole thread Raw
In response to Re: proposal: plpgsql - Assert statement  (Marko Tiikkaja <marko@joh.to>)
Responses Re: proposal: plpgsql - Assert statement  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers


2014-11-26 13:31 GMT+01:00 Marko Tiikkaja <marko@joh.to>:
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.

ok
 

* 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".

There is more ways, I can live with both

Pavel

 


.marko

pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: Follow up to irc on CREATE INDEX vs. maintenance_work_mem on 9.3
Next
From: Sawada Masahiko
Date:
Subject: Re: Proposal : REINDEX SCHEMA