| From: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Error trapping in pg/PGSQL |
| Date: | 2004-07-16 22:55:31 |
| Message-ID: | 20040716225531.GV5403@decibel.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
What plans are there for adding error trapping support to pl/PGSQL? In
my case I'm trying to write code that will properly handle the race
condition in doing a SELECT/INSERT (SELECT something but if it doesn't
exist do an INSERT), and I can't see any way to make it fool-proof
without being able to trap a duplicate key error. But it seems like
error trapping is something that would be extremely useful to have aside
from what I'm doing.
--
Jim C. Nasby, Database Consultant jim(at)nasby(dot)net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clodoaldo Pinto Neto | 2004-07-17 02:05:07 | server closed the connection unexpectedly |
| Previous Message | Constantin Khatskevich | 2004-07-16 22:40:25 | unsubscribe |