Re: 7.3 LOCK TABLE problem

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: 7.3 LOCK TABLE problem
Дата
Msg-id 1043694820.32114.148.camel@tokyo
обсуждение исходный текст
Ответ на 7.3 LOCK TABLE problem  (Chris Gamache <cgg007@yahoo.com>)
Ответы Re: 7.3 LOCK TABLE problem
Список pgsql-general
On Mon, 2003-01-27 at 11:20, Chris Gamache wrote:
> Tom's suggested solution worked GREAT in 7.2.x ... I tried taking the plunge
> into 7.3.1 tonight. In 7.3.1, when my FIFO queue program goes to grab a row,
> TWO processes grab the same row, almost without fail. I even changed my locking
> statement to the dreaded

Without knowing anything about "your FIFO queue program" or the queries
it is executing, it's kind of difficult to help you out. Exactly what
queries are being executed, in what order, and how does the result
differ from what you expect (and 7.2's behavior)?

AFAIK there weren't any significant changes to table-level locks in 7.3.

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC




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