Does the whole table
UPDATE (without specifying
WHERE clause) lock a table in PostgreSQL? E.g. does it prevents rows from being deleted / inserted?
E.g. if I run
UPDATE t1 SET key = 'value'
Can I expect no new rows will be inserted into
t1 during the
If no, can I expect
UPDATE will update even the rows appeared after its start? (key has no
DEFAULT 'value' in its definition)