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

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-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

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. We had

Re: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-04-20 Thread Dinesh Pandey
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