Dinesh Pandey wrote:
> Is this implementation is available in postgres 8.0.2 ? Or which
> version of Postgres?
At this time, it's not available anywhere.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1:
-patches@postgresql.org; 'Tom Lane'
Subject: Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables
> I think the docs need more than just "these variables are set when an
> exception is raised".
>
> The patch current resets SQLSTATE and SQLERRM whenev
> I think the docs need more than just "these variables are set when an
> exception is raised".
>
> The patch current resets SQLSTATE and SQLERRM whenever a new block is
> entered. So:
>
> create function trap_exceptions() returns void as $_$
> begin
> begin
> raise exception 'first e
Neil Conway <[EMAIL PROTECTED]> writes:
> The second RAISE will report "successful completion". Is this the
> behavior we want?
No, certainly not --- I was just griping about the same thing.
> Is SQLERRM the best name for that variable? It seems a little obscure to me.
Oracle uses that name. W
Bruce Momjian wrote:
Patch applied.
This patch still needs work.
I added a documentation mention too.
I think the docs need more than just "these variables are set when an
exception is raised".
The patch current resets SQLSTATE and SQLERRM whenever a new block is
entered. So:
create f
Patch applied. I added a documentation mention too.
---
Pavel Stehule wrote:
> Hello,
>
> I updated patch to last changes plpgsql code. Patch contains changes for
> gram.y, pl_exec.c, plpgsql.h, regress/sql/plpgsql.sql an
Hi,
I have Postgres 8.0.1 on Solaris 9 Sparc machine running in
"usr/local/pgsql" directory.
I am trying to apply "sqlstate.diff" patch for SQLERRM and SQLSTATE for
plpgsql.
1. I have copied "sqlstate.diff" in
"postgresql-8.0.1.old/src/pl/plpgsql/src" directory.
2. Executing command:
pa
