Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8SL0-004IVB-9h for pgsql-general@arkaria.postgresql.org; Tue, 05 Nov 2024 22:47:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t8SKw-001Be1-Ju for pgsql-general@arkaria.postgresql.org; Tue, 05 Nov 2024 22:47:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8SKv-001Bds-16 for pgsql-general@lists.postgresql.org; Tue, 05 Nov 2024 22:47:46 +0000 Received: from mta-p5.oit.umn.edu ([134.84.196.205]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8SKm-000P4Y-8V for pgsql-general@postgresql.org; Tue, 05 Nov 2024 22:47:44 +0000 Received: from localhost (unknown [127.0.0.1]) by mta-p5.oit.umn.edu (Postfix) with ESMTP id 4Xjk4M1VRVzB18rr for ; Tue, 5 Nov 2024 22:47:31 +0000 (UTC) X-Virus-Scanned: amavisd-new at umn.edu Received: from mta-p5.oit.umn.edu ([127.0.0.1]) by localhost (mta-p5.oit.umn.edu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id TOcdTW4EL06t for ; Tue, 5 Nov 2024 16:47:31 -0600 (CST) Received: from mail-ej1-f69.google.com (mail-ej1-f69.google.com [209.85.218.69]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by mta-p5.oit.umn.edu (Postfix) with ESMTPS id 4Xjk4L5JXSzB18rn for ; Tue, 5 Nov 2024 16:47:30 -0600 (CST) DMARC-Filter: OpenDMARC Filter v1.3.2 mta-p5.oit.umn.edu 4Xjk4L5JXSzB18rn DKIM-Filter: OpenDKIM Filter v2.11.0 mta-p5.oit.umn.edu 4Xjk4L5JXSzB18rn Received: by mail-ej1-f69.google.com with SMTP id a640c23a62f3a-a99fe72d85bso66606066b.3 for ; Tue, 05 Nov 2024 14:47:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=d.umn.edu; s=google; t=1730846849; x=1731451649; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=vRZgcoiSzlsF12KGanYwI5sj61sgJoWTy9NXrgTvOsA=; b=D9Bf6kU0Z6OEC1X0PAixNvnmSD2/Zvygr4Ke2c4VqKlAf6ozHpkVFR24Tce9P/liBt j2TfOZyJEqDgfvu938TVFsYaZ2Ti434AiF4W7A7leAKg+W9Pb4g5l8U46PWiHEaB+XVx LiRU/g79fA4umjRZZiudoOXoLOXovq+DZw8B6JpW5biYTd0bqweBfoMeIZpZAtKvhcqV RvF6ES058Zgw+QxLCLgv0/tX3E/V03Q4OuJOxIaPHqBn4hNN2hKCUzRm3Kfu8GzHQZT0 NPNh/iGklCftM02U7RqtZkyt0uFJLAOq1wBUUCkmDIj5sQraxUODioSZ8+h6qPSppxUB QagQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730846849; x=1731451649; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=vRZgcoiSzlsF12KGanYwI5sj61sgJoWTy9NXrgTvOsA=; b=Fp2/Fn6MIMcMmv6Z4AWnejc5XRbn36z8EoKCIXJ12vwLTu0MFtinwi0Y9VxIcs9Cn2 XIJsBTPVAppT2AyJaZkNN09a0693AoBihj9EfyD7l7VqKxNXb3awWnyTrGKi+i62dmVl Jqv9tdri96xR1yB23XJ2ulYY0eFOo5eRB6fmNUvx3HmjUph2InxzRbwWS38A1CutBFhS 6jXok3JguTHC0yttyL8rwsAy7KMKxmh4QO3LOEipkg8ouzxu+iJZM9JNoPA20Gs4NkEC 0DAULSkSuicD10sEi5u0q6Lo1YqGX9YagIPYjyC7zPSNxcq+jDIfELAIuNX57Vj8ktqk wfJg== X-Gm-Message-State: AOJu0Yw42WK+IBuAfJQqYTXUltZ5V0wnkCY6aSzVmCRVr8uOTu427rtv 6Wa0EuH4p/DnRzo5E8xHbpOBHtI3lrzq3QJ4cstf1/IO3vXfAJn9+YMYsVdmDTZ7C3GSYvc27UW QHyOjRTQ+GmBTgLMPkkDlQb+VivcD5X72Y2xV9l4iHgN+4qbMviUBL8T/po94QPfbQ5C4h+NgdE SIgz+oR45epDbjj3f1EmramdjMTXW8B7ILfH5P8r4= X-Received: by 2002:a17:907:6e8d:b0:a9a:2a56:b54 with SMTP id a640c23a62f3a-a9de5f279d1mr1573977166b.5.1730846849007; Tue, 05 Nov 2024 14:47:29 -0800 (PST) X-Google-Smtp-Source: AGHT+IHT6qgb6TvFKQxEwR8LGEXQYYmk8i7D6NqhZK53Ij+Z9arcg6a6HqC8Lra1reJr3LV6V5D9HalV3Pii5IdCzR4= X-Received: by 2002:a17:907:6e8d:b0:a9a:2a56:b54 with SMTP id a640c23a62f3a-a9de5f279d1mr1573976566b.5.1730846848655; Tue, 05 Nov 2024 14:47:28 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Matt Zagrabelny Date: Tue, 5 Nov 2024 16:47:17 -0600 Message-ID: Subject: Re: adsrc To: Ron Johnson Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000933f1e0626322fd0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000933f1e0626322fd0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Nov 5, 2024 at 4:44=E2=80=AFPM Ron Johnson wrote: > On Tue, Nov 5, 2024 at 4:45=E2=80=AFPM Matt Zagrabelny wrote: > >> 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 perfor= m >> 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. >> > > 1. What is the application? > Netdot - an IPAM from the 2000's. > > 2. An upgraded version of the application (or at least the db driver) > probably won't reference it. > Yes. Looks like the DBD::Pg module is what needs the upgrade. -m --000000000000933f1e0626322fd0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Tue, Nov 5, 2024 at 4:44=E2=80=AFP= M Ron Johnson <ronljohnsonjr@= gmail.com> wrote:
On Tue, Nov 5, 2024 at 4:45=E2= =80=AFPM Matt Zagrabelny <mzagrabe@d.umn.edu> wrote:
<= div>Greetings Pg folk,

I've got a legacy app c= onnecting to a legacy Pg database (9.4).

I'd l= ike to upgrade the database to Pg 15, but when I connect and perform some t= asks in the app, I get:

ERROR: =C2=A0column d.adsr= c does not exist at character 331

Some searching o= nline yields that adsrc was removed in Pg 12.
=
1. What is the application?

Netdot - an IPAM from the 2000's.
=C2= =A0

2. An upgraded version of t= he application (or at least the db driver) probably won't reference it.=

Yes. Looks like the DBD:= :Pg module is what needs the upgrade.

-m
--000000000000933f1e0626322fd0--