Re: Oracle error log table equivalent in postgresql

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: Oracle error log table equivalent in postgresql
Дата
Msg-id CAM+6J96aZ15LHTkRiZxHEVoVEvDrr9drGh_OqpkNHS50jsXdxA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Oracle error log table equivalent in postgresql  (Mukesh Rajpurohit <vivasvan1902@gmail.com>)
Список pgsql-admin
Дерево обсуждения


On Fri, 6 Aug 2021 at 18:27, Mukesh Rajpurohit <vivasvan1902@gmail.com> wrote:
Thanks. I got how to capture errmsg, errcode etc into error log table however my aim is to insert rejected rows too in error log table with all its column data. If you know error log table feature in oracle then you could relate what I am trying to achieve here.


PS: this may not be helpful, but just in case you want to implement something custom.

reading this,
I have not seen anyone implement something like that here, maybe the experts would have more detail.
but, i think this would require a custom function,
something like this, a small try catch, setup where you can log all the relevant fields required for your error log.
i have used jsonb for now.


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

Предыдущее
От: "Ferrell, Helen D NAVSURFWARCEN DAH VA, V53"
Дата:
Сообщение: RE: [Non-DoD Source] Re: Query related to Linux Upgrade
Следующее
От: Gilles Darold
Дата:
Сообщение: Re: Oracle error log table equivalent in postgresql