Bugs item #3042565, was opened at 2010-08-10 16:41 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=512945&aid=3042565&group_id=65979
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: clint-fewbar () >Assigned to: Markus Hoenicka (mhoenicka) Summary: pgsql: tests do not pass because of create Initial Comment: When running 'make check' for pgsql on a system with a UTF8 encoding configured (most modern day Linux OS's for instance), the tests try to run CREATE DATABASE libdbitest WITH ENCODING 'LATIN1' This may have worked in the past, but it actually fails on PostgreSQL 8.4 because this is not compatible with the underlying storage method. PostgreSQL has good support for per-connection encoding, and so changing the underlying database type is actually the wrong way to test encoding functionality, instead the connection option 'pgsql_client_encoding' should be changed for the different tests, but the underlying storage type should not be. I have attached a log showing the failure when testing against postgresql 8.4.4 ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2010-09-03 20:55 Message: According to the 8.4 docs, the following command is supposed to work: CREATE DATABASE libdbitest WITH ENCODING 'LATIN1' TEMPLATE template0 As this behaviour is new in 8.4 and I run only an older version, could you patch test_dbi and see if it works? There are two occurrences of this command, around lines 2150 and 2730. If the command does work with 8.4, I'd change test_dbi.c to consult the server version to use the proper command. pgsql_client_encoding functionality is tested as well, but I'd like to confirm that the drivers can connect to databases using different encodings, as this also works with other engines. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=512945&aid=3042565&group_id=65979 ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel