RE: table level locking different in 7.0? - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: table level locking different in 7.0?
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018BE7@SECTORBASE1
Whole thread Raw
In response to table level locking different in 7.0?  (Jim Mercer <jim@reptiles.org>)
Responses Re: table level locking different in 7.0?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Hmm.  In 7.0, COPY IN acquires an exclusive lock on the target table,
> which is something I put in in a fit of paranoia.  It may not really
> be necessary --- probably a regular write lock would be good enough.
> (6.5's COPY code neglected to acquire any lock at all, which is surely
> *not* good enough, but maybe I overreacted.)

Oh, seems I forgot about COPY in 6.5... -:(
ROW EXCLUSIVE lock is required (just like for INSERT, DELETE, UPDATE)...

Vadim


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: table level locking different in 7.0?
Next
From: Tom Lane
Date:
Subject: Re: table level locking different in 7.0?