pgsql-server/contrib/adddepend README.adddepen ... - Mailing list pgsql-committers

From momjian@svr1.postgresql.org (Bruce Momjian)
Subject pgsql-server/contrib/adddepend README.adddepen ...
Date
Msg-id 20030625011109.82CE730F94B@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@svr1.postgresql.org    03/06/24 22:11:09

Modified files:
    contrib/adddepend: README.adddepend adddepend

Log message:
    - Corrections for tables, columns with uppercase characters
    - Don't attempt to convert partial or expressional unique indexes
    - Don't attempt to convert unique indexes based on a non-default
    opclasses

    - Untested prevention of conversion of non-btree indexes unique
    indexes.  Untested as postgresql doesn't allow hash, gist, or rtree
    based indexes to be unique.

    rbt=# create unique index t on a using hash (col);
    ERROR:  DefineIndex: access method "hash" does not support UNIQUE
    indexes
    rbt=# create unique index t on a using gist (col);
    ERROR:  DefineIndex: access method "gist" does not support UNIQUE
    indexes
    rbt=# select version();
    version
    ------------------------------------------------------------------------
    PostgreSQL 7.4devel on i386-unknown-freebsd4.8, compiled by GCC 2.95.4

    Rod Taylor


pgsql-committers by date:

Previous
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql-server/contrib/dblink README.dblink dbli ...
Next
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql-server/doc/src/sgml runtime.sgml