Re: version compatibility

Soni,

It looks like a query that would come from DBD::Pg.

Unless there's some reason you can't, I recommend always upgrading to the 
latest version of DBD::Pg.

Jon


On Mon, 11 Oct 2021, Soni M wrote:

> 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.