r19821 - gnucash/trunk/src/backend/dbi - Bug 592643: Set standard_conforming_strings on postgresql databases.

[John Ralls]

Author: jralls
Date: 2010-11-16 20:31:37 -0500 (Tue, 16 Nov 2010)
New Revision: 19821
Trac: http://svn.gnucash.org/trac/changeset/19821

Modified:
   gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c
Log:
Bug 592643: Set standard_conforming_strings on postgresql databases.

Modified: gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c
===================================================================
--- gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c	2010-11-17 00:10:16 UTC (rev 19820)
+++ gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c	2010-11-17 01:31:37 UTC (rev 19821)
@@ -978,6 +978,7 @@
                 qof_backend_set_error( qbe, ERR_BACKEND_SERVER_ERR );
                 goto exit;
             }
+	    dbi_conn_queryf( be->conn, "ALTER DATABASE %s SET standard_conforming_strings TO on", dbname );
             dbi_conn_close( be->conn );
 
             // Try again to connect to the db