Error trapping in pg/PGSQL - Mailing list pgsql-general

From Jim C. Nasby
Subject Error trapping in pg/PGSQL
Date
Msg-id 20040716225531.GV5403@decibel.org
Whole thread Raw
Responses Re: Error trapping in pg/PGSQL  ("Scott Marlowe" <smarlowe@qwest.net>)
List 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@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?"

pgsql-general by date:

Previous
From: "Edwin Quijada"
Date:
Subject: Re: [pgsql-es-ayuda] Postgres & Suse
Next
From: Richard A Lough
Date:
Subject: Re: Three versions of Pg.pm on my machine