MIME-Version: 1.0
References: 
 <CAL+ptAAXpddCv1HR90sest4RpD2AHhfoC-5y5eRyZJEr=U9O0g@mail.gmail.com>
 <1988438991.782818247.1628252572604.JavaMail.root@zimbra82-e14.priv.proxad.net>
In-Reply-To: 
 <1988438991.782818247.1628252572604.JavaMail.root@zimbra82-e14.priv.proxad.net>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Fri, 6 Aug 2021 18:00:12 +0530
Message-ID: 
 <CAM+6J973OY3B+0CiW45b_M2sv8th_Zp2CkTwsdyFtim_LGoFmA@mail.gmail.com>
Subject: Re: Oracle error log table equivalent in postgresql
To: 066ce286@free.fr
Cc: Mukesh Rajpurohit <vivasvan1902@gmail.com>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000c9a2505c8e333d7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAM%2B6J973OY3B%2B0CiW45b_M2sv8th_Zp2CkTwsdyFtim_LGoFmA%40mail.gmail.com>
Precedence: bulk

--0000000000000c9a2505c8e333d7
Content-Type: text/plain; charset="UTF-8"

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

--0000000000000c9a2505c8e333d7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Fri, Aug 6, 2021, 5:53 PM  &lt;<a href=3D"mailto:06=
6ce286@free.fr" rel=3D"noreferrer noreferrer" target=3D"_blank">066ce286@fr=
ee.fr</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">&gt; Hi all,<b=
r>
&gt; I am porting oracle procedures into postgresql code and some oracle<br=
>
&gt; procedure contain error log table and save exception code. I could<br>
&gt; not find any equivalent of it in postgresql.<br>
&gt; <br>
&gt; <br>
&gt; Please help if any pointer or lead to its solution.<br></blockquote></=
div></div><div dir=3D"auto"><br></div><div dir=3D"auto">If I understand=C2=
=A0correctly,=C2=A0 you want to log exceptions to a table, or assume it is =
logged to some system table.</div><div dir=3D"auto"><br></div><div dir=3D"a=
uto">I am not sure if there is inbuilt setup that logs the exceptions or an=
y messages to some table.</div><div dir=3D"auto">Everything gets logged to =
logfile=C2=A0 based on how logging is configured.</div><div dir=3D"auto"><b=
r></div><div dir=3D"auto">There are ways where you can enable csv logging t=
o file and use file_fdw to make it queryable via sql query.=C2=A0</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto"><a href=3D"https://www.postgresql=
.org/docs/current/file-fdw.html" target=3D"_blank" rel=3D"noreferrer">https=
://www.postgresql.org/docs/current/file-fdw.html</a></div><div dir=3D"auto"=
><br></div></div>

--0000000000000c9a2505c8e333d7--