|
From: | C,C H |
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
ds_init_cstr (&query, |
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' )?
Thank you.
[Prev in Thread] | Current Thread | [Next in Thread] |