Обсуждение: Trigger before or after update that change row to another child table of a partitioned table

Поиск
Список
Период
Сортировка

Trigger before or after update that change row to another child table of a partitioned table

От
DrakoRod
Дата:
Hi verybody

I'm novice in plpgsql and I have to partition a table, with trigger that
insert and update row.

The insert trigger is easy and I had no problem with this. But the process
to update row does nothing (even raise notice does not work). For each row
updated I need that this row be eliminated in the child table and inserted
in a history child table.

Someone have a example with a trigger like this?

Best Regards




-----
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
View this message in context:
http://postgresql.nabble.com/Trigger-before-or-after-update-that-change-row-to-another-child-table-of-a-partitioned-table-tp5933848.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.