The following bug has been logged on the website:
Bug reference: 15670
Logged by: Michael Binder
Email address: michael@mibi.io
PostgreSQL version: 11.2
Operating system: Debian 9.8
Description:
Hi,
I don't know if this is the expected behavior but when I execute this
script:
create table test1 (
id serial primary key,
name text
);
create table test2 (
id serial primary key
);
alter table test2 add column if not exists test1_fk integer not null
references test1(id);
alter table test2 add column if not exists test1_fk integer not null
references test1(id);
alter table test2 add column if not exists test1_fk integer not null
references test1(id);
I end up with 3 FK constrains:
select
constraint_name
from information_schema.key_column_usage
where table_name='test2'
and position_in_unique_constraint is not null;
--
test2_test1_fk_fkey
test2_test1_fk_fkey1
test2_test1_fk_fkey2
best regards,
Michael Binder