Re: [BUGS] BUG #5115: ADD UNIQUE table_constraint with expression

2009-10-14 Thread Tom Lane
=?UTF-8?B?VmxhZGltaXIgS29rb3ZpxIc=?= writes: > Real question is "Why we need two syntaxes for the same thing ?" Because the SQL standard says so: UNIQUE-constraint syntax is limited to simple column names. We can't just extend that because it would break the information_schema views, which are o

Re: [BUGS] BUG #5115: ADD UNIQUE table_constraint with expression

2009-10-14 Thread Heikki Linnakangas
Vladimir Kokovic 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. > > But if expression is used in the constraint definition > server says: > # ALTER TABLE asoft_finansije.gk

Re: [BUGS] BUG #5115: ADD UNIQUE table_constraint with expression

2009-10-14 Thread Tom Lane
"Vladimir Kokovic" writes: > 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. > But if expression is used in the constraint definition > server says: > # ALTER TABLE asoft_finansije.

Re: [BUGS] BUG #5115: ADD UNIQUE table_constraint with expression

2009-10-14 Thread Kevin Grittner
"Vladimir Kokovic" 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 sup

[BUGS] BUG #5115: ADD UNIQUE table_constraint with expression

2009-10-14 Thread Vladimir Kokovic
The following bug has been logged online: Bug reference: 5115 Logged by: Vladimir Kokovic Email address: vladimir.koko...@a-asoft.com PostgreSQL version: PostgreSQL 8.4. Operating system: Linux vlD-kuci 2.6.28-15-generic #52-Ubuntu SMP Wed Sep 9 10:49:34 UTC 2009 i686 GNU/Lin