Re: 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: Re: Issue related to audit trigger after upgrade to Postgresql9.6
Date: 2017-01-19 13:24:14
Message-ID: CAJdaY-aAVUKxTR0kzsfvA8wRNQ8xnmdH7wi3=9qALZx2WHwMzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)kumar(dot)pandey(at)gmail(dot)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.
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christoph Berg 2017-01-19 13:24:59 Re: Pg_upgradecluster failed
Previous Message PAWAN SHARMA 2017-01-19 11:58:44 Moving from 9.5 to 9.6