[postgis-users] RE: UDig and PostGIS

[Carl Anderson]

Johan,

All geotools based software have the limitation you describe, and a few 
more.  The "fix" will require some changes to Geotools as as a couple to 
UDIG.

In the interim make sure that
   you login to the database with the same name as the schema containing 
the geometry table
   you have not changed postgresql.conf's parameter
               search_path = '$user,public'  
   there is a geometry_columns table in the schema
   there are no other tables in any other schema (database wide) that 
match your geometry table's names.

C.

Johan Wehtje wrote:

> Paul,
>  I followed your suggestions - and my pg logs show that what is 
> happening is that the client is querying for relations that are not 
> schema qualified therefore there are a whole lot of errors saying that
> "relation <geom table name> does not exist". I have tried to create 
> Postgis Tables in the public schema but for wahtever reason Udig is 
> not seeing them.
>
> I do think that the problem lies with the older Postgis driver not 
> understanding schema's as the logged client requests that generate 
> errors are not schema qualified.
>
> I tried a trivial JDBC connection using Coldfusion connected to a JDBC 
> data source. Queries like this:
>
> <cfquery name="geomtest"     datasource="jdbc.env_db">
> SELECT gid, tag, AsText(the_geom) as geostring from shapes.bompah3
> </cfquery>
>
> Generate the expected output.
>
> I also tried area, centroid, intersection and a number of other 
> queries and all returned the expected results, all issued over a JDBC 
> connection between Postgres and Cold Fsuion.
>
> I tried the same thing setting up a data source in OpenOffice 2.0 and 
> running Postgis Functions like area as queries against Postgis Tables 
> over a JDBC connection, and all queries returned the expected results.
>
> In addition QGis on both windows and Linux (which uses an embedded 
> Posgresql C library) has no problems with any of the 
> Postgresql/Postgis servers.
>
> Could you give me the connection parameters to test instance and I 
> will give that a try, though being on a satellite connection I 
> sometimes have trouble with applications that have timeouts set below 
> the latency to be expected on such a connection.
>
> Cheers
> Johan Wehtje
>
>
>
> On 12/3/05, *Paul Ramsey* <pramsey at refractions.net 
> <mailto:pramsey at refractions.net>> wrote:
>
>     Johan,
>        I have been following your emails on the udig list as well, and
>     the fact that other users can connect to postgis fine indicates to me
>     that the problem is likely not something as broad as a jdbc driver
>     problem, or else everyone would be having troubles.
>        There is something particular about your setup which is the key,
>     but it's hard to know what.  One thing you could do is turn on
>     statement logging in postgresql.conf and watch the log while udig
>     connects, see how far it gets, so you can see what return value it is
>     choking on.  You could also try to write some trivial JDBC
>     applications that connect and pull back geometries and see if things
>     die there.  It is too bad you cannot connect to our test instance,
>     since that takes your particular server configuration right out of
>     the testing equation.
>     Paul
>
>     On 2-Dec-05, at 8:44 PM, Johan Wehtje wrote:
>
>     > I have for some weeks now been trying to track down why i have not
>     > been able to get Postgis working with Udig and have managed to
>     > determine that the problem appears to lie with the Postgis JDBC
>     > driver which I think is the same as the Jump Plugin.
>     >
>     > I have not yet built the Latest version from CVS as as I have to
>     > first install a JDK. I don't know how much work has been done since
>     > the release of the Postgresql 7.4 compatible release, but with both
>     > Udig and Jump dpending on this driver to use Postgis it would be
>     > nice to see it updated to support 8.x Postgresql and 1.0.x Postgis
>     > and a ready built Jar made available.
>     >
>     > Cheers
>     > Johan Wehtje
>     > _______________________________________________
>     > postgis-users mailing list
>     > postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>     <http://postgis.refractions.net/mailman/listinfo/postgis-users>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>  
>