| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | Postgresql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Error handling in stored functions/procedures |
| Date: | 2004-06-01 05:10:45 |
| Message-ID: | 20040601071045.B610@hermes.hilbert.loc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> You mean that the default generated error messages contain some more
> information I presume, like the table name and the constraint name ?
Even better, the information is *structured* afaik.
> I think I noticed that already, and since I had time since yesterday
> evening, I thought things over and came to the conclusion that this
> mechanism at least gives an escape hatch, since it is possible to give a
> name to each constraint, and then use this name as an index to get a
> proper error message.
For check constraints you can even name them yourself during
table creation.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bret Busby | 2004-06-01 05:14:55 | Re: book for postgresql |
| Previous Message | Jason Sheets | 2004-06-01 04:20:31 | Re: FTP daemon that support Postgresql |