Re: [GENERAL] SELECT and RowExclusiveLock

2017-04-07 Thread Tom Lane
Tim Nelson writes: > New to Postgres and I have never seen this condition. We are getting test > applications hanging on SELECT statements with a RowExclusiveLock. How can > a SELECT cause a RowExclusiveLock? > relname | pid | mode | granted >

Re: [GENERAL] SELECT and RowExclusiveLock

2017-04-07 Thread David G. Johnston
On Fri, Apr 7, 2017 at 1:25 PM, Tim Nelson wrote: > New to Postgres and I have never seen this condition. We are getting test > applications hanging on SELECT statements with a RowExclusiveLock. How can > a SELECT cause a RowExclusiveLock? > Two common ways: SELECT ... FOR

Re: [GENERAL] SELECT and RowExclusiveLock

2017-04-07 Thread Adrian Klaver
On 04/07/2017 01:25 PM, Tim Nelson wrote: New to Postgres and I have never seen this condition. We are getting test applications hanging on SELECT statements with a RowExclusiveLock. How can a SELECT cause a RowExclusiveLock? relname | pid | mode | granted

[GENERAL] SELECT and RowExclusiveLock

2017-04-07 Thread Tim Nelson
New to Postgres and I have never seen this condition. We are getting test applications hanging on SELECT statements with a RowExclusiveLock. How can a SELECT cause a RowExclusiveLock? relname | pid | mode | granted