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

am  10.01.2006, um 20:06:26 +0100 mailte A. Kretschmer folgendes:
> am  10.01.2006, um 10:38:59 -0700 mailte Michael Fuhr folgendes:
> > Beware that as written this doesn't handle concurrency.  For example:
>

I'm not sure, if this enough to prevent problems:

...
begin
        lock table foo in EXCLUSIVE mode ;
        select into c count(*) from foo;
...

All other lines are unchanged.


I think/hope, i can prevent all problems, but i'm not sure if there are
problems with Deadlocks.


thanks for the response, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47212,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net
eMail schreiben kann jeder -- lernen: http://webserv/email/email.html