Locking

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

It waits. All versions work this way.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026