On 06/14/2010 06:55 PM, Phoenix Kiula wrote:
Hi I'm having some issues with a code base where several different programs are updating one "status" column in the DB with their code. Mostly this is working, but in some cases the status column in a DB is getting updated when it shouldn't have been, and we're trying to locate which program did it. While checking through all the code, I'm also wondering if it is possible to somehow maintain a log of which SQL did the updating? My question: how can I set up a "RULE" so that when a specific column is updated, a separate table also logs which update SQL was issued? Thanks for any ideas.
If you are on 8.5, this will be helpful: http://www.depesz.com/index.php/2009/12/29/waiting-for-8-5-application-name-reporting/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
