[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Strange Exceptions
From:       David Blasby <dblasby () refractions ! net>
Date:       2004-01-26 19:33:43
Message-ID: 40156B97.3000308 () refractions ! net
[Download RAW message or body]

Paul Ramsey wrote:
> Validity is a terrible chicken and egg problem. Ideally, people would 
> only have valid geometries. So we could enforce a "valid-only" load 
> rule. But then how to people load their data, if they have a few invalid 
> geometries? Do we silently drop them? Then how to they find and fix 
> them? If we let people load invalid geometries (and we pretty much have 
> to) then how do we keep people from running validity-sensitive tests on 
> them? Etc, etc, etc.


You can add constraints on the table so it will only allow valid 
geometries in it:

ALTER TABLE <table> ADD CONSTRAINT isvalid(the_geom) == true;

dave


[prev in list] [next in list] [prev in thread] [next in thread]