[HACKERS] table lock and record lock

2002-10-01 Thread John Liu
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? thanks. johnl ---(end of broadcast)--- TIP 3: if

Re: [HACKERS] table lock and record lock

2002-10-01 Thread Andrew Sullivan
On Tue, Oct 01, 2002 at 03:30:38PM -0500, 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? You might want to check out the docs at

Re: [HACKERS] table lock and record lock

2002-10-01 Thread scott.marlowe
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