Re: SV: MySQL and PostgreSQL speed compare

From: M(dot)Feldtmann(at)t-online(dot)de (Marten Feldtmann)
To: "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org>
Cc: Jarmo Paavilainen <netletter(at)comder(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: SV: MySQL and PostgreSQL speed compare
Date: 2000-12-29 22:01:24
Message-ID: 3A4D09B4.7A3BF36A@toppoint.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 2000-12-29 22:22:43 Re: MySQL to PostgreSQL
Previous Message John Burski 2000-12-29 21:51:41 Re: SV: MySQL and PostgreSQL speed compare