Hi,
On 2017-03-16 12:34:49 -0700, Nikolay Samokhvalov wrote:
> I'm trying to explicitly use the constraint name of my UNIQUE INDEX but it
> doesn't work (Postgres 9.6.2):
>
> [local]:5432 nikolay@test=# create table constr(id serial, msg text);
> CREATE TABLE
>
> [local]:5432 nikolay@test=# create unique index i_constr_msg on constr
> using btree(md5(msg));
> CREATE INDEX
A unique index isn't exactly the same as a unique constraint - you
really need to create a constraint.
- Andres
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs