Re: SV: MySQL and PostgreSQL speed compare - Mailing list pgsql-general

From M.Feldtmann@t-online.de (Marten Feldtmann)
Subject Re: SV: MySQL and PostgreSQL speed compare
Date
Msg-id 3A4D09B4.7A3BF36A@toppoint.de
Whole thread Raw
In response to Re: SV: MySQL and PostgreSQL speed compare  ("Dominic J. Eidson" <sauron@the-infinite.org>)
List pgsql-general

"Dominic J. Eidson" schrieb:

> > ...
> > What if I do a SELECT to check for a row. Then I do a INSERT. But between
> > SELECT and INSERT someone else inserted a row. NO I do not think that "good
> > programming" will solve this.
>
> Good design, together with good implementation, gets you a long way.
>

 Ok, now the question may be asked: How can this pattern be solved
(to use a very modern word ..).

 a) Prevent such a situation :-)

 b) Try to insert a "lock"-mechanism in your code


 Marten

pgsql-general by date:

Previous
From: Marian Simpetru
Date:
Subject: PowerDesigner support?
Next
From: Marc Rassbach
Date:
Subject: MD5 use in PL/Perl