Problems installing zigGIS demo

4 views
Skip to first unread message

uniomni

unread,
Dec 13, 2009, 8:05:28 PM12/13/09
to zigGIS
I have a PostGIS server installed and can access it using QGIS.

We are considering purchasing zigGIS to access the PostGIS database,
so I downloaded the demo to try it out.
First step is to apply the srid.sql file. I did this from the
commandline as user postgres using the command

postgres@nautilus:~$ psql -d gis_database -h localhost -U gis -f
srid.sql

I have used this command succesfully before for other sql files, but
in this case I get a bunch of error messages ending with the ROLLBACK
statement:

psql:srid.sql:4: WARNING: nonstandard use of escape in a string
literal
LINE 2: VALUES (4023, 'ESRI', 4023, 'GEOGCS
[\"GCS_International_1967...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:srid.sql:4: ERROR: duplicate key value violates unique
constraint "spatial_ref_sys_pkey"
psql:srid.sql:7: WARNING: nonstandard use of escape in a string
literal
LINE 2: VALUES (4217, 'ESRI', 4217, 'GEOGCS[\"GCS_Bern_1898\",DATUM
[...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:srid.sql:7: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:srid.sql:10: WARNING: nonstandard use of escape in a string
literal
LINE 2: VALUES (4404, 'ESRI', 4404, 'GEOGCS
[\"GCS_Montserrat_1958\",...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:srid.sql:10: ERROR: current transaction is aborted, commands
ignored until end of transaction block

and so on.

I know that the warnings can be ignored, but can anyone help me with
the error messages?

Thanks a heap
Ole Nielsen
Australia
Reply all
Reply to author
Forward
0 new messages