From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
To: 066ce286@free.fr
Cc: Mukesh Rajpurohit <vivasvan1902@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Oracle error log table equivalent in postgresql
Date: Fri, 6 Aug 2021 18:00:12 +0530
Message-ID: <CAM+6J973OY3B+0CiW45b_M2sv8th_Zp2CkTwsdyFtim_LGoFmA@mail.gmail.com> (raw)
In-Reply-To: <1988438991.782818247.1628252572604.JavaMail.root@zimbra82-e14.priv.proxad.net>
References: <CAL+ptAAXpddCv1HR90sest4RpD2AHhfoC-5y5eRyZJEr=U9O0g@mail.gmail.com>
<1988438991.782818247.1628252572604.JavaMail.root@zimbra82-e14.priv.proxad.net>
On Fri, Aug 6, 2021, 5:53 PM <066ce286@free.fr> wrote:
> > Hi all,
> > I am porting oracle procedures into postgresql code and some oracle
> > procedure contain error log table and save exception code. I could
> > not find any equivalent of it in postgresql.
> >
> >
> > Please help if any pointer or lead to its solution.
>
If I understand correctly, you want to log exceptions to a table, or
assume it is logged to some system table.
I am not sure if there is inbuilt setup that logs the exceptions or any
messages to some table.
Everything gets logged to logfile based on how logging is configured.
There are ways where you can enable csv logging to file and use file_fdw to
make it queryable via sql query.
https://www.postgresql.org/docs/current/file-fdw.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vijaykumarjain.github@gmail.com, 066ce286@free.fr, vivasvan1902@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Oracle error log table equivalent in postgresql
In-Reply-To: <CAM+6J973OY3B+0CiW45b_M2sv8th_Zp2CkTwsdyFtim_LGoFmA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox