version compatibility

[email protected] (Soni M) Mon, 11 Oct 2021 19:10:10 +0700
Newsgroups perl.dbd.pg
Message-ID <CAAMgDXkhUbXcBtOfETfzyLP4s6uWJHbfQPEGJgGnQchD6pycWQ@mail.gmail.com>
--000000000000e890b605ce129c53
Content-Type: text/plain; charset="UTF-8"

Hello all,

We are using DBD:Pg version 3.7.0, this version is from the Pg perl module
installed.

Previously we were using PG 9.5, we just upgraded to PG 13. After the
upgrade, we often see error messages like

ERROR: column d.adsrc does not exist at character 331
STATEMENT: SELECT a.attname, i.indisprimary,
pg_catalog.pg_get_expr(adbin,adrelid) FROM pg_catalog.pg_index i,
pg_catalog.pg_attribute a, pg_catalog.pg_attrdef d WHERE i.indrelid = '?')
AND d.adrelid=a.attrelid AND d.adnum=a.attnum AND a.attrelid = 23829 AND
i.indisunique IS TRUE AND a.atthasdef IS TRUE AND i.indkey0
<http://rm.ashlex.com/issues/12527#fn0>=a.attnum AND d.adsrc ~ '^nextval'

It seems that the query comes from dbd::pg.

Can someone confirm this ?
If this is the case, can someone suggest to what version I should upgrade
the dbd::pg ?

Thank You very much for the help. I appreciate it very much.

-- 
Regards,

Soni Maula Harriz

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

<div dir=3D"ltr">Hello all,<div><br></div><div><span style=3D"color:rgb(51,=
51,51);font-family:Verdana,sans-serif;font-size:12px">We are using DBD:Pg v=
ersion 3.7.0, this version is from the Pg perl module installed.</span></di=
v><div><font color=3D"#333333" face=3D"Verdana, sans-serif"><span style=3D"=
font-size:12px"><br></span></font></div><div><font color=3D"#333333" face=
=3D"Verdana, sans-serif"><span style=3D"font-size:12px">Previously we were =
using PG 9.5, we just upgraded to PG 13. After the upgrade, we often see er=
ror messages like=C2=A0<br><br></span></font><span style=3D"color:rgb(51,51=
,51);font-family:Verdana,sans-serif;font-size:12px;font-style:italic;backgr=
ound-color:rgb(255,255,221)">ERROR: column d.adsrc does not exist at charac=
ter 331</span><br style=3D"color:rgb(51,51,51);font-family:Verdana,sans-ser=
if;font-size:12px;font-style:italic;background-color:rgb(255,255,221)"><spa=
n style=3D"color:rgb(51,51,51);font-family:Verdana,sans-serif;font-size:12p=
x;font-style:italic;background-color:rgb(255,255,221)">STATEMENT: SELECT a.=
attname, i.indisprimary, pg_catalog.pg_get_expr(adbin,adrelid) FROM pg_cata=
log.pg_index i, pg_catalog.pg_attribute a, pg_catalog.pg_attrdef d WHERE i.=
indrelid =3D &#39;?&#39;) AND d.adrelid=3Da.attrelid AND d.adnum=3Da.attnum=
 AND a.attrelid =3D 23829 AND i.indisunique IS TRUE AND a.atthasdef IS TRUE=
 AND i.indkey</span><sup style=3D"color:rgb(51,51,51);font-family:Verdana,s=
ans-serif;font-style:italic;background-color:rgb(255,255,221)"><a href=3D"h=
ttp://rm.ashlex.com/issues/12527#fn0" style=3D"color:rgb(17,102,153);text-d=
ecoration-line:none">0</a></sup><span style=3D"color:rgb(51,51,51);font-fam=
ily:Verdana,sans-serif;font-size:12px;font-style:italic;background-color:rg=
b(255,255,221)">=3Da.attnum AND d.adsrc ~ &#39;^nextval&#39;</span><font co=
lor=3D"#333333" face=3D"Verdana, sans-serif"><span style=3D"font-size:12px"=
><br clear=3D"all"></span></font><div><br></div><div>It seems that the quer=
y comes from dbd::pg.</div><div><br></div><div>Can someone confirm this ?</=
div><div>If this is the case, can someone suggest to what version I should =
upgrade the dbd::pg ?</div><div><br></div><div>Thank You very much for the =
help. I appreciate it very much.</div><div><br></div>-- <br><div dir=3D"ltr=
" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"=
ltr"><div>Regards,</div><div><br></div>Soni Maula Harriz</div></div></div><=
/div>

--000000000000e890b605ce129c53--