Changes between Initial Version and Version 1 of Ticket #1471


Ignore:
Timestamp:
Jan 15, 2012, 12:23:31 PM (12 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #1471 – Description

    initial v1  
    55The main benefit would be to be able to use exclusion constraints (introduced in PostgreSQL 9.0) to enforce geometry uniqueness.  Right now there is no guaranteed way of doing this and EXCLUSION CONSTRAINTS won't work with functions (so ST_OrderingEquals is out of the question) -- they have to be operators.
    66
    7 http://www.postgresql.org/docs/9.0/static/sql-createtable.html#SQL-CREATETABLE-EXCLUDE
     7http://www.postgresql.org/docs/9.0/static/ddl-constraints.html
     8http://thoughts.j-davis.com/2010/09/25/exclusion-constraints-are-generalized-sql-unique/