[SQL] plpgsql: how to get the exception's detail information?

2011-12-01 Thread Muiz
Dear all, I write a function to execute a sql string. E.g. "update tableA set field1='abc' where name='123'; deletee from tableB where id=333;" The following is my function: --

Re: [SQL] plpgsql: how to get the exception's detail information?

2011-12-01 Thread Filip Rembiałkowski
2011/11/29 Muiz : >    I write a function to execute a sql string. E.g. "update tableA set > field1='abc' where name='123'; deletee from tableB where id=333;" >    The following is my function: > ---