Re: Adddepend

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Adddepend
Date: 2003-06-24 02:52:51
Message-ID: 200306240252.h5O2qpR11790@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

Rod Taylor wrote:
-- Start of PGP signed section.
> - 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 <rbt(at)rbt(dot)ca>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc

[ Attachment, skipping... ]
-- End of PGP section, PGP failed!

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

  • Adddepend at 2003-06-18 15:02:04 from Rod Taylor

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-06-24 02:53:07 Re: System Catalog Foreign Keys (linked)
Previous Message Bruce Momjian 2003-06-24 02:52:15 Re: DBLink patch