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

Reply via email to