Обсуждение: BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89

Поиск
Список
Период
Сортировка

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

От
PG Bug reporting form
Дата:
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:

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.

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

От
"David G. Johnston"
Дата:
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.