On 2013-09-23 11:00:50 +0200, Marko Tiikkaja wrote: > On 9/23/13 10:50 AM, I wrote: > >On 9/23/13 6:40 AM, Pavel Stehule wrote: > >>After days I am thinking so it can be a good solution > >> > >>syntax - enhanced current RAISE > >> > >>RAISE ASSERT WHEN boolean expression > >> > >>RAISE ASSERT 'some message' WHEN expression > > > >It looks like I'm losing this battle, but this syntax isn't too bad. > > > >>and we can have a GUC that controls asserts per database - possibly > >>overwritten by plpgsql option - similar to current plpgsql options > >> > >>assert_level = [*ignore*, notice, warning, error] > > > >This sounds like a decent enhancement. > > Oh, it would be nice to have the option here to say "assertions can't be > caught by exception handlers", but I don't know how that mechanism works so > I'm not sure it's possible. I'll have to look into that.