[postgis] Error while joining geo-columns

[Manuel Weindorf]

> Manuel Weindorf wrote:
> > Later I recreated the database and did ithe rest without the AddGeom....
> > stuff, just used the table shp2pgsql created an it worked ...
>
> Hum, this sounds strange.  The shp2pgsql program will set all the SRID
> to -1 - its not really 0.6 compliant.
>
> Could you still send me the "polygons" table - that query shouldnt crash
> the server.  It could be a problem with enforcing SRID checks...
>
> My original thought was that you had run out of memory or something...
>
> dave

I take back all I said yesterday concerning the problem described above. 
Today I did it all again and it worked! I guess there was a problem between 
the version of the libpostgis.so.0.5 (I switched yesterday a few times 
between CVS and 0.5 and maybe I forgot to 'make install' something).
I think the same could happen if I created the DB under 0.5 and 
used it in 0.6!?

But in fact, everthing works fine even when I don't use the AddGeometryColumn 
stuff (just importing the shp2pgsql created file)

Manuel

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of VeriSign's FREE Guide: "Securing Your Web Site for Business." Get it Now!
http://us.click.yahoo.com/n7RbFC/zhwCAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/