[postgis-devel] [PostGIS] #1140: loader/PointZ test failing on my windows 9.0/9.1

[PostGIS]

#1140: loader/PointZ test failing on my windows 9.0/9.1
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  strk         
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 hmm I wonder if I can't have UTF-8 database and C-locale.  In the article
 you pointed to it says you can't do this:

 ERROR:  collation "c" for encoding "UTF8" does not exist

 Indeed 9.1 has other issues

 {{{
 SELECT * FROM (values ('01'),(' 03')) AS f(a) ORDER BY 1 collate
 somethingorother;

 gives
 ERROR:  collations are not supported by type integer
 }}}

 Is illegal and it reads 1 as if it were an integer rather than a column.

 I don't have any collations installed in my 9.1  so I created one which I
 would think would be illegal for UTF-8, but it let me do it:

 {{{
 CREATE COLLATION ucs_basic
   (LC_COLLATE='C', LC_CTYPE='C');
 SELECT * FROM (values ('01'),(' 03')) AS f(a) ORDER BY a collate
 ucs_basic;
 }}}

 still didn't change the answer

 {{{
 Output:

  a
 ---------
   03
  01

 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1140#comment:7>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.