pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / 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>
  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:11  David G. Johnston <david.g.johnston@gmail.com>
  parent: PG Bug reporting form <noreply@postgresql.org>
  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