Re: Issue related to audit trigger after upgrade to Postgresql9.6

[Vikash Pandey <vikash.kumar.pandey@xxxxxxxxx>]

Hi,

Does anyone has any idea?

We are stuck.

Regards

Vikash Kumar Pandey

On Mon, Jan 2, 2017 at 1:25 PM, Vikash Pandey <vikash.kumar.pandey@xxxxxxxxx> wrote:

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.