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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

apt.postgresql.org Repository Update
The following bug has been logged on the website:

Bug reference:      16313
Logged by:          jaheer shaik
Email address:      [hidden email]
PostgreSQL version: 12.2
Operating system:   window 10
Description:        

2020-03-24 11:23:30.965 +08 [2528] LOG:  connection received:
host=xxx.xx.xx.xx port=50063
2020-03-24 11:23:30.970 +08 [2528] LOG:  connection authorized: user=xxxxx
database=xxxx
2020-03-24 11:23:30.974 +08 [2528] LOG:  statement: SELECT VERSION()
2020-03-24 11:23:30.978 +08 [2528] LOG:  statement: SET
client_encoding='WIN1252'
2020-03-24 11:23:30.982 +08 [2528] LOG:  statement: show integer_datetimes
2020-03-24 11:23:30.986 +08 [2528] LOG:  statement: show bytea_output
2020-03-24 11:23:30.998 +08 [2528] LOG:  execute
PRSTMTST433301360/PORTALST433301360: SELECT * FROM appregistry WHERE
upper(reg_section)=$1 AND upper(reg_name)=$2 AND deleted='0'
2020-03-24 11:23:30.998 +08 [2528] DETAIL:  parameters: $1 = 'BOOKINGS', $2
= 'SENDMAILS'
2020-03-24 11:23:31.005 +08 [2528] ERROR:  column pd.adsrc does not exist at
character 89
2020-03-24 11:23:31.005 +08 [2528] STATEMENT:  SELECT pa.attname, CASE  WHEN
relname = 'appregistry' THEN 0 END AS idx, pa.attnotnull, pd.adsrc,
pi.indisprimary, pc.oid, pa.attnum FROM pg_attribute pa JOIN
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)
LEFT JOIN pg_catalog.pg_index pi ON (pi.indrelid = pc.oid) AND (pa.attnum =
any(pi.indkey)) WHERE (pa.attnum > 0) AND ((pc.relname = 'appregistry'))
ORDER BY idx, pa.attnum
2
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.

Reply | Threaded
Open this post in threaded view
|

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

David G Johnston
On Monday, March 23, 2020, PG Bug reporting form <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      16313
Logged by:          jaheer shaik
Email address:      [hidden email]
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.