Re: [udig-devel] Error with Postgis layer UDig 1.0.5 Postgis 1.0.4

[Johan Wehtje <genwolf@xxxxxxxxx>]

Jody,
Well I have tried three so far:
A Postgresql 8.0.3 Installation on Windows 2000 pro with Postgis 1.0.
All installed using Magnus Hagander pg installer. Postgis installed to Template 1.

spatial_ref_sys and geometry colunms tables exist, geomtry Colunms matches the colunms I know to have Geometry.
Functions like area and distance return the correct values.

Second setup is Postgresql 8.1 with Postgis 1.0.4, otherwise same as installtion 1.

Second Setup is Postgresql 8.0.4 and postgis 1.0 installed from source on Linux (FC3), otherwise same as others.

All the Geometry from all three systems seems to render ok in QGIs 0.7.3.

Cheers
Johan

On 11/24/05, Jody Garnett <jgarnett@xxxxxxxxxxxxxxx> wrote:

Hi Johan & Chris:

Chris Johan has been stuck trying to get uDig and Postgis to work for
some weeks now (!).  We are not quite sure of much yet, but may ask for
your help as the situation becomes clearer.
> Jody,
>
> Yes , I am not prepared to give up on U-Dig quite yet :).
> I have not tried to connect to your public databases , I will go and
> have a look at the web site as to how to go about doing that.
Oh okay - that was the first thing we/I asked you to do (so we could see
if it was a problem with the copy of uDig you have).  I am afraid I was
waiting to hear back one way or the other before trying to help.
> I am behind a firewall on a satellite connection,  so I ma not sure
> that you will be able to get through as the staellite service runs
> it's own firewall - but just in case I have set up a database that and
> port forwarding or you to try and test against - my ip is 10.16.6.222
> <http://10.16.6.222>, use norm:norm to connect to udig_test. All the
> geometry is in the shapes schema.
>
> If that fails ( which I suspect it might, as I had no luck dialling
> out to another ISP on one machine and trying to access the other, but
> then again I ma lucky if I get more than 18.6 kbps where I am) I can
> do a partial dump and post/put it somewhere.
Okay it sounds like we got options.  I am sure we can get this all to
work, and a partial dump may be of assistence. Could you answer my
question about your PostGIS setup? Do you have all the SRS information,
and I assume that you called add geometry column when setting up your
tables? (Sometimes this is missed when restoring data from an sql dump).

Jody
> Cheers
> Johan Wehtje
>
>
>
> On 11/23/05, *Jody Garnett* <jgarnett@xxxxxxxxxxxxxxx
> <mailto: jgarnett@xxxxxxxxxxxxxxx>> wrote:
>
>     Hi Johan,
>     It seems you have been trying this for a couple weeks now (!).
>
>     Just to confirm - you are able to connect to our public PostGIS
>     (and it
>     is your own PostGIS databases you are having trouble with?)
>     Is your Postgis instance visible, can we try connecting to it on
>     our end
>     (while running in a debugger?).
>
>     I need to drag a PostGIS expert into the conversation. It concerns me
>     that you are having trouble with three databases.
>     Question - do you have PostGIS installed with all the CRS information?
>     uDig will try and make use of that.
>
>     If you could get back to me with respect to testing that would be
>     good,
>     if not I will be making guesses (like the one of above) and wasting
>     both of our time.
>
>     Jody
>     _______________________________________________
>     User-friendly Desktop Internet GIS (uDig)
>     http://udig.refractions.net
>     http://lists.refractions.net/mailman/listinfo/udig-devel
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>

_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel