[MacPorts] #33145: postgresql90, postgresql91 improvement to Unicode support
#33145: postgresql90,postgresql91 improvement to Unicode support -------------------------------------------+-------------------------------- Reporter: mail_ben_schmidt@… | Owner: macports-tickets@… Type: enhancement | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.0.3 Keywords: | Port: postgresql90,postgresql91 -------------------------------------------+-------------------------------- Because Mac OS X's POSIX locale support is flakey, PostgreSQL does not sort UTF-8 text properly (or do other character and collation-related operations properly). FreeBSD suffers from the same problem. A workaround is to patch PostgreSQL to use the ICU library (http://site .icu-project.org/) instead of the system's locale-related functions. FreeBSD have done this (http://people.freebsd.org/~girgen/postgresql- icu/README.html). PostgreSQL then works properly. I have updated the Portfiles for the postgresql90 and postgresql91 ports, and updated and added the patches to do this. There are a few deficiencies: - Autoconf now needs to be run, but the version has been changed (which isn't recommended by PostgreSQL) and is hardcoded to the version currently in MacPorts (so will break once the autoconf port moves to a new version). It would be better to make MacPorts use autoconf 2.63 (which, after all, is available as a port), and we won't have this problem. (We also won't need the uuid-related update.) - It would be good to have a better way of testing for the ICU library in ./configure rather than hardcoding in library symbols to search for that are specific to the library version (and thus will break as soon as the ICU port is updated). - ICU should perhaps be a variant (quite possibly it should be the default variant, but still, perhaps a variant is best rather than always using it). I am happy to help address these (or other) problems, but I wanted to raise the issue first, and find out what you maintainers think before proceeding any further. Hopefully we can get the patch applied upstream, too, and then MacPorts need only supply appropriate configure options and dependencies. But I think it's best to get it working with the patch in MacPorts first. -- Ticket URL: <https://trac.macports.org/ticket/33145> MacPorts <http://www.macports.org/> Ports system for Mac OS
#33145: postgresql90,postgresql91 improvement to Unicode support -------------------------------------------+-------------------------------- Reporter: mail_ben_schmidt@… | Owner: macports-tickets@… Type: enhancement | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.0.3 Keywords: | Port: postgresql90,postgresql91 -------------------------------------------+-------------------------------- Comment(by mail_ben_schmidt@…): I have updated the patch to address the autoconf version and variant issues. A better way of testing for the ICU library might still be nice. I found this which may help: http://ac-archive.sourceforge.net/ac- archive/ac_check_icu.html I'm also not 100% sure the patch is only effective for Unicode and doesn't mess up other multi-byte encodings. Still, now it's a variant, if it does mess something up, users can just turn it off. I did make the variant the default, though, as I expect most users will just be pleased that Unicode works as advertised. People might not even realise the issue has been addressed if the only change is a quietly added variant. Better to 'advertise' the new functionality by making it the default; if it breaks for some people, they'll soon find the problem and disable the variant. IMHO. Not sure how likely this is to get merged upstream on account of this discussion: http://archives.postgresql.org/pgsql- general/2010-01/msg00535.php but I'm still hopeful. -- Ticket URL: <https://trac.macports.org/ticket/33145#comment:1> MacPorts <http://www.macports.org/> Ports system for Mac OS
#33145: postgresql90,postgresql91 improvement to Unicode support -------------------------------------------+-------------------------------- Reporter: mail_ben_schmidt@… | Owner: macports-tickets@… Type: enhancement | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.0.3 Keywords: | Port: postgresql90,postgresql91 -------------------------------------------+-------------------------------- Comment(by dluke@…): It looks like it would probably also be useful to file a bug report with apple (with the hope that the POSIX locale support could be fixed there at some point). -- Ticket URL: <https://trac.macports.org/ticket/33145#comment:2> MacPorts <http://www.macports.org/> Ports system for Mac OS
#33145: postgresql90,postgresql91 improvement to Unicode support ----------------------------------------+-------------------------------- Reporter: mail_ben_schmidt@… | Owner: macports-tickets@… Type: enhancement | Status: new Priority: Normal | Milestone: Component: ports | Version: Resolution: | Keywords: Port: postgresql90 postgresql91 | ----------------------------------------+-------------------------------- Changes (by macsforever2000@…): * version: 2.0.3 => * port: postgresql90,postgresql91 => postgresql90 postgresql91 -- Ticket URL: <https://trac.macports.org/ticket/33145#comment:3> MacPorts <http://www.macports.org/> Ports system for Mac OS
participants (1)
-
MacPorts