How do pessimistic and optimistic locking relate to row-level and table-level locks in PostgreSQL? What is LOCK TABLE?