Hi everyone,
I'm still working on this and am not actually sure the character encoding is
causing the problem. According to
http://tlt.psu.edu/suggestions/international/web/encoding/05nonroman.html,
the coding for hebrew windows should be similar to ISO-8859-8. But, I'm
getting a permission denied error in the geometry column even though I am
the owner of the database... I've pasted text from the terminal when I run
shp2pgsql and also from the postgresql log file. Any help would be
appreciated!
-david
-->sudo shp2pgsql -s 2039 -W ISO-8859-8 URBANI.shp urban_areas | psql
spatialtest
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
SET
BEGIN
NOTICE: CREATE TABLE will create implicit sequence "urban_areas_gid_seq"
for serial column "urban_areas.gid"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"urban_areas_pkey" for table "urban_areas"
CREATE TABLE
ERROR: permission denied for relation geometry_columns
CONTEXT: SQL statement "DELETE FROM geometry_columns WHERE
f_table_catalog = '' AND f_table_schema = 'public' AND
f_table_name = 'urban_areas' AND f_geometry_column = 'the_geom'"
PL/pgSQL function "addgeometrycolumn" line 94 at execute statement
SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
WARNING: nonstandard use of \' in a string literal
LINE 1: ...VALUES ('8.88287388491e+003','1.23130983450e+006','בוענה נז\...
^
HINT: Use '' to write quotes in strings, or use the escape string syntax
(E'...').
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
-->sudo tail -n 50 /var/log/postgresql/postgresql-8.2-main.log
2008-01-09 10:35:25 IST HINT: Use the escape string syntax for escapes,
e.g., E'\r\n'.
2008-01-09 10:35:25 IST WARNING: nonstandard use of escape in a string
literal at character 84
2008-01-09 10:35:25 IST HINT: Use the escape string syntax for escapes,
e.g., E'\r\n'.
2008-01-09 10:49:05 IST NOTICE: CREATE TABLE will create implicit sequence
"urban_areas_gid_seq" for serial column "urban_areas.gid"
2008-01-09 10:49:05 IST NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit index "urban_areas_pkey" for table "urban_areas"
2008-01-09 10:49:05 IST ERROR: permission denied for relation
geometry_columns
2008-01-09 10:49:05 IST CONTEXT: SQL statement "DELETE FROM
geometry_columns WHERE
f_table_catalog = '' AND f_table_schema = 'public'
AND f_table_name = 'urban_areas' AND f_geometry_column = 'the_geom'"
PL/pgSQL function "addgeometrycolumn" line 94 at execute statement
SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 ,
$6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
2008-01-09 10:49:05 IST STATEMENT: SELECT
AddGeometryColumn('','urban_areas','the_geom','2039','MULTIPOLYGON',2);
2008-01-09 10:49:05 IST ERROR: current transaction is aborted, commands
ignored until end of transaction block
2008-01-09 10:49:05 IST STATEMENT: INSERT INTO "urban_areas"
("shape_leng","shape_area","שם_הישוב","הערות","הסבר",the_geom) VALUES
('9.06802995385e+003','1.01826276165e+006','עילבון','ישוב',NULL,'SRID=2039;010600000001
[I deleted several lines of this] 00000001030000001C8CE22641');
2008-01-09 10:49:05 IST ERROR: current transaction is aborted, commands
ignored until end of transaction block
--
View this message in context:
http://www.nabble.com/SPLIT---character-encoding-problem--tp14698706p14707592.html
Sent from the qgis-user mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.qgis.org
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user
