[postgis-devel] [PostGIS] #1465: loader/Latin1 regression failure with database SQL_ASCII encoding

[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):

 Yes, forcing to UTF-8 works too (with the set client encoding in the
 select).
 Clean patch:

 {{{
 Index: regress/run_test
 ===================================================================
 --- regress/run_test    (revision 9084)
 +++ regress/run_test    (working copy)
 @@ -559,7 +559,7 @@
                 # 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
 +               createdb --encoding=UTF-8 --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 9084)
 +++ 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:11>
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.