Lock table, best option?

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Lock table, best option?
Date: 2010-04-24 20:46:51
Message-ID: y2u18f98e681004241346idf8f6948yf69a7a88bee87c9d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I need to do a SELECT and an UPDATE, but I will have concurrent processes
doing the same task.

How can I prevent that the concurrent task don't have the same results in
the SELECT? Locking a table? How can I do that?

Best Regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-04-24 22:53:07 Re: Help me stop postgres from crashing.
Previous Message Oliver Kohll - Mailing Lists 2010-04-24 19:56:17 Re: Invalid objects