Re: BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89

On Monday, March 23, 2020, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 16313
> Logged by: jaheer shaik
> Email address: jaheershaik1234(at)gmail(dot)com
> PostgreSQL version: 12.2
> Operating system: window 10
> Description:
>
>
> pg_catalog.pg_class pc ON (pa.attrelid = pc.oid) LEFT JOIN
> pg_catalog.pg_attrdef pd ON (pd.adnum = pa.attnum) AND (pd.adrelid =
> pc.oid)
>
>

> i am getting ERROR: column pd.adsrc does not exist at character 89 when
> ever i am trying to execute the query from my application with
> posgreSQL12.2
> version.it works fine with 11.
>

Its not a bug. Catalog structures change. The version 11 user
documentation note for this catalog table even tells you not to use the
column and provides an alternative.

You can probably find more info as to why now by looking at the git commit
that removed it (and maybe nearby) but we’ve been getting rid of quite a
bit of cruft recently.

David J.