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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster