Re: Lock Detection (was: [BUGS] pg_dump failing on LinuxPPC)

2001-02-26 Thread Stu Coates
Tom Lane wrote: > > Stu Coates <[EMAIL PROTECTED]> writes: > > I come from an Oracle background where I can lock an item of data by > > performing a "SELECT FOR UPDATE" on the row. This is also implemented > > in PostgreSQL. A quite useful feature Oracle does have is the ability > > to add a "N

Re: Lock Detection (was: [BUGS] pg_dump failing on LinuxPPC)

2001-02-24 Thread Tom Lane
Stu Coates <[EMAIL PROTECTED]> writes: > I come from an Oracle background where I can lock an item of data by > performing a "SELECT FOR UPDATE" on the row. This is also implemented > in PostgreSQL. A quite useful feature Oracle does have is the ability > to add a "NOWAIT" clause to the end of t