[postgis-tickets] [PostGIS] #2369: SQL Statemant Works in Windows version 1.5x Not in Liunx version 2.0x

[PostGIS]

#2369: SQL Statemant Works in Windows version 1.5x  Not in Liunx version 2.0x
---------------------+------------------------------------------------------
 Reporter:  vbalent  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.0.4
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by vbalent):

 Hi yes.

 Thanks you for helping the last time on my previous ticket and I modified
 the changes
 to utilize the Gist Index on the Geom.

 Currently my points that I am looking to find in polygons are both in the
 Same SRID

 Ran the following
 select UpdateGeometrySRID('public', 'PatrolZones', 'the_geom', 2260) ;

 Part_1_Crimes are already in 2260


 psm_gee=# SELECT ST_SRID(the_geom) from "PatrolZones" limit 1;
  st_srid
 ---------
     2260
 (1 row)


 psm_gee=# SELECT ST_SRID(geom) from part_1_crimes limit 1;
  st_srid
 ---------
     2260
 (1 row)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2369#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.