Правило для INSERT на представление, связывающее таблицы, наследующие друг от друга

CREATE SCEMA common;
CREATE SCEMA address;
 
CREATE TABLE common.entity_classes (
  id_entity serial NOT NULL PRIMARY KEY,
  id_parent public.dm_small_id,
  title VARCHAR(100) NOT NULL,
  short_name VARCHAR(100) NOT NULL,
  sysname VARCHAR(132) NOT NULL,
  schema_name VARCHAR(15) NOT NULL,
  description VARCHAR(255),
  full_name VARCHAR(120),
   CONSTRAINT pk_entity_classes
    PRIMARY KEY (id_entity),
  CONSTRAINT fk_entity_classes
    FOREIGN KEY (id_parent)
    REFERENCES common.entity_classes(id_entity)
    ON UPDATE CASCADE
)
CREATE TABLE common.common_data (
  id_common bigserial NOT NULL PRIMARY KEY,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  user_create INT8,
  updated_at TIMESTAMP,
  user_update INT8,
  deleted_at TIMESTAMP,
  user_delete INT8,
  id_entity public.dm_small_id NOT NULL,
  CONSTRAINT pk_common_data
    PRIMARY KEY (id_common),
  CONSTRAINT fk_common_data_ref_entity
    FOREIGN KEY (id_entity)
    REFERENCES common.entity_classes(id_entity)
    ON DELETE RESTRICT
    ON UPDATE CASCADE
);
 
CREATE TABLE address.location (
  id_location public.dm_common_id NOT NULL PRIMARY KEY,
  location_type public.dm_common_id NOT NULL,
  address VARCHAR(250),
  CONSTRAINT pk_location
    PRIMARY KEY (id_location),
  CONSTRAINT fk_location_link_common_data
    FOREIGN KEY (id_location)
    REFERENCES common.common_data(id_common)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
);
 
CREATE TABLE address.flat (
  id_flat public.dm_common_id NOT NULL PRIMARY KEY,
  id_entrance public.dm_common_id NOT NULL,
  NUMBER public.dm_flat_number NOT NULL,
  letter VARCHAR(7),
  number_floor public.dm_number_floor,
  note public.dm_note,
  id_user public.dm_common_id,
  CONSTRAINT pk_flat
    PRIMARY KEY (id_flat),
  CONSTRAINT fk_flat_ref_location
    FOREIGN KEY (id_flat)
    REFERENCES address.location(id_location)
    ON DELETE RESTRICT
    ON UPDATE CASCADE
);
 
CREATE VIEW address.v_location_change
AS
SELECT
  l.id_location,
  l.location_type,
  COALESCE(user_delete,user_update,user_create) AS user_id,
  COALESCE(deleted_at,updated_at,created_at) AS date_at,
   CASE
 WHEN NOT( deleted_at IS NULL)
 THEN 'D'
 WHEN NOT(updated_at IS NULL)
 THEN 'U'
 ELSE 'I'
 END operation
FROM address.location l
  JOIN common.common_data c ON l.id_location=c.id_common;
 
CREATE VIEW address.v_flat_change
AS
SELECT
  f.id_flat,
  f.id_entrance,
  f.number AS flat_number,
  f.letter,
  f.number_floor,
  l.location_type,
  l.user_id,
  l.date_at,
  l.operation
FROM (address.v_location_change l
  JOIN address.flat f ON l.id_location=f.id_flat;
 
CREATE RULE v_flat_update AS
ON UPDATE TO address.v_flat_change DO INSTEAD (
    UPDATE address.flat
    SET id_entrance=NEW.id_entrance,
         NUMBER=NEW.flat_number ,
         letter=NEW.letter ,
         number_floor=NEW.number_floor
    WHERE id_flat=OLD.id_flat;
    UPDATE common.common_data
    SET updated_at = CURRENT_TIMESTAMP,
        user_update = NEW.user_id
    WHERE id_common=OLD.id_flat;
);
 
CREATE RULE v_flat_delete AS
ON DELETE TO address.v_flat_change DO INSTEAD (
    UPDATE common.common_data
    SET deleted_at = CURRENT_TIMESTAMP,
        user_delete = OLD.user_id
    WHERE id_common=OLD.id_flat;
);

CREATE RULE v_flat_insert AS
ON INSERT TO address.v_flat_change DO INSTEAD (
 
    WITH es AS
    (SELECT id_entity
     FROM common.entity_classes
     WHERE full_name='address.flat'
     RETURNING *
    )
    INSERT INTO common.common_data
      (id_common,user_create, id_entity)
      VALUES
      (NEXTVAL('common.common_data_id_common_seq'),NEW.user_id,es.id_entity)
      RETURNING id_common;
    INSERT INTO address.location
      (id_location,location_type)
      VALUES
      (id_common,NEW.location_type);
    INSERT INTO address.flat
      (id_flat,id_entrance,NUMBER,letter,number_floor)
      VALUES
      (id_common,NEW.id_entrance,NEW.flat_number,
       NEW.letter,NEW.number_floor);
);

CREATE OR REPLACE RULE v_flat_insert AS
 
ON INSERT TO address.v_flat_change DO INSTEAD (
 
    WITH es AS
    (SELECT id_entity
     FROM common.entity_classes
     WHERE full_name='address.flat'
    )        
    INSERT INTO common.common_data
      (id_common,user_create, id_entity)
      VALUES
      ( NEXTVAL('common.common_data_id_common_seq'), NEW.user_id, ( SELECT id_entity FROM es LIMIT 1));
    WITH lt AS
    (SELECT id
     FROM address.dict_location_type
     WHERE sysname='FLAT'
    )        
    INSERT INTO address.location
      (id_location,location_type)
      VALUES
      ( CURRVAL('common.common_data_id_common_seq'),( SELECT id FROM lt LIMIT 1));--new.location_type
    INSERT INTO address.flat
      (id_flat,id_entrance,NUMBER,letter,number_floor)
      VALUES
(CURRVAL('common.common_data_id_common_seq'),NEW.id_entrance,NEW.flat_number,
       NEW.letter,NEW.number_floor);
);