[ADMIN] Issue related to audit trigger after upgrade to Postgresql9.6

Поиск
Список
Период
Сортировка
От Vikash Pandey
Тема [ADMIN] Issue related to audit trigger after upgrade to Postgresql9.6
Дата
Msg-id CAJdaY-Z+or-nGAw6sC78X+gW5q10-sfsSd1wnd_wFx+SJvTj+Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: [ADMIN] Issue related to audit trigger after upgrade to Postgresql9.6  (Vikash Pandey <vikash.kumar.pandey@gmail.com>)
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ertan Küçükoğlu
Дата:
Сообщение: Re: [ADMIN] Creating a database with LC_COLLATE tr_TR.UTF-8
Следующее
От: Ram DBA
Дата:
Сообщение: [ADMIN] Table/View creation time