|Subject:||PSPP 0.10.2 can not retrieve data from hot-standby PostgreSQL 9.5 database.|
|Date:||Tue, 23 Aug 2016 23:03:14 +0800|
I tried to access data following the PSPP documentation 9.4.2 Postgres Database Queries section but got the following error.
PSPP> GET DATA /TYPE=PSQL
I pinned down to
/src/data/psql-reader.c and found
It seems that PSPP can not query from a hot-standby database because the isolation level is set to
SERIALIZABLE in this line.
Is it possible to improve this?
Maybe set the isolation level to
REPEATABLE READ instead of
SERIALIZABLE ( 'PostgreSQL: Documentation: 9.5: SET TRANSACTION' )?
|[Prev in Thread]||Current Thread||[Next in Thread]|