Locking

From: M Simms <grim(at)argh(dot)demon(dot)co(dot)uk>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Locking
Date: 1999-05-02 23:27:18
Message-ID: 199905022327.AAA15732@argh.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is the situation with locking in pustgresql

I am aware that 6.5 has row level locking, and read-always, and that
6.4 doesnt (it just has complete table-level, if I am right).

However that is moderately beside the point.

What actually happens when I try and write to a table or row that is
locked by another instance of the backend? Does it simply wait and try
again, transparently, or do I have to handle this myself by checking on
return statuses and retrying when I get a particular status? And is this
also the case for reading a locked table in 6.4

Anyone have information on this?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-05-03 01:59:30 Re: [GENERAL] Locking
Previous Message K.T. 1999-05-02 16:49:54 Re: [GENERAL] Query I cannot work out