Re: Per-column collation, the finale

From: Noah Misch <noah(at)leadboat(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>, Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Per-column collation, the finale
Date: 2011-01-26 03:32:24
Message-ID: 20110126033224.GA29080@tornado.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jan 26, 2011 at 12:35:07AM +0200, Peter Eisentraut wrote:
> On tis, 2011-01-25 at 10:14 +0900, Itagaki Takahiro wrote:
> > and I have an almost empty pg_collation catalog with it:
> >
> > =# SELECT * FROM pg_collation;
> > collname | collnamespace | collencoding | collcollate | collctype
> > ----------+---------------+--------------+-------------+-----------
> > default | 11 | 0 | |
> > (1 row)
>
> The initdb output should say something about how it got there.

FWIW, I tried and had the same problem. initdb gave:

creating collations ... not supported on this platform

"configure" was failing to detect locale_t for me, and this fixed it:

*** a/configure.in
--- b/configure.in
***************
*** 1116,1122 **** AC_TYPE_INTPTR_T
AC_TYPE_UINTPTR_T
AC_TYPE_LONG_LONG_INT

! AC_CHECK_TYPES([locale_t],
[#include <locale.h>])

AC_CHECK_TYPES([struct cmsgcred, struct fcred, struct sockcred], [], [],
--- 1116,1122 ----
AC_TYPE_UINTPTR_T
AC_TYPE_LONG_LONG_INT

! AC_CHECK_TYPES([locale_t], [], [],
[#include <locale.h>])

AC_CHECK_TYPES([struct cmsgcred, struct fcred, struct sockcred], [], [],

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message KaiGai Kohei 2011-01-26 03:38:55 Re: sepgsql contrib module
Previous Message KaiGai Kohei 2011-01-26 03:23:45 Re: sepgsql contrib module