Re: Locking entire database

Поиск
Список
Период
Сортировка
От Panagiotis Pediaditis
Тема Re: Locking entire database
Дата
Msg-id 46EA9E73.2030507@ics.forth.gr
обсуждение исходный текст
Ответ на Re: Locking entire database  ("Rodrigo De León" <rdeleonp@gmail.com>)
Ответы Re: Locking entire database  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Locking entire database  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
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?

Rodrigo De León wrote:
> On 9/14/07, Panagiotis Pediaditis <pped@ics.forth.gr> wrote:
>
>> ... there is a specific case where i need it.
>>
>
> Don't really know, but, explain what the case is, and maybe someone
> could help you.
>


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

Предыдущее
От: "Rodrigo De León"
Дата:
Сообщение: Re: How to recover database instance from a disaster
Следующее
От: "Sibte Abbas"
Дата:
Сообщение: Re: Locking entire database