Paul Huff
Paul Huff

Reputation: 173

Postgres serialization error without serializable transactions

I got this error: ERROR: could not serialize access due to concurrent update

But I'm not using serializable transaction isolation. Is that possible without setting the default isolation level to serializable? The postgres docs only mention it for serializable transactions.

Upvotes: 0

Views: 668

Answers (1)

Paul Huff
Paul Huff

Reputation: 173

Turns out I was using psycopg v1 which sets all transactions to serializable by default. Thanks, RhodiumToad@#postgresql for the hint.

Upvotes: 1

Related Questions