Postgres Pro
Downloads
Home   >   mailing lists

can i pass the transition tables to any function from hooks likeExecutorFinish? - Mailing list pgsql-hackers

From Onur ALTUN
Subject can i pass the transition tables to any function from hooks likeExecutorFinish?
Date
Msg-id MN2PR01MB5342DCCA124900C8042A6065ABFD0@MN2PR01MB5342.prod.exchangelabs.com
Whole thread Raw
List pgsql-hackers
Tree view
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 by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Planning counters in pg_stat_statements (using pgss_store)
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager