67 reputation
18
bio website
location Norway
age 56
visits member for 1 year, 11 months
seen Apr 4 at 12:04

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
May
31
comment How to use cql_filter in OpenLayers.Control.WMSGetFeatureInfo?
Any suggestion as to how I add the CQL params to my code? I tried some stuff did not work. I tried it in the block: "info = new OpenLayers.Control.WMSGetFeatureInfo({... ,cql_filter:'navn like "%han%"..." This had no effect. Does not seem to be many examples as to how to do this or the correct syntax in my solution. Any help in right direction is appreciated!