Re: Database issues when adding GUI

On Mon, Jun 7, 2021 at 2:26 PM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
wrote:

> On Mon, 7 Jun 2021, Tom Lane wrote:
>
> > We removed the pg_attrdef.adsrc catalog column a couple versions back.
> > You're evidently using quite an old version of whichever client-side
> > library is issuing this command. You need to get a more up-to-date copy
> > that knows what to do instead.
>
> Tom,
>
> In what version was that removed? Now I have postgresql-12.7 installed and
> when I try to access the activitytypes table it still fails with the same
> error:
>
> 2021-06-07 10:36:38.304 PDT [29537] LOG: starting PostgreSQL 12.7 on
> x86_64-slackware-linux-gnu, compiled by gcc (GCC) 5.5.0, 64-bit
> 2021-06-07 10:36:38.304 PDT [29537] LOG: listening on IPv4 address
> "127.0.0.1", port 5432
> 2021-06-07 10:36:38.310 PDT [29537] LOG: listening on Unix socket
> "/tmp/.s.PGSQL.5432"
> 2021-06-07 10:36:38.322 PDT [29538] LOG: database system was shut down at
> 2021-06-07 10:36:17 PDT
> 2021-06-07 10:36:38.330 PDT [29537] LOG: database system is ready to
> accept connections
> 2021-06-07 14:19:45.491 PDT [31353] ERROR: column pg_attrdef.adsrc does
> not exist at character 128
> 2021-06-07 14:19:45.491 PDT [31353] STATEMENT: select
> pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.attnotnull,
> pg_attribute.attlen, pg_attribute.atttypmod, pg_attrdef.adsrc from
> pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid =
> pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) where
> pg_table_is_visible(pg_class.oid) and pg_class.relname = 'activitytypes'
> and pg_attribute.attnum > 0 and pg_attribute.attrelid = pg_class.oid and
> pg_attribute.attisdropped = false order by pg_attribute.attnum
>
>
If all you did was upgrade the server, and not the client that is issuing
the query, then, yes, you will get the same error, since the server isn't
the problem.

David J.