public inbox for [email protected]  

help / color / mirror / Atom feed

adsrc
2+ messages / 2 participants
[nested] [flat]

* adsrc
@ 2024-11-05 21:45  Matt Zagrabelny <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Matt Zagrabelny @ 2024-11-05 21:45 UTC (permalink / raw)
  To: pgsql-generallists.postgresql.org <[email protected]>

Greetings Pg folk,

I've got a legacy app connecting to a legacy Pg database (9.4).

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

Some searching online yields that adsrc was removed in Pg 12.

Is there a way to recreate it?

Thanks for any help or answers.

Cheers,

-m


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: adsrc
@ 2024-11-05 22:31  David G. Johnston <[email protected]>
  parent: Matt Zagrabelny <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: David G. Johnston @ 2024-11-05 22:31 UTC (permalink / raw)
  To: Matt Zagrabelny <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]>

On Tue, Nov 5, 2024 at 2:45 PM Matt Zagrabelny <[email protected]> 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.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-11-05 22:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-05 21:45 adsrc Matt Zagrabelny <[email protected]>
2024-11-05 22:31 ` David G. Johnston <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox