blocks|key|3313023|text|谷歌表示，有问题的补丁来自2005年。它完全应用于PostgreSQL+9.2的可能性几乎为零。更新它可能需要做很多工作，除非有人一直在将工作向前移植到新版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3313024|您还没有定义当前排序行为的不满意之处-尽管坦率地说，考虑到Mac的libc，我想答案是“很多”。我不认为你在这一点上有太多的选择，除非你愿意承担努力转发ICU补丁。|3313025|我真的很希望看到PostgreSQL能够支持重症监护室整理，如果我有时间做这种没有人会资助的工作，它就在我的工作清单上。然而，实现它并不是一个挑战，而是说服团队接受更改，并缓解或解决任何性能问题。|3313026|就我个人而言，我只是在Linux上运行它，那里更健全的排序和编码支持将会有很大帮助。|3313027|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Google suggests that the patch in question is from 2005. There's about zero chance of it applying cleanly to PostgreSQL 9.2. A lot of work is likely to be necessary to update it unless someone's been forward-porting the work to new releases. 

You haven't defined what's unsatisfactory to you about the current collation behaviour - though frankly, given Mac OS X's libc I imagine the answer is "a lot". I don't think you have a great many options at this point unless you're willing to undertake the effort to forward-port the ICU patch.

I'd really love to see PostgreSQL able to support ICU collation, and it's on my list of things to work on if I can ever find the time to do that kind of nobody-will-fund-this work. Implementing it isn't so much the challenge as convincing the team to accept the change, though, and assuaging or working around any performance concerns.

Personally I'd just run it on Linux, where the saner collation and encoding support would help a great deal.

blocks|key|3313052|text|目前，PostgreSQL+9.1版之前的版本都可以使用patch。我还没有测试过它，但我认为补丁本身工作得很好，因为它非常小，而且，AFAIK，它默认是在FreeBSD下使用的。由于Mac与GNU+autoconf兼容，补丁应该是开箱即用的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3313053|如果精通C语言，您可以尝试自己将其升级到PostgreSQL+9.2或9.3。此外，1C还提供patches+for+using+PostgreSQL+with+their+1C:Enterprise+platform。这些补丁还提供了ICU库，并且有针对PostgreSQL+9.1和9.2的版本。你可以看一看，得到一些关于升级的想法。|3313054|entityMap|0|LINK|mutability|MUTABLE|url|http://people.freebsd.org/~girgen/postgresql-icu/README.html|1|http://v8.1c.ru/overview/postgres_patches_notes.htm^0|S|5|0|0|1B|1Q|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

At the moment, <a href="http://people.freebsd.org/~girgen/postgresql-icu/README.html" rel="nofollow">patch</a> is available for PostgreSQL up to version 9.1. I haven't tested it yet, but I think patch itself works fine since it is quite small and, AFAIK, it is used under FreeBSD by default. Since Mac OS X is compatible with GNU autoconf, patch should work from the box.

Having some proficiency in C, you can try to upgrade it to PostgreSQL 9.2 or 9.3 by yourself.
Also, 1C provides <a href="http://v8.1c.ru/overview/postgres_patches_notes.htm" rel="nofollow">patches for using PostgreSQL with their 1C:Enterprise platform</a>. These patches also provide ICU library, and there are versions for PostgreSQL both 9.1 and 9.2. You can take a look and get some ideas about upgrading.

blocks|key|88463|text|是的，这是可能的--我刚刚完成了基于MacPorts安装(目前是PostgreSQL+9.3.5版本)的过程。我使用了来自Palle's+patch+page的9.2.8补丁文件，稍微修改了一下参考9.3.5源代码库，使用2.63版本的autoconf而不是2.69，然后使用来自this+MacPorts+ticket的Portfile修改告诉MacPorts如何应用补丁文件。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|88464|我的初步测试结果大多是好的，例如：|88465|postgres=#+show+server_encoding;
+client_encoding+
-----------------
+UTF8
(1+row)

postgres=#+select+*+from+comments+order+by+comment;
+comment+
---------
+gros
+gross
+groß
+grot
(4+rows)

postgres=#+select+*+from+comments+order+by+comment+collate+"C";
+comment+
---------
+gros
+gross
+grot
+groß
(4+rows)

postgres=#+select+upper('ß');
+upper+
-------
+SS
(1+row)|code-block|syntax|javascript|88466|但请注意..。|88467|postgres=#+select+upper('ß')+collate+"C";
+upper+
-------
+SS
(1+row)|88468|(我应该只期望‘«’。)|88469|entityMap|0|LINK|mutability|MUTABLE|url|http://people.freebsd.org/~girgen/postgresql-icu/|1|https://trac.macports.org/ticket/33145^0|4H|8|1P|I|0|3W|K|1|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@$9|15|A|16|1|17]|$9|18|A|19|1|1A]]|E|$]]|$1|F|3|G|5|6|7|1B|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1C|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1D|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|1E|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1F|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z]]|10|$5|V|W|X|E|$Y|11]]]]

Yes it is possible - I have just finished the process based off a MacPorts installation (currently version 9.3.5 of PostgreSQL). I used the 9.2.8 patchfile from <a href="http://people.freebsd.org/~girgen/postgresql-icu/" rel="nofollow">Palle's patch page</a>, modified slightly refer to the 9.3.5 soruce base and use version 2.63 of autoconf instead of 2.69, then used the <code>Portfile</code> modifications from <a href="https://trac.macports.org/ticket/33145" rel="nofollow">this MacPorts ticket</a> to tell MacPorts how to apply the patch file.

Results from my preliminary testing are mostly fine, e.g.

<pre><code>postgres=# show server_encoding;
 client_encoding 
-----------------
 UTF8
(1 row)

postgres=# select * from comments order by comment;
 comment 
---------
 gros
 gross
 groß
 grot
(4 rows)

postgres=# select * from comments order by comment collate "C";
 comment 
---------
 gros
 gross
 grot
 groß
(4 rows)

postgres=# select upper('ß');
 upper 
-------
 SS
(1 row)
</code></pre>

But note ...

<pre><code>postgres=# select upper('ß') collate "C";
 upper 
-------
 SS
(1 row)
</code></pre>

(I would have expected just 'ß'.)

Has anyone built Postgresql on Mac OS X with Palle Girgensohn's ICU patch? If so, what problems did you encounter, and did was the change in collation behavior satisfactory? 

I am working with Postgresql 9.2 and Mac OS 10.7 and 10.8.

Postgresql on Mac OS X with ICU patch

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

有人在Mac上用Palle Girgensohn的ICU补丁构建过Postgresql吗？如果是这样，您遇到了什么问题，整理行为的变化是否令人满意？我正在使用PostgreSQL9.2和MacOS10.7和10.8。

问带有ICU修补程序的Mac OS X上的Postgresql
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问带有ICU修补程序的Mac OS X上的PostgresqlEN