Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Issue related to audit trigger after upgrade to Postgresql9.6 - Mailing list pgsql-admin

From Vikash Pandey
Subject Re: [ADMIN] Issue related to audit trigger after upgrade to Postgresql9.6
Date
Msg-id CAJdaY-aAVUKxTR0kzsfvA8wRNQ8xnmdH7wi3=9qALZx2WHwMzQ@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Issue related to audit trigger after upgrade to Postgresql9.6  (Vikash Pandey <vikash.kumar.pandey@gmail.com>)
Responses Re: [ADMIN] Issue related to audit trigger after upgrade to Postgresql9.6  (Jaime Soler <jaime.soler@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com> 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.


pgsql-admin by date:

Previous
From: PAWAN SHARMA
Date:
Subject: [ADMIN] Moving from 9.5 to 9.6
Next
From: Christoph Berg
Date:
Subject: Re: [ADMIN] Pg_upgradecluster failed