Re: PostgreSQL transaction locking problem
От | Stephan Szabo |
---|---|
Тема | Re: PostgreSQL transaction locking problem |
Дата | |
Msg-id | 20020202110937.S42811-100000@megazone23.bigpanda.com обсуждение исходный текст |
Ответ на | Re: PostgreSQL transaction locking problem (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: PostgreSQL transaction locking problem
|
Список | pgsql-general |
On Sat, 2 Feb 2002, Tom Lane wrote: > "Jeff Martin" <jeff@dgjc.org> writes: > > LOCK TABLE Test IN EXCLUSIVE MODE; > > > /* This function should be able to operate concurrently BUT CANNOT */ > > How you figure that? EXCLUSIVE lock is clearly documented to be > self-conflicting; so only one process can hold it at a time. See > http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/locking-tables.html > > If concurrency is important I'd suggest generating your ID values using > a sequence generator, rather than trying to build your own > implementation. I actually thought that he's complaining about the fact that it gives him the same id twice if he runs it in two transactions rather than the delay until the first commits.
В списке pgsql-general по дате отправления: