Re: BUG #5115: ADD UNIQUE table_constraint with expression - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #5115: ADD UNIQUE table_constraint with expression
Date
Msg-id 4AD5A4A4020000250002B922@gw.wicourts.gov
Whole thread Raw
In response to BUG #5115: ADD UNIQUE table_constraint with expression  ("Vladimir Kokovic" <vladimir.kokovic@a-asoft.com>)
List pgsql-bugs
"Vladimir Kokovic" <vladimir.kokovic@a-asoft.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

pgsql-bugs by date:

Previous
From: "Vladimir Kokovic"
Date:
Subject: BUG #5115: ADD UNIQUE table_constraint with expression
Next
From: Tom Lane
Date:
Subject: Re: BUG #5115: ADD UNIQUE table_constraint with expression