[postgis-devel] [PostGIS] #1465: loader/Latin1 regression failure with database SQL_ASCII encoding (was: loader/Latin1 regression failure (NetBSD, postgresql 8.4.10))

[PostGIS]

#1465: loader/Latin1 regression failure with database SQL_ASCII encoding
---------------------------+------------------------------------------------
 Reporter:  gdt            |       Owner:  mcayland     
     Type:  defect         |      Status:  new          
 Priority:  medium         |   Milestone:  PostGIS 2.0.0
Component:  loader/dumper  |     Version:  trunk        
 Keywords:                 |  
---------------------------+------------------------------------------------

Comment(by gdt):

 With the following, the loader/Latin1 test passes even when pgsql was
 initialized with no locale and hence is SQL_ASCII.  Note that I've
 chosen to set the encoding to ISO8859-1 instead of UTF-8, to force
 showing the translation on load and query works too.

 (Of course, the commented-out --locale line is not needed; that fails
 on my system and I'm not sure why -- it's left as something to try.)

 {{{
 Index: regress/run_test
 ===================================================================
 --- regress/run_test    (revision 8924)
 +++ regress/run_test    (working copy)
 @@ -559,7 +559,8 @@
                 # ON_ERROR_STOP is used by psql to return non-0 on an
 error
                 _psql_opts="--no-psqlrc --variable ON_ERROR_STOP=true"

 -               createdb --template=template0 --lc-collate="C" "${DB}" >
 ${TMPDIR}/regress_log
 +               # --locale en_US.UTF-8
 +               createdb --encoding=ISO8859-1 --template=template0 --lc-
 collate="C" "${DB}" > ${TMPDIR}/regress_log
                 createlang plpgsql "${DB}" >> ${TMPDIR}/regress_log

                 # Count database objects before installing anything
 Index: regress/loader/Latin1.select.sql
 ===================================================================
 --- regress/loader/Latin1.select.sql    (revision 8924)
 +++ regress/loader/Latin1.select.sql    (working copy)
 @@ -1 +1,2 @@
 +SET CLIENT_ENCODING to UTF8;
  SELECT * FROM loadedshp;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1465#comment:8>
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.