Re: INSERT WHERE NOT EXISTS

On Wed, 25 Jun 2003, Ian Barwick wrote:

> On Wednesday 25 June 2003 21:37, Mike Mascari wrote:
> > Ian Barwick wrote:
> > > On Wednesday 25 June 2003 20:06, Reuben D. Budiardja wrote:
>
> (...)
> > > This kind of query should work; just leave out the "FROM dummy_table"
> > > bit. (in Oracle it would be "FROM dual").
> >
> > I proposed that same solution 3 years ago. Tom shoots it down:
> >
> > http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3A4D611
> >6.1A613402%40mascari.com&rnum=1&prev=/groups%3Fq%3DMike%2BMascari%2BINSERT%2
> >BNOT%2BEXISTS%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den
> >
> > Reuben must be prepared for unique key violation, I'm afraid. And,
> > despite the optimism in the link, we still don't have savepoints. :-(
>
> aha, useful to know. Thanks.

Oh yeah, in my example you need to do a select for update to be race safe.