[postgis-users] WKT specification ?? Lon/Lat precision ?

[Mark Cave-Ayland]

On Fri, 2007-06-22 at 15:10 +0200, Sébastien Geindre wrote:

> i found !!!
> sorry for time lost..
> 
> it was  copy/paste between specification document (open office) with
> wrong character inside the insert request !!! i am crazy !!
> 
> 
> a question, if the column is specified with srid 4326 for instance,
> when i insert data with -1, what happens ?
> 
> thanks for your time.

No problem ;)

If you create the column using the official OGC AddGeometryColumn()
function then PostgreSQL will not allow the insert as the SRID is
checked with a column constraint. Otherwise you can probably insert the
data but any SQL that works on a column of data will not return a
meaningful result (e.g. your data appears to be in more than one
coordinate system).

You may also get the error "Operation on two GEOMETRIES with different
SRIDs" if you try and perform an operation on two geometries whose SRID
does not match.


Kind regards,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk