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

Поиск
Список
Период
Сортировка
От DrakoRod
Тема Trigger before or after update that change row to another child table of a partitioned table
Дата
Msg-id 1481168939997-5933848.post@n3.nabble.com
обсуждение исходный текст
Список pgsql-novice
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.


В списке pgsql-novice по дате отправления:

Предыдущее
От: Killian Driscoll
Дата:
Сообщение: Re: Query to return data types
Следующее
От: Dima Pavlov
Дата:
Сообщение: [NOVICE] Boolean column in multicolumn index