Re: Lock table, Select for update and Serialization error - Mailing list pgsql-general

From sudhir
Subject Re: Lock table, Select for update and Serialization error
Date
Msg-id 4653C842.8020209@cse.iitb.ac.in
Whole thread Raw
In response to Re: Lock table, Select for update and Serialization error  ("Joris Dobbelsteen" <Joris@familiedobbelsteen.nl>)
List pgsql-general
> Summarizing:
> * Lock table - High-level: executes fast, but concurrency problems.
> Guarentees about future changes.
> Select for update - Low-level, concurrent, ensures data validity and
> indicates its modified shortly.
> Select for share - Low-level, concurrent, ensures data validity.
>
> Hopefully this clears it up a bit.
>
Yeah, it does. Thanks for your help guys.

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: Integrity on large sites
Next
From: PFC
Date:
Subject: Re: Using a trigger with an object-relational manager