[postgis-users] Issue with the geometry field in postgresql tables

[Markus Schaber]

Hi, Paul,

Paul Ramsey <pramsey at refractions.net> wrote:

> Sure, just drop the constraints and go crazy.  Mixed geometry types  
> should not present any troubles at all, for either the functions or  
> the indexes.  Mixed SRIDs will break all kinds of things unless you  
> wrap everything in a transform() to force everything into a common  
> plane at operation time.  Indexing in particular will not work on  
> mixed SRIDs.

However, it's possible to create functional indices on transformed
geometries.


Regards,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org