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: Closed >Resolution: Fixed 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: 2011-02-19 22:42 Message: I've checked the docs again, and it seems you need to provide a matching locale and collation if you want to create a database with a different encoding than the one used in initdb. I've changed the tests accordingly. ---------------------------------------------------------------------- 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 ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
