Re: [GENERAL] Fixing or diagnosing Canceled on identification as a pivot, during write

2012-09-13 Thread Kevin Grittner
"Andrus" wrote: > After switching to PostgreSql 9.1 serializable transaction level > for all transactions during posting single document errors > > 40001:ERROR: could not serialize access due to read/write > dependencies among transactions > Reason code: Canceled on identification as a pivot, dur

[GENERAL] Fixing or diagnosing Canceled on identification as a pivot, during write

2012-09-13 Thread Andrus
After switching to PostgreSql 9.1 serializable transaction level for all transactions during posting single document errors 40001:ERROR: could not serialize access due to read/write dependencies among transactions Reason code: Canceled on identification as a pivot, during write.; started to app