uniomni
unread,Dec 13, 2009, 8:05:28 PM12/13/09Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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