"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> What is problem? ANSI SQL has different model of handling exception than
> postgresql. It doesn't distinguishes between warnings and exception.
Simply
> some sqlstate clases are reservated for warnings and other's for
exception.
> But all sqlstate's
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> What is problem? ANSI SQL has different model of handling exception than
> postgresql. It doesn't distinguishes between warnings and exception. Simply
> some sqlstate clases are reservated for warnings and other's for exception.
> But all sqlstate's
What is problem? ANSI SQL has different model of handling exception than
postgresql. It doesn't distinguishes between warnings and exception. Simply
some sqlstate clases are reservated for warnings and other's for exception.
But all sqlstate's (without '0') can be handled via any CONTINUE, E
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> PostgreSQL allow only catch exception (elevel ERROR). SQL/PSM requires that
> warnings are catchable too.
What in the world does it mean to "catch" a warning? If your intention
is to process arbitrary user-defined code while inside the error
subsyste
> >
> >Does the PSM warning error handler run in the same transaction or a
> >separate subtransaction? Can transaction execution continue afterwards?
> >
>
> It's depend. Continue and exit warning handlers run in the same
transaction,
> undo handler has separate subtransaction. It works well. F
On Sun, 2007-01-07 at 11:20 +0100, Pavel Stehule wrote:
> >
> >On Sun, 2007-01-07 at 09:59 +0100, Pavel Stehule wrote:
> >
> > > PostgreSQL allow only catch exception (elevel ERROR). SQL/PSM requires
> >that
> > > warnings are catchable too. Simply solution's is adding one callback to
> > > error
On Sun, 2007-01-07 at 09:59 +0100, Pavel Stehule wrote:
> PostgreSQL allow only catch exception (elevel ERROR). SQL/PSM requires
that
> warnings are catchable too. Simply solution's is adding one callback to
> error's processing of errors on level WARNING.
Exceptions are run within their own
On Sun, 2007-01-07 at 09:59 +0100, Pavel Stehule wrote:
> PostgreSQL allow only catch exception (elevel ERROR). SQL/PSM requires that
> warnings are catchable too. Simply solution's is adding one callback to
> error's processing of errors on level WARNING.
Exceptions are run within their own s
Hello,
PostgreSQL allow only catch exception (elevel ERROR). SQL/PSM requires that
warnings are catchable too. Simply solution's is adding one callback to
error's processing of errors on level WARNING.
typedef struct WarningHandlerCallback
{
bool(*callback) (void *arg, Err
