Re: Locking entire database

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Locking entire database
Дата
Msg-id 20070914145052.GC12432@svana.org
обсуждение исходный текст
Ответ на Re: Locking entire database  (Panagiotis Pediaditis <pped@ics.forth.gr>)
Список pgsql-general
On Fri, Sep 14, 2007 at 05:45:07PM +0300, Panagiotis Pediaditis wrote:
> 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.

Sounds like what you need is serializable transactions. Then the server
will tell you if something conflicts.

Have a ncie day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

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

Предыдущее
От: "Sibte Abbas"
Дата:
Сообщение: Re: Locking entire database
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Locking entire database