[postgis-users] what is maximum limit(max number of coordinates) for a LineString

[Sandro Santilli]

On Tue, Feb 21, 2012 at 05:15:25PM +0530, ram prasad wrote:
> Hi,
> 
>      I have a column called Route(with Geography datatype). A
> Linestring(with lot of lat,lon points) is inserted into this column. I
> updates this LineString with the new lat,lon coordinates. When i cross more
> than 200 lat,lon coordinates, values to updated in the Route column. So
> what is maximum limit(max number of coordinates) for a LineString?

It's a 32bit integer, so theoretically you should be able to have
up to 4,294,967,295 vertices per line. 

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net
  `-o------'