Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ISOMetadataStore (SQL): Setup tables script fails on PostgreSQL 9.3/PostGIS 2.1 #531

Closed
MrSnyder opened this issue Apr 14, 2015 · 1 comment · Fixed by #657
Closed

ISOMetadataStore (SQL): Setup tables script fails on PostgreSQL 9.3/PostGIS 2.1 #531

MrSnyder opened this issue Apr 14, 2015 · 1 comment · Fixed by #657
Assignees
Labels
bug error issue and bug (fix)
Milestone

Comments

@MrSnyder
Copy link
Contributor

I am setting up an ISOMetadataStore (SQL) using deegree 3.4-pre17 on Ubuntu 14.04 LTS (packaged PostgreSQL/PostGIS version). I run into the following issue when creating the database tables using "Setup tables":

"Error: ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, unknown) is not unique Hint: Could not choose a best candidate function. You might need to add explicit type casts. Position: 8"

I analyzed the SQL script and found the problem in line 75:

"SELECT AddGeometryColumn('public','idxtb_main','bbox','-1','GEOMETRY','2');"

Here's what works for me:

"SELECT AddGeometryColumn('public','idxtb_main','bbox',0,'GEOMETRY',2);"

I think there are two problems:

  • SRID and dimension should be given as numbers, not strings
  • Since some time, the official "undefined" SRID is 0, not -1
@MrSnyder MrSnyder added bug error issue and bug (fix) easy labels Apr 14, 2015
@MrSnyder MrSnyder added this to the 3.4 milestone Apr 14, 2015
@ghost
Copy link

ghost commented Apr 14, 2015

Since some time, the official "undefined" SRID is 0, not -1

That's the case since PostGIS 2.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug error issue and bug (fix)
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants