-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 whenever a new block is
entered. So:
create
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:
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
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. We had
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:
patch -p4