Thread: Error trapping in pg/PGSQL

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@nasby.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?"

On Fri, 2004-07-16 at 16:55, Jim C. Nasby wrote:
> 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.

I do believe that this would be doable with subtransactions.