Date: Tue, 5 Nov 2024 23:22:15 +0100
From: Christoph Moench-Tegeder <cmt@burggraben.net>
To: Matt Zagrabelny <mzagrabe@d.umn.edu>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: adsrc
Message-ID: <Zyqal6ZAUoI81Jne@elch.exwg.net>
References: <CAOLfK3U80_x7V1w_t2tJFMVPhgKMXz1YmpAzEGDkstquBwW0LA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <CAOLfK3U80_x7V1w_t2tJFMVPhgKMXz1YmpAzEGDkstquBwW0LA@mail.gmail.com>
User-Agent: Mutt/2.2.13 (2024-03-09)
Archived-At: <https://www.postgresql.org/message-id/Zyqal6ZAUoI81Jne%40elch.exwg.net>
Precedence: bulk

## Matt Zagrabelny (mzagrabe@d.umn.edu):

> I'd like to upgrade the database to Pg 15, but when I connect and perform
> some tasks in the app, I get:
> 
> ERROR:  column d.adsrc does not exist at character 331

That pg_attrdef.adsrc was already marked as "historical, and is best
not used" in 9.4: https://www.postgresql.org/docs/9.4/catalog-pg-attrdef.html
(In fact, that notice was added in 8.0).
The official way to get the human-readable representation of the
column's default value is "pg_get_expr(d.adbin, d.adrelid)" (use that
instead of d.adsrc) - that way the fix is rather straight-forward.
Documentation on pg_get_expr() is in this table:
https://www.postgresql.org/docs/15/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE

Regards,
Christoph

-- 
Spare Space