Date: Wed, 26 Feb 2025 06:33:07 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Pgsql-general <pgsql-general@postgresql.org>
Message-ID: <321523931.3980391.1740551587184@mail.yahoo.com>
In-Reply-To: <CAKAnmmK84G08eah=U9cjWsDzv8efh=hhpd3zA4rM2J-+tiiUNQ@mail.gmail.com>
References: <611536258.144285.1740484963829.ref@mail.yahoo.com> <611536258.144285.1740484963829@mail.yahoo.com> <CAKAnmmK84G08eah=U9cjWsDzv8efh=hhpd3zA4rM2J-+tiiUNQ@mail.gmail.com>
Subject: Re: Corruption of few tables
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_3980390_1485647180.1740551587183"
Content-Length: 7906
Archived-At: <https://www.postgresql.org/message-id/321523931.3980391.1740551587184%40mail.yahoo.com>
Precedence: bulk

------=_Part_3980390_1485647180.1740551587183
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 Thanks
// Following is the PB code to retrieve data
ls_pack_version =3D fn_get_product_version()ls_pack_build=C2=A0 =C2=A0=3D f=
n_get_product_build()
Select releasenumber, buildnumber Into=C2=A0 =C2=A0:ls_db_version, :ls_db_b=
uild From=C2=A0 =C2=A0public.co_version Where=C2=A0 modulename =3D 'ALL';  =
If SQLCA.sqlcode <> 0 Then=C2=A0 =C2=A0 ls_db_version =3D ''=C2=A0 =C2=A0 l=
s_db_build=C2=A0 =C2=A0=3D 'base'End If
If ls_pack_version <> ls_db_version Then=C2=A0 =C2=A0as_msg=C2=A0 =C2=A0=3D=
 'Version do not match.~r~nDB Ver : ' + ls_db_version=C2=A0 =C2=A0as_msg +=
=3D '=C2=A0 =C2=A0 =C2=A0 Build : ' + ls_db_build=C2=A0 =C2=A0as_msg +=3D '=
~r~nPack.Ver : ' + ls_pack_version=C2=A0 =C2=A0as_msg +=3D '=C2=A0 =C2=A0 =
=C2=A0 Build : ' + ls_pack_build=C2=A0 =C2=A0as_msg +=3D '~r~nPlease upgrad=
e Program or Database'=C2=A0 =C2=A0Messagebox('Error' as_msg)=C2=A0 =C2=A0R=
eturn FalseEnd If
We get the above message [ Version do not match .... ], as SQLCA.Sqlcode re=
turned is not ZERO.=C2=A0 [ Successful read will return ZERO ]
We tried selecting tables from PGAdmin also, where we got Disconnected from=
 the Server...=C2=A0 error message.
    On Tuesday 25 February, 2025 at 07:02:40 pm IST, Greg Sabino Mullane <h=
tamfids@gmail.com> wrote: =20
=20
 On Tue, Feb 25, 2025 at 7:03=E2=80=AFAM sivapostgres@yahoo.com <sivapostgr=
es@yahoo.com> wrote:
1.=C2=A0 Why is corruption happening?=C2=A0 How to find out the reason?

It sounds more like user error than actual corruption, but without more dat=
a we cannot determine. Show us the exact commands you ran, along with the r=
esults you expected to see, and the results you got. Provide as much detail=
 as possible. A reproducible=C2=A0test case would be ideal.

Happiness Always


That is an excellent valediction, thanks for that.
Cheers,Greg
--Crunchy Data - https://www.crunchydata.comEnterprise Postgres Software Pr=
oducts & Tech Support
 =20
------=_Part_3980390_1485647180.1740551587183
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydp53558671yahoo-style-wrap" style=
=3D"font-family:times new roman, new york, times, serif;font-size:16px;"><d=
iv></div>
        <div dir=3D"ltr" data-setdir=3D"false">Thanks</div><div dir=3D"ltr"=
 data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">// =
Following is the PB code to retrieve data</div><div dir=3D"ltr" data-setdir=
=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false"><div><div dir=
=3D"ltr" data-setdir=3D"false">ls_pack_version =3D fn_get_product_version()=
</div><div>ls_pack_build&nbsp; &nbsp;=3D fn_get_product_build()</div><div><=
br></div></div></div><div dir=3D"ltr" data-setdir=3D"false"><div><div><span=
>Select releasenumber, buildnumber</span></div><div><span><span>=09</span>I=
nto&nbsp; &nbsp;:ls_db_version, :ls_db_build</span></div><div><span><span>=
=09</span>From&nbsp; &nbsp;public.co_version</span></div><div><span><span>=
=09</span>Where&nbsp; modulename =3D 'ALL';</span></div><div><span>=09</spa=
n></div><div><span><span>=09</span>If SQLCA.sqlcode &lt;&gt; 0 Then</span><=
/div><div><span><span></span>&nbsp; &nbsp; ls_db_version =3D ''</span></div=
><div><span><span></span>&nbsp; &nbsp; ls_db_build&nbsp; &nbsp;=3D 'base'</=
span></div><div dir=3D"ltr" data-setdir=3D"false">End If</div></div><div di=
r=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"f=
alse"><div><div>If ls_pack_version &lt;&gt; ls_db_version Then</div><div><s=
pan><span></span>&nbsp; &nbsp;as_msg&nbsp; &nbsp;=3D 'Version do not match.=
~r~nDB Ver : ' + ls_db_version</span></div><div><span><span></span>&nbsp; &=
nbsp;as_msg +=3D '&nbsp; &nbsp; &nbsp; Build : ' + ls_db_build</span></div>=
<div><span><span></span>&nbsp; &nbsp;as_msg +=3D '~r~nPack.Ver : ' + ls_pac=
k_version</span></div><div><span><span></span>&nbsp; &nbsp;as_msg +=3D '&nb=
sp; &nbsp; &nbsp; Build : ' + ls_pack_build</span></div><div><span><span></=
span>&nbsp; &nbsp;as_msg +=3D '~r~nPlease upgrade Program or Database'</spa=
n></div><div dir=3D"ltr" data-setdir=3D"false"><span>&nbsp; &nbsp;Messagebo=
x('Error' as_msg)</span></div><div><span><span></span>&nbsp; &nbsp;Return F=
alse</span></div><div>End If</div><div><br></div></div><div dir=3D"ltr" dat=
a-setdir=3D"false">We get the above message [ Version do not match .... ], =
as SQLCA.Sqlcode returned is not ZERO.&nbsp; [ Successful read will return =
ZERO ]</div><br></div><div dir=3D"ltr" data-setdir=3D"false">We tried selec=
ting tables from PGAdmin also, where we got Disconnected from the Server...=
&nbsp; error message.</div><br></div>
       =20
        </div><div id=3D"ydpf0b5eafbyahoo_quoted_0895310061" class=3D"ydpf0=
b5eafbyahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Tuesday 25 February, 2025 at 07:02:40 pm IST, Gr=
eg Sabino Mullane &lt;htamfids@gmail.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div id=3D"ydpf0b5eafbyiv1388981355"><div><div dir=3D"=
ltr"><div dir=3D"ltr">On Tue, Feb 25, 2025 at 7:03=E2=80=AFAM <a shape=3D"r=
ect" href=3D"mailto:sivapostgres@yahoo.com" rel=3D"nofollow" target=3D"_bla=
nk">sivapostgres@yahoo.com</a> &lt;<a shape=3D"rect" href=3D"mailto:sivapos=
tgres@yahoo.com" rel=3D"nofollow" target=3D"_blank">sivapostgres@yahoo.com<=
/a>&gt; wrote:</div><div class=3D"ydpf0b5eafbyiv1388981355gmail_quote ydpf0=
b5eafbyiv1388981355gmail_quote_container"><blockquote style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;" clas=
s=3D"ydpf0b5eafbyiv1388981355gmail_quote"><div style=3D"font-family:new tim=
es, serif;font-size:16px;"><div dir=3D"ltr">1.&nbsp; Why is corruption happ=
ening?&nbsp; How to find out the reason?</div><div dir=3D"ltr"></div></div>=
</blockquote><div><br clear=3D"none"></div><div>It sounds more like user er=
ror than actual corruption, but without more data we cannot determine. Show=
 us the exact commands you ran, along with the results you expected to see,=
 and the results you got. Provide as much detail as possible. A reproducibl=
e&nbsp;test case would be ideal.</div><div id=3D"ydpf0b5eafbyiv1388981355yq=
tfd93160" class=3D"ydpf0b5eafbyiv1388981355yqt0909177257"><div><br clear=3D=
"none"></div></div><blockquote style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex;" class=3D"ydpf0b5eafbyiv1388=
981355gmail_quote"><div style=3D"font-family:new times, serif;font-size:16p=
x;"><div dir=3D"ltr"><div id=3D"ydpf0b5eafbyiv1388981355yqtfd83922" class=
=3D"ydpf0b5eafbyiv1388981355yqt0909177257">Happiness Always</div><br clear=
=3D"none"></div></div></blockquote><div><br clear=3D"none"></div><div>That =
is an excellent valediction, thanks for that.</div><div><br clear=3D"none">=
</div><div>Cheers,</div></div><div dir=3D"ltr" class=3D"ydpf0b5eafbyiv13889=
81355gmail_signature"><div dir=3D"ltr"><div>Greg</div><div><br clear=3D"non=
e"></div><div>--</div><div>Crunchy Data - <a shape=3D"rect" href=3D"https:/=
/www.crunchydata.com" rel=3D"nofollow" target=3D"_blank">https://www.crunch=
ydata.com</a></div><div>Enterprise Postgres Software Products &amp; Tech Su=
pport</div><div id=3D"ydpf0b5eafbyiv1388981355yqtfd02618" class=3D"ydpf0b5e=
afbyiv1388981355yqt0909177257"><div><br clear=3D"none"></div></div></div></=
div></div><div id=3D"ydpf0b5eafbyiv1388981355yqtfd65433" class=3D"ydpf0b5ea=
fbyiv1388981355yqt0909177257">
</div></div></div></div>
            </div>
        </div></body></html>
------=_Part_3980390_1485647180.1740551587183--