I pushed a change based on what you suggested. Thanks for pointing this out.
J' On Tue, Aug 23, 2016 at 11:03:14PM +0800, C,C H wrote: Hi, I tried to access data following the PSPP documentation 9.4.2 Postgres Database Queries <https://www.gnu.org/software/pspp/manual/html_node/GET-DATA-_002fTYPE_003dPSQL.html> section but got the following error. PSPP> GET DATA /TYPE=PSQL > /CONNECT="host=127.0.0.1 port=5433 user=postgres dbname=postgres" > /SQL="SELECT * FROM tst" > /UNENCRYPTED. error: Error from psql source: ERROR: cannot use serializable mode in a hot standby HINT: You can use REPEATABLE READ instead. I pinned down to /src/data/psql-reader.c and found ds_init_cstr (&query, "BEGIN READ ONLY ISOLATION LEVEL SERIALIZABLE; " "DECLARE pspp BINARY CURSOR FOR "); 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' <https://www.postgresql.org/docs/9.5/static/sql-set-transaction.html> )? Thank you. _______________________________________________ Pspp-users mailing list Pspp-users@gnu.org https://lists.gnu.org/mailman/listinfo/pspp-users -- Avoid eavesdropping. Send strong encryted email. PGP Public key ID: 1024D/2DE827B3 fingerprint = 8797 A26D 0854 2EAB 0285 A290 8A67 719C 2DE8 27B3 See http://sks-keyservers.net or any PGP keyserver for public key.
signature.asc
Description: Digital signature
_______________________________________________ Pspp-users mailing list Pspp-users@gnu.org https://lists.gnu.org/mailman/listinfo/pspp-users