On Mon, Aug 22, 2011 at 6:22 PM, Jaime Casanova <[email protected]> wrote: > Hi, > > after some tries, i haven't managed to make this query use the GiST > index that was created on columns transmitter_mv.punto nor > rowlatlong.punto and it finishes using a seq scan on table > transmitter_mv for every row in rowfreqlevel that satisfies the join > and where conditions. > > Stephen Woodbridge, made me notice in > http://postgis.refractions.net/pipermail/postgis-users/2011-August/030575.html > that in the plan the POINT is being casted to geography so i decided > to bite the bullet and use geography columns intead but when i tried > to create the points from long/lat pairs i got this error (which i > didn't get when the column was geometry) > """ > db=# update transmitter_mv set punto = st_makepoint(tx_long, tx_lat); > ERROR: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY > type > """ >
btw, this is obviously postgis 1.5 and postgres version (less obvious) is 9.0 -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
