[HACKERS] Hooks Docu - list of hooks
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi to all! I am searching for a documentation of hooks in PG, all i found was a presentation in the wiki and some modules from 2ndQuadrant and petere on github. The last three weeks i was reading the source code to get some information. Is there a list of possible hooks, or maybe a little docu or overview? Especially hooks to catch Insert, Update and Delete Stmts and SubQuerys. It would help a lot to finish / write a log into Tables Module. Please excuse my mail, if there was a similar question on the list, i subscribed today and a simple search in the archive showd no results. regards geohas PS: I've an excuse for my bad english - i'am austrian ;) -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTqVetAAoJEJFGMlQe7wR/ae0H/Rkt0G5d6kspgWhPyN/aIWIS wTYKDdxDWt+EeyuCg7SWx/UxJLW22wnWKxmLjvfkT+/ibkCv5qmYRLMOh+cvH0O9 AimWP7fZX+VpYSfpmm/SuvuwUM3OQiM3iwU6MIpu4XfrulAD3F94/aafNp3D2jBK Fz/J/Sjmr9LN/YBuE99i6asUJG669m4ISsmMpNwXPAh3wv+A3sN0dhvDCFJ11iCL hIXqktMpm60iI5sIQUPUjgSTHFTj3aGuKtX3OCWPM4CHoaHwDNtq1klHeuiLSb3y enjMW4tvTWtPw8DIkEgpatn8gsJvXVIjfsZPiTsp8HbN2evhkYxsgfV89R8usRU= =vA51 -END PGP SIGNATURE- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Hooks Docu - list of hooks
At 2014-06-24 12:49:17 +0200, li...@hasibether.at wrote: Is there a list of possible hooks, or maybe a little docu or overview? The best I found was git grep _hook_type and then read the code to understand when and why the hook was called. Especially hooks to catch Insert, Update and Delete Stmts and SubQuerys. It would help a lot to finish / write a log into Tables Module. Look at how pgaudit does it: https://github.com/2ndQuadrant/pgaudit The code has comments about how the various available hooks are used. (I was planning to implement a bgwriter that wrote log messages to a table, which sounds a bit like what you want to do.) -- Abhijit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Hooks Docu - list of hooks
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 24/06/14 12:59, Abhijit Menon-Sen wrote: At 2014-06-24 12:49:17 +0200, li...@hasibether.at wrote: Is there a list of possible hooks, or maybe a little docu or overview? The best I found was git grep _hook_type and then read the code to understand when and why the hook was called. Especially hooks to catch Insert, Update and Delete Stmts and SubQuerys. It would help a lot to finish / write a log into Tables Module. Look at how pgaudit does it: https://github.com/2ndQuadrant/pgaudit I already tried pgaudit ;), one of the best examples, it helped me much. The code has comments about how the various available hooks are used. (I was planning to implement a bgwriter that wrote log messages to a table, which sounds a bit like what you want to do.) The module i'm thinking of, working on, is a bit inspired from pgaudit and petere's pg_trashcan. It should copy every created table in a shadow-schema with extra columns for record on / record off and Userid (this is already working ;)). In case of a drop statement it should rename the table in the shadow schema XXX-droped-Date. Now i am trying to catch the planned Stmts, ... It should work without triggers - because the shadow schema should only be visible for user postgres. regards geohas -- Abhijit -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTqWQ4AAoJEJFGMlQe7wR/8CEIAJihWVGc//dDHGF9lDtMo3Ds v1Xhd5U9n1tLL/Cx0/cqnslKctdfSCY2I/ptjNSDFO8U/YdUjNdPf4nYvxn0gjKR n8VuC61BDr6qHFQvlJE7GLv2hs2GCxFM5dEgnV7foJjT18C/VgnSRFulJzxU87EZ 8uKG53+CM9ERDa5P9py9jyvrJJvIAXk9AAfevU9g+jimwK9OntwkC7ZfyVWEDwfr x7LDyrzhge/EIco01pzJSimuVd0BPvTQ8V7XUTpy25xS+D8968wE8eRBaMWXH0b2 KR5lju+sz+SyVQKildcyExOEQWN3PgVmST5USAy9cAzPIuic+yR+qsa5H2VRTFI= =ZYct -END PGP SIGNATURE- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers