Re: Assertions in PL/PgSQL - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Assertions in PL/PgSQL
Date
Msg-id CAFj8pRAxJHY9+5p9=YFbyAwLBK9WA4pXMBX062v-2Txj+YpOMg@mail.gmail.com
Whole thread Raw
In response to Re: Assertions in PL/PgSQL  (Marko Tiikkaja <marko@joh.to>)
List pgsql-hackers



2013/9/19 Marko Tiikkaja <marko@joh.to>
On 9/19/13 2:08 PM, Pavel Stehule wrote:
I think so similar frameworks will be exists (we have some similar
Probably You and me have a same opinion so only simple and very primitive
assert is not enough:

I see as useful feature for assertions:

a) possibility to specify a message (two parametric assert)
b) possibility to specify some threshold
c) possibility to specify some level (exception, warning, notice) ..
default should be exception
c) possibility to specify a handled/unhandled exception

I think these are all neat ideas on how to further improve this feature.  I'd like to see at least a) in 9.4, but I haven't yet looked at how it could be implemented.

Not all must be implemented in 9.4, although it is +/- only exception parametrization - not hard for implementation.

But syntax should be prepared for this functionality (or should be extensible as minimum) before. Bison parser is not friendly for additional extending :( - and we can break a future extending simply just only on syntax level with bad design now. It is reason, why I am doing noise here. I remember relatively difficult extending of RAISE statement.

Regards

Pavel

 


Regards,
Marko Tiikkaja

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: record identical operator
Next
From: Andres Freund
Date:
Subject: Re: Freezing without write I/O