can i pass the transition tables to any function from hooks likeExecutorFinish?

Поиск
Список
Период
Сортировка
От Onur ALTUN
Тема can i pass the transition tables to any function from hooks likeExecutorFinish?
Дата
Msg-id MN2PR01MB5342DCCA124900C8042A6065ABFD0@MN2PR01MB5342.prod.exchangelabs.com
обсуждение исходный текст
Список pgsql-hackers
i want to audit dml changes to my audit table and i dont want to use trigger. i am trying to pass the transition table data to my function. (or another solution) i want to write an extension and my code is like above.

if (queryDesc->operation == CMD_INSERT) {       SPI_connect();
       Oid argtypes[1] = { REGTYPEOID }; **//whatever**
       SPI_execute_with_args("SELECT save_insert($1)", 1, argtypes, queryDesc->estate->es_tupleTable, NULL, true, 0);
       SPI_finish();   }

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Planning counters in pg_stat_statements (using pgss_store)
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager