Re: PSPP 0.10.2 can not retrieve data from hot-standby PostgreSQL 9.5 database.

[John Darrington]

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
     address@hidden
     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