MIME-Version: 1.0
References: <CAOLfK3U80_x7V1w_t2tJFMVPhgKMXz1YmpAzEGDkstquBwW0LA@mail.gmail.com>
In-Reply-To: <CAOLfK3U80_x7V1w_t2tJFMVPhgKMXz1YmpAzEGDkstquBwW0LA@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 5 Nov 2024 15:31:13 -0700
Message-ID: <CAKFQuwZKMmbcU4j+OVyYZ8+Wu2quY=A2_+a9Q9JGt8YYHX651Q@mail.gmail.com>
Subject: Re: adsrc
To: Matt Zagrabelny <mzagrabe@d.umn.edu>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b09530062631f7b5"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZKMmbcU4j%2BOVyYZ8%2BWu2quY%3DA2_%2Ba9Q9JGt8YYHX651Q%40mail.gmail.com>
Precedence: bulk

--000000000000b09530062631f7b5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Nov 5, 2024 at 2:45=E2=80=AFPM Matt Zagrabelny <mzagrabe@d.umn.edu>=
 wrote:

> ERROR:  column d.adsrc does not exist at character 331
>
> Some searching online yields that adsrc was removed in Pg 12.
>
> Is there a way to recreate it?
>
>
That is a base catalog table.  Its removal means the data it stored is no
longer being stored.  Even if you somehow got the column reference error to
go away whatever the application is doing with that is going to be
surprised to be handed an empty string.

You could always checkout the source for v15, un-revert the commit removing
that field, compile, and see what happens.  But if you want to use a
community build the application needs to be changed along with upgrades to
the database.

David J.

--000000000000b09530062631f7b5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Nov 5, 2024 at 2:45=E2=80=AFPM Matt Zagrabelny &lt=
;<a href=3D"mailto:mzagrabe@d.umn.edu">mzagrabe@d.umn.edu</a>&gt; wrote:</s=
pan></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex"><div dir=3D"ltr"><div>ERROR: =C2=A0column d.adsrc does no=
t exist at character 331</div><div><br></div><div>Some searching online yie=
lds that adsrc was removed in Pg 12.</div><div><br></div><div>Is there a wa=
y to recreate it?</div><div><br></div></div></blockquote><div><br></div><di=
v class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">=
That is a base catalog table.=C2=A0 Its removal means the data it stored is=
 no longer being stored.=C2=A0 Even if you somehow got the column reference=
 error=C2=A0to go away whatever the application is doing with that is going=
 to be surprised to be handed an empty string.</div><div class=3D"gmail_def=
ault" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">You cou=
ld always checkout the=C2=A0source for v15, un-revert the commit removing t=
hat field, compile, and see what happens.=C2=A0 But if you want to use a co=
mmunity build the application needs to be changed=C2=A0along with upgrades =
to the database.</div><div class=3D"gmail_default" style=3D"font-family:ari=
al,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"fo=
nt-family:arial,helvetica,sans-serif">David J.</div><div class=3D"gmail_def=
ault" style=3D"font-family:arial,helvetica,sans-serif"><br></div></div></di=
v>

--000000000000b09530062631f7b5--