Re: Unique constraints

Dave Page wrote:

>Hi Guys,
>
>In PostgreSQL 7.2, unique constraints were just indexes. In 7.3 however,
>it knows they are constraints and thus will not allow you to simply drop
>the index.
>
>Should we add an extra object type under pgTable to contain such indexes
>or can anyone think of a better solution?
>
>
>
Maybe we should reorganize the tree like this:

Tables
    tableFoo
       Columns
          col1
          col2
          col3
       Constraints
          pk_tableFoo
          fk_refToBar
          chk_range
          unq_col3
       Indexes
          idx_one
          idx_two_unq_non_constr
       Rules
       Triggers

I'd like to have less collections under <table>, since most of them have
few members and consume precious screen space.

Regards,
Andreas