Postgres Pro
Downloads
Home   >   mailing lists

Re: translating this SQL query from a different dialect - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: translating this SQL query from a different dialect
Date
Msg-id 20060110182836.GA7485@webserv.wug-glas.de
Whole thread Raw
In response to Re: translating this SQL query from a different dialect  (Michael Fuhr <mike@fuhr.org>)
Responses Re: translating this SQL query from a different dialect  (Vanja <milosevski@gmail.com>)
List pgsql-novice
Tree view 
am  10.01.2006, um 10:38:59 -0700 mailte Michael Fuhr folgendes:
> > create trigger max8 before insert on foo for each row execute procedure max8();
>
> Beware that as written this doesn't handle concurrency.  For example:
>
> The table now has 14 records.  You'll need to add some extra locking
> for it to work in a concurrent environment.

Oh, thanks very much for this hint.


Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: translating this SQL query from a different dialect
Next
From: "A. Kretschmer"
Date:
Subject: Re: translating this SQL query from a different dialect