Re: small bug in ADD CONSTRAINT - Mailing list pgsql-bugs

On Wed, 10 Mar 2004, Joseph Shraibman wrote:

> This works:
>
>   ALTER TABLE segment ADD CONSTRAINT  name  unique(textfield, reseller);
>
> This doesn't:
>   ALTER TABLE segment ADD CONSTRAINT  name  unique(lower(textfield),
> reseller);
>
> I had to create a unique index.

I don't think this is a bug since it means that we properly accept a
column name list in the unique constraint as per at least SQL92.