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 databas

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

[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 posting/readin