T
Маусым 7, 2023, 9:12 Т.Қ.

SQLОшибка при выполнении триггерной функции (GreenPlum)

PgSQL, GreenPlum, Триггерные функции

Есть 3 таблицы fact_amount со структурой:

  1. CREATE TABLE fact_amount (
  2. id serial4 NOT NULL,
  3. fdate date NULL,
  4. type_activity_id int4 NULL,
  5. status_id int4 NULL,
  6. CONSTRAINT fact_amount_pk_1 PRIMARY KEY (id),
  7. CONSTRAINT fact_amount_fk_1 FOREIGN KEY (category_id) REFERENCES mdv_db.spr_category(category_id),
  8. CONSTRAINT fact_amount_fk_2 FOREIGN KEY (status_id)
Оқы