67 reputation
19
bio website
location Norway
age 56
visits member for 2 years, 2 months
seen May 2 at 17:20

Jul
18
awarded  Popular Question
Apr
4
comment Problems moving POSTGIS database from postgresql 8.3 to 9.3 using Navicat
I am not sure I did this correctly since I am confused with the how POSTGIS 2.1 has a view "geometry_columns" while the old POSTGIS 2.0 creates a table with the same name. I was able to drop til view and create the table. Then I imported the backup sql file. At least everything shows up now in Geoserver correctly and my maps seem to work fine.
Apr
2
comment Why am I missing the the geometry column (geometry_columns)?
I have a line in my sql that inserts a post into the table. I guess you can not import a record to a view (??) This line does not work then: INSERT INTO "geometry_columns" VALUES ('', 'public', 'darwincore2', 'punkt_geom', '2', '4326', 'MULTIPOINT'); - How do I solve this?
Apr
2
comment Why am I missing the the geometry column (geometry_columns)?
I also have this problem when I am importing an sql from a backup from postgresql 8.3 into 9.3. I had "geometry_columns" as a table in my old database and now it is a view in 9.3. I tried to import it but got an error creating the table since it already exists as a view. And I can not drop the view since it complains that POSTGIS needs it.
Apr
2
comment Problems moving POSTGIS database from postgresql 8.3 to 9.3 using Navicat
I tried to use pg_dump but I get the same problem. On my old postgres 8.3 table there is a table "geometry_columns" while postgres 9.3 and POSTGIS 2.1 creates a view with the same name "geometry_columns". I am not able to delete this and I wonder if it is safe to delete it? I tried to do it on a test database and after that the import complained about missing geom functions. This is driving me nuts :-(
Mar
25
asked Problems moving POSTGIS database from postgresql 8.3 to 9.3 using Navicat
Feb
5
awarded  Popular Question
Jul
27
awarded  Notable Question
Jan
18
awarded  Popular Question
Jan
5
awarded  Teacher
Jun
1
comment How to use cql_filter in OpenLayers.Control.WMSGetFeatureInfo?
Sorry, I was really not sure how to do that. I am learning this also.
Jun
1
accepted How to use cql_filter in OpenLayers.Control.WMSGetFeatureInfo?
Jun
1
awarded  Scholar
Jun
1
accepted How to get the layer name?
Jun
1
accepted OpenLayers popup - random losing click event, have to refresh page
Jun
1
accepted OpenLayers/Extjs/Mapfish put permaink in menubar
Jun
1
awarded  Supporter
Jun
1
comment How to use cql_filter in OpenLayers.Control.WMSGetFeatureInfo?
@iant - how do you pass the CQL filter to the WMS getFeatureInfo function? Any examples? Thanks!
Jun
1
comment How to use cql_filter in OpenLayers.Control.WMSGetFeatureInfo?
Not sure what you mean. Does this affect if people answer or not?
Jun
1
revised How to use cql_filter in OpenLayers.Control.WMSGetFeatureInfo?
Changed the question