Skip to content

Instantly share code, notes, and snippets.

@natea

natea/AddGeometryColumns() - invalid SRID

Created February 26, 2011 18:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save natea/845489 to your computer and use it in GitHub Desktop.
Save natea/845489 to your computer and use it in GitHub Desktop.
Download ZIP
Error message when trying to load fixcity dataset
Raw
AddGeometryColumns() - invalid SRID
$ psql -d bmabr -f fixcity/sql/gis_community_board.sqlBEGIN
psql:fixcity/sql/gis_community_board.sql:9: NOTICE: CREATE TABLE will create implicit sequence "gis_community_board_gid_seq" for serial column "gis_community_board.gid"
psql:fixcity/sql/gis_community_board.sql:9: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "gis_community_board_pkey" for table "gis_community_board"
CREATE TABLE
psql:fixcity/sql/gis_community_board.sql:10: ERROR: AddGeometryColumns() - invalid SRID
CONTEXT: SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "addgeometrycolumn" line 5 at SQL statement
psql:fixcity/sql/gis_community_board.sql:11: ERROR: current transaction is aborted, commands ignored until end of transaction block
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment