Re: 7.3 LOCK TABLE problem - Mailing list pgsql-general

From Neil Conway
Subject Re: 7.3 LOCK TABLE problem
Date
Msg-id 1043694820.32114.148.camel@tokyo
Whole thread Raw
In response to 7.3 LOCK TABLE problem  (Chris Gamache <cgg007@yahoo.com>)
Responses Re: 7.3 LOCK TABLE problem
List 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 by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Hit Summaries
Next
From: Bruce Momjian
Date:
Subject: Re: any caveat upgrading from 7.2.1 to 7.3.x on RH 7.3?