pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89 2+ messages / 2 participants [nested] [flat]
* BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89 @ 2020-03-24 04:02 PG Bug reporting form <noreply@postgresql.org> 2020-03-24 04:11 ` Re: BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89 David G. Johnston <david.g.johnston@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2020-03-24 04:02 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: jaheershaik1234@gmail.com 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89 2020-03-24 04:02 BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89 PG Bug reporting form <noreply@postgresql.org> @ 2020-03-24 04:11 ` David G. Johnston <david.g.johnston@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: David G. Johnston @ 2020-03-24 04:11 UTC (permalink / raw) To: jaheershaik1234@gmail.com <jaheershaik1234@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org> 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-03-24 04:11 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-03-24 04:02 BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89 PG Bug reporting form <noreply@postgresql.org> 2020-03-24 04:11 ` Re: BUG #16313: [2528] ERROR: column pd.adsrc does not exist at character 89 David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox