Re: [JPP-Devel] PSQLException trying to load empty geotables

2009-10-02 Thread Nils Kuhn
Hi Uwe, Uwe Dalluege schrieb: Hi Nils, you can save dataset as shape-file when you use my PostGISPlugIn. 1. RightMouseClick on a category then Load Dataset(s)... (green cross). Choose PostGIS Table (ComboBox behind Format:). Then you can load a PostGIS-Table. 2. RightMouseClick at the

Re: [JPP-Devel] PSQLException trying to load empty geotables

2009-10-01 Thread Uwe Dalluege
Hi Nils, you can save dataset as shape-file when you use my PostGISPlugIn. 1. RightMouseClick on a category then Load Dataset(s)... (green cross). Choose PostGIS Table (ComboBox behind Format:). Then you can load a PostGIS-Table. 2. RightMouseClick at the PostGIS-Layer then Save Dataset As

Re: [JPP-Devel] PSQLException trying to load empty geotables

2009-10-01 Thread Stefan Steiniger
Hei Nils, I don't have really an idea since I have never worked with PostGIS, but what if you test first in pgAdmin and look for errors (see the OGRS tutorial[1], and Ravi Kumars tutorial on mineral prog[2] for using pgadmin). Not sure but maybe the new book on PostGIS (PostGIS in Action)

[JPP-Devel] PSQLException trying to load empty geotables

2009-09-30 Thread Nils Kuhn
Hi, I get an org.postgresql.util.PSQLException (syntax error at or near )) if I try to load empty postgis-tables or -views. I am using the function FileOpenDataStoreLayer in oj 1.3. I am changing the data source of some layers programmatically and can't prevent that the view I link to the