Re: Locking entire database

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Locking entire database
Дата
Msg-id fce8kt$4sn$1@sea.gmane.org
обсуждение исходный текст
Ответ на Re: Locking entire database  (Panagiotis Pediaditis <pped@ics.forth.gr>)
Ответы Re: Locking entire database  (Panagiotis Pediaditis <pped@ics.forth.gr>)
Список pgsql-general
Panagiotis Pediaditis, 14.09.2007 16:45:
> Well the problem is I am working on rdf query engine for persistent RDF
> data. The data is stored/structured in a specific way in the database.
> When i perform updates in parallel, because there are cross table
> dependencies, I end up with inconsistencies, For example One transaction
> reads to see if there is a resource so as to add a property where it is
> a subject. Then an other transaction deletes the resource after the
> first has decided that the resource is there but before it added the
> property.
> Thus it would be helpful for me to avoid the difficult task of
> dependency based locking and just lock the whole database.
> any ideas?

Hmm. To me this sounds like all those steps should in fact be _one_
transaction and not several transactions.

Thomas

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Locking entire database
Следующее
От: Mike Charnoky
Дата:
Сообщение: Re: problems with large table