Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-05-26 Thread Peter Eisentraut
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:

Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-05-26 Thread Dinesh Pandey
-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

Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-05-26 Thread Pavel Stehule
> 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

Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-05-25 Thread Tom Lane
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

Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-05-25 Thread Neil Conway
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

Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-05-25 Thread Bruce Momjian
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

Re: FW: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-04-20 Thread Alvaro Herrera
On Wed, Apr 20, 2005 at 11:51:33AM +0530, Dinesh Pandey wrote: > 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/src/pl/plpgsql/src" > directory. > 2. Executing command: > patch -p4 < sqlstate.diff

FW: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-04-19 Thread Dinesh Pandey
it is giving the following error. bash-2.03# patch -p4 < sqlstate.diff Looks like a context diff to me... File to patch: gram.y Hunk #3 failed at line 244. Malformed patch at line 93: patch: Line must begin with '+ ', ' ', or '! '. bash-2.03# bash-2.03# Kindly let m

Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-04-19 Thread Dinesh Pandey
context diff to me... File to patch: gram.y Hunk #3 failed at line 244. Malformed patch at line 93: patch: Line must begin with '+ ', ' ', or '! '. bash-2.03# bash-2.03# Kindly let me know what's wrong? Please help me how to apply this patch. Thanks Dinesh Pan

[PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-04-19 Thread Pavel Stehule
Hello, I updated patch to last changes plpgsql code. Patch contains changes for gram.y, pl_exec.c, plpgsql.h, regress/sql/plpgsql.sql and regress/output/plpgsql.out. I can't to write documenation, my english is terrible. This patch is implementation of variables SQLERRM and SQLSTATE for plpgsq