On Tue, 1 Oct 2002, John Liu wrote: > what's the default lock in pgsql? > > if I issued insert(copy)/or update processed > on the same table but on different records > the same time, how those processes will > affect each other?
postgresql does not do "locking" in the sense of how most database do locking. It uses a system called multi-version concurrency control that prevents writers from blocking readers and vice versa. It has advantages and disadvantages over the row locking methodology used by most other databases, but you can read for yourself by looking in the docs at: http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/mvcc.html Good luck. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])