Doesn't the following allow a race condition?
>declare foo record;
>begin
> select into foo * from overview...
> if not found
> insert...
> else ...
> end if;
>end;
ISTM 2 or more clients could attempt to insert the same row, based on the select
failing, if all were issued at the same time. I've always assumed that, there being
no row to lock in a _failed_ search, even saying SELECT ... FOR UPDATE in this case is
no help.
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at
http://www.eudoramail.com
