Re: BUG #5115: ADD UNIQUE table_constraint with expression

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Vladimir Kokovic" <vladimir(dot)kokovic(at)a-asoft(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5115: ADD UNIQUE table_constraint with expression
Date: 2009-10-14 15:15:00
Message-ID: 4AD5A4A4020000250002B922@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Vladimir Kokovic" <vladimir(dot)kokovic(at)a-asoft(dot)com> wrote:

> For ALTER TABLE ADD CONSTRAINT documentation says:
> ADD table_constraint
> This form adds a new constraint to a table using the same syntax
< as CREATE TABLE.

Which is specified as UNIQUE ( column_name [, ... ] )

> But if expression is used

it's not supported syntax, per the above.

> Create index is OK:

as one would expect from the documentation:

( { column | ( expression ) } [ opclass ] [, ...] )

This is not a bug.

Maybe there's a feature request in there, but that would belong on
a different list.

-Kevin

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-10-14 15:16:27 Re: BUG #5115: ADD UNIQUE table_constraint with expression
Previous Message Vladimir Kokovic 2009-10-14 14:59:39 BUG #5115: ADD UNIQUE table_constraint with expression