Re: small bug in ADD CONSTRAINT

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: small bug in ADD CONSTRAINT
Date: 2004-03-13 20:16:49
Message-ID: 20040313121443.N21437@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stefan Hans 2004-03-15 09:31:21 has_function_privilege()
Previous Message Tom Lane 2004-03-13 20:05:56 Re: small bug in ADD CONSTRAINT