Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE ADD UNIQUE ..... - Mailing list pgsql-general

From Tom Lane
Subject Re: ALTER TABLE ADD UNIQUE .....
Date
Msg-id 29866.1068560450@sss.pgh.pa.us
Whole thread Raw
In response to ALTER TABLE ADD UNIQUE .....  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-general
Tree view 
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> Looks like ADD UNIQUE( some_fuc( some_feild) ) is not supported with add constraint.
> the only way is to add the constriant is using UNIQUE INDEX .
> Is it a bug or intended behaviour?

It's intended.  The syntax and behavior of unique constraints is defined
by the standard, and it doesn't include anything about functional
indexes.

            regards, tom lane

pgsql-general by date:

Previous
From: Christopher Murtagh
Date:
Subject: Re: PL/Perl returning multiple rows
Next
From: bob parker
Date:
Subject: Re: Visio Like Tool....