Issue related to audit trigger after upgrade to Postgresql9.6

From: Vikash Pandey <vikash(dot)kumar(dot)pandey(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Issue related to audit trigger after upgrade to Postgresql9.6
Date: 2017-01-02 07:55:46
Message-ID: CAJdaY-Z+or-nGAw6sC78X+gW5q10-sfsSd1wnd_wFx+SJvTj+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We have upgraded database from 9.2 to 9.6.
In 9.2 we were using auditing of tables through audit trigger.
https://wiki.postgresql.org/wiki/Audit_trigger_91plus

In this trigger function there is transaction_id which is generated by
txid_current()
After upgradation this transaction_id some how reset itself which was
unexpected.
Our applications depend on this transaction_id which is misbehaving
currently.
How we can handle this situation.

Thanks in advance.

Regards
Vikash Kumar Pandey.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ram DBA 2017-01-02 10:17:40 Table/View creation time
Previous Message Ertan Küçükoğlu 2016-12-30 15:13:47 Re: Creating a database with LC_COLLATE tr_TR.UTF-8