How to make a read-write atomic?

Поиск
Список
Период
Сортировка
От Daniel Stolk
Тема How to make a read-write atomic?
Дата
Msg-id 37CDCC3E.AE36420@email.com
обсуждение исходный текст
Ответы Re: [GENERAL] How to make a read-write atomic?  (Michael Simms <grim@argh.demon.co.uk>)
Список pgsql-general
Hi,

I used to use the BEGIN-COMMIT pair in order to ensure that two
processes didn't read the same data and write at the same time, so
messing things up.  But I've recently upgraded to the latest version of
postgresql and now it doesn't work anymore.  Does anybody know what's
going on?

To explain my situation in more detail:
I want a process to read the database for the entry that has the highest
customerid number.  I then want the process to write the next entry into
the database with a customerid that is one larger.  But if two processes
read at the same time, then they will both write an entry that has the
same customerid number.  How do I keep this from occurring since the
BEGIN command doesn't seem to work for me anymore?

I am using PostgreSQL 6.5.1 on RedHat 6.0

Thanks, Daniel Stolk

В списке pgsql-general по дате отправления:

Предыдущее
От: "Phil Oelkers"
Дата:
Сообщение: newbie Connect question
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] 6.5.1 pg_dump adds "connect as" line