Загрузка данных


Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/v2/V2.001__OBESPINT-2158-create-partitioned-operational_day-table.sql::06-create-partitioned-table::vloginov:
     Reason: liquibase.exception.DatabaseException: ERROR: unique constraint on partitioned table must include all partitioning columns
  �����������: PRIMARY KEY constraint on table "operational_day" lacks column "created_at" which is part of the partition key. [Failed SQL: (0) CREATE TABLE operational_day (
   id               UUID                        DEFAULT gen_v7_uuid_seq() PRIMARY KEY,
   operday_date     DATE                        NOT NULL,
   client_type      VARCHAR(2)                  NOT NULL,
   is_active        BOOLEAN,
   created_at       TIMESTAMP WITH TIME ZONE    NOT NULL DEFAULT CURRENT_TIMESTAMP,
   updated_at       TIMESTAMP WITH TIME ZONE    NOT NULL DEFAULT CURRENT_TIMESTAMP,

   CONSTRAINT unique_operational_day_date_type UNIQUE (operday_date, client_type)
) PARTITION BY RANGE (created_at)]