Re: possible bug in exception handling code? (postgres8.0beta)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paramveer(dot)Singh(at)trilogy(dot)com
Cc: "pgSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: possible bug in exception handling code? (postgres8.0beta)
Date: 2004-08-19 14:32:53
Message-ID: 15655.1092925973@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paramveer(dot)Singh(at)trilogy(dot)com writes:
> would compile, when in fact it should not. (or am I totally wrong here?)
> pl_exec.c has a exception label map which is used at execution, when the
> exception actually happens.
> Wouldn't it be preferable to use it at compile time?

That is on my to-do list. One question is whether we *want* unknown
condition names to be rejected. Probably the answer is yes, but you
could make an argument the other way.

> Shouldn't it be the other way around?

No. You do not have the option not to roll back, no matter what handler
is found or not found.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-19 14:35:57 Re: Stored Procedures woes
Previous Message Tom Lane 2004-08-19 14:25:03 Re: select count(*) from pg_stat_activity in V8.0.0