Hello,

It's no possible now. But I prepared small patch which implemented 
variables sqlcode and sqlerrm for plpgsql. I can send it tomorrow. 

regards
Pavel Stehule

On Sat, 5 Mar 2005, Ali Baba wrote:

> Hi ,
> 
> I am looking for the way to get the error code
> corresponding to the exception in plpgsql.
> Can any body guide me.
> 
> Thanks,
> Asif Ali
> 
> 
> 	
> 		
> __________________________________ 
> Celebrate Yahoo!'s 10th Birthday! 
> Yahoo! Netrospective: 100 Moments of the Web 
> http://birthday.yahoo.com/netrospective/
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
> 

In response to

• Exception ERROR Code at 2005-03-05 14:03:20 from Ali Baba

Responses

• Implementation of SQLCODE and SQLERRM variables for PL/pgSQL at 2005-03-06 19:24:38 from Pavel Stehule

pgsql-hackers by date

Next:	From: Greg Stark	Date: 2005-03-05 19:17:44
	Subject: Re: 8.0.X and the ARC patent
Previous:	From: Simon Riggs	Date: 2005-03-05 18:03:17
	Subject: Re: 8.0.X and the ARC patent

pgsql-patches by date

Next:	From: Heikki Linnakangas	Date: 2005-03-05 22:17:05
	Subject: Harmless space allocation typo
Previous:	From: Tom Lane	Date: 2005-03-05 16:00:02
	Subject: Re: Display Pg buffer cache (WIP)