Re: BUG #16313: [2528] ERROR: column pd.adsrc does not exist atcharacter 89 - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #16313: [2528] ERROR: column pd.adsrc does not exist atcharacter 89
Date
Msg-id CAKFQuwboBO+JaJAGhHjUcsab3gbSLUpWhcZGYi9Zhg+xcVOi-A@mail.gmail.com
Whole thread Raw
In response to BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Monday, March 23, 2020, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16313
Logged by:          jaheer shaik
Email address:      jaheershaik1234@gmail.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.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89
Next
From: Fahar Abbas
Date:
Subject: Re: BUG #16305: Application Stack Builder downloads MacOS JDBC binary