Creating index on unique column results in not working unique constraint

[dominik-zeglen]

Describe the bug

If you create index on a column that is defined as UNIQUE, it stops being unique if you add index to it. Defining it as CREATE UNIQUE INDEX fixes it but it behaves differently than postgres.

To Reproduce

create table a (
    id serial not null primary key,
    name varchar(32) not null unique
);

insert into a ("name") values ('foo');
CREATE INDEX a_name_index ON a USING btree (name);

insert into a ("name") values ('foo');
select * from a;

pg-mem version

2.6.13

[krumft]

This could be related to https://github.com/oguimbal/pg-mem/pull/333 - can you check if that PR fixes your problem?

[oguimbal]

this PR has been released as pg-mem@2.7.0, so feel free to close if that fixes your issue :)