Re: Locking entire database - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Locking entire database
Date
Msg-id fce8kt$4sn$1@sea.gmane.org
Whole thread Raw
In response to Re: Locking entire database  (Panagiotis Pediaditis <pped@ics.forth.gr>)
Responses Re: Locking entire database
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Locking entire database
Next
From: Mike Charnoky
Date:
Subject: Re: problems with large table