-
Bug
-
Resolution: Done
-
Critical
-
None
-
5
-
False
-
-
True
-
subs-swatch
-
-
For logical replication to work correctly in Postgresql, all tables need to have a primary key. The databasechangelog_swatch_metrics_hbi table was recently added without a primary key and needs to have one added. We've done this to other databasechangelog tables so consult the migrations directories to find examples.
Done Criteria:
- Primary key added to databasechangelog_swatch_metrics_hbi
- The query
select tab.table_schema, tab.table_name from information_schema.tables tab left join information_schema.table_constraints tco on tab.table_schema = tco.table_schema and tab.table_name = tco.table_name and tco.constraint_type = 'PRIMARY KEY' where tab.table_type = 'BASE TABLE' and tab.table_schema not in ('pg_catalog', 'information_schema') and tco.constraint_name is null order by table_schema, table_name;
returns no rows.