| From: | Erik Ande <Erik(dot)Ande(at)muthpartners(dot)de> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Get the last sql error |
| Date: | 2013-06-05 15:24:23 |
| Message-ID: | 30DD52113B959D4084A5E9DDE555C93E143542@SC-W2K8-EXCH.mpsc.intern |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Dear all,
I'm trying to find a way to get the last
sql error which happened on a database.
Found that the last command could be retrieved with
"select current_query(); ". Is there a simple way to get
the last error code (something like select @@error in MS Sql Server)?
Any hint is appreciated. Thank you in advance.
Best regards
Erik Ande
G. Muth Partners GmbH
Borsigstrasse 32
D-65205 Wiesbaden
HRB 10196 Amtsgericht Wiesbaden
Geschäftsführer: Klaus Gockel
Tel +49 (0)6122 5981-64
Fax +49 (0)6122 5981-50
Mobil +49 (0)171 3818912
Mail: Erik(dot)Ande(at)MuthPartners(dot)de<mailto:Erik(dot)Ande(at)MuthPartners(dot)de>
Internet: http://www.MuthPartners.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Toni Alfirević | 2013-06-06 09:29:36 | DB design advice |
| Previous Message | Christian Lawrence | 2013-06-04 02:56:42 | Re: permissions, exclusive row locks, and delete |