BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89
От | PG Bug reporting form |
---|---|
Тема | BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89 |
Дата | |
Msg-id | 16313-a5df92f1eeaaf79b@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16313: [2528] ERROR: column pd.adsrc does not exist atcharacter 89
|
Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: