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
