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 1to45L-005Vtw-PB for pgsql-general@arkaria.postgresql.org; Fri, 28 Feb 2025 17:23:40 +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 1to45M-00BBhb-7o for pgsql-general@arkaria.postgresql.org; Fri, 28 Feb 2025 17:23:38 +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 1to45L-00BBhR-QJ for pgsql-general@lists.postgresql.org; Fri, 28 Feb 2025 17:23:38 +0000 Received: from mail-oa1-x31.google.com ([2001:4860:4864:20::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1to45G-000D7x-1p for pgsql-general@postgresql.org; Fri, 28 Feb 2025 17:23:38 +0000 Received: by mail-oa1-x31.google.com with SMTP id 586e51a60fabf-2bcbfad2f8cso1212318fac.1 for ; Fri, 28 Feb 2025 09:23:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740763414; x=1741368214; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=Trr/h4BvbpCdrHzsUYrIV0gkmZQ/xOQFx3gTqz3xsJ4=; b=KJKWLftNB3DaOmQGGJJwus21WGiiZYRCr6BXQeBVFBZGpd6bGclROy/b+ltr2iwKrU UK1Sny0mYJSkkD0wVtXy4SCPJX0ZHlwUV3TDxzbub+mYEfmh45Nphx75diOQiEaygE0O r1iaLYt1vkLgWh6wlvqu2u387emOFQMbpGDMpKVES98JclGfS6gaoNy0ZK8rIunvrIgp 7fSQlugpDjvlkoz3z+l2DXt/MZeLaG2P+I1MlQhaRsnA+SZmLRCZx7e1X3+hEulm4ZDh lQrufSHBDQggwndETh18AKwrO1kQdpm7ag6msfOpUP01qfqazdUAS5vmd8XKW+/p8UAx /h7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740763414; x=1741368214; h=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=Trr/h4BvbpCdrHzsUYrIV0gkmZQ/xOQFx3gTqz3xsJ4=; b=NaxZvbM0tAQPPltMZsaqS5t2tG8TBuTVNlPNfhnPv9/4ql0A4wAOHnH5LGrErsii7H aKMozrwePvPEJUhIEgNYrRbLud4unsSYCMWN4QKl0bzCEdnCgPa4vlljLxyvIkyGj0hP ht4Hv4pw+x/CyLMF4jCpnsUq7uZZnh7bWxAGPUcAXy4m4xrFGFAxzLzxvq1+EXVKhPkH hz7fHBkKoiKflavNgS7VW+FbVeMFECUQ7Ju0L+ZFzravTAo8DEvSaa+uB8bV+GLh6Tej MM+ENVo5juo20G5ibodD9VJZGmNIwLq60KRfZZlwshN8ejUlPIgnwGbCEvS6UXiz7WVH 4ZKw== X-Gm-Message-State: AOJu0YzCTDXAv3D2wxbrODhXFazzdSoioeBU38CGOTnCuPNfx52B0xr4 cNZ9rOA6aayD77815fv+TE0Eyo7QaLW85l91PoCrQ0ZboE1b8gXN1hJfukFXWWIZh+81SELh2jk 2e0R5K81FlvLCyGJDSMsqux6stthegg== X-Gm-Gg: ASbGnct0j0lUcr4S8sfjqhJoC3/dgTcM4+RcEzKuucvjiMvpdciVw/lMqcdDMjx30rj oYLFmaj610ZnRJUqbiB+CWA0A9VUs170fl8U7R4DsZqdBHvrOtCyJn3xR9PdU+54fim6HyvtpbX WvzJ8OZkeaPQYljQGNp6GPc2rd3xOOXrHzrzxCAK8xHw== X-Google-Smtp-Source: AGHT+IHh6JKiHP6EbORLErN3/ifKGbWpZagiV1GKQPH/XW21OzWXS0h602sTkNKeivSWYiCoYHRO+CW2+8uk3jKb3cU= X-Received: by 2002:a05:6870:de11:b0:29e:1325:760a with SMTP id 586e51a60fabf-2c1782be8cdmr2677825fac.8.1740763413815; Fri, 28 Feb 2025 09:23:33 -0800 (PST) MIME-Version: 1.0 References: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com> In-Reply-To: From: Ron Johnson Date: Fri, 28 Feb 2025 12:23:22 -0500 X-Gm-Features: AQ5f1Jr1BLF7U1ghFaoCyEK8W7HReNIoWJ4fcJbOluKqWeXSXVJkAIPyOaMYyWM Message-ID: Subject: Re: create_immv issue on aws Ubuntu even after create extention To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000eb298c062f37100f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000eb298c062f37100f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Differing search_path values can lead to problems like this. On Fri, Feb 28, 2025 at 12:01=E2=80=AFPM Krishnakant Mane wrote: > Ok here you go. > > select create_immv('plantskillpayment', 'select distinct kwapp_plant.id > as plantid, kwapp_skill.id as skillid, kwapp_skill.skillname, > kwapp_plant.plantname, kwapp_pltsklpaylvl.level, kwapp_pltsklpaylvl.pay > from kwapp_skill, kwapp_plant, kwapp_pltsklpaylvl where kwapp_skill.id > =3D kwapp_pltsklpaylvl.skillid_id and kwapp_plant.id =3D > kwapp_pltsklpaylvl.plantid_id'); > > > You see, the point is this works perfectly on all local machines with > exact same versions and same data. > > Regards. > On 2/28/25 22:24, Ron Johnson wrote: > > On Fri, Feb 28, 2025 at 11:41=E2=80=AFAM Krishnakant Mane > wrote: > >> Hello all. >> >> I am not able to use create_immv in postgresql 16.6 even after installin= g >> it and doing create extention. >> >> I did a git clone of the repository and then make sudo make install to >> install it. >> >> The issue is not happening on my local ubuntu 24.04 machine but on ubunt= u >> 24.04 on aws free tier. >> >> All dependencies are in place, that's why the extention got installed in >> the first place. >> >> I get the error "function create_immv(unknown, unknown) does not exist. >> >> all the tables related to this view exist, data is present and same setu= p >> works perfectly on my local machine, same OS and postgresql version. >> >> Can someone suggest what could be the solution? >> > Show your work! > > What command did you run to get that error? > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! > > -- > *Krishnakant Mane* > Software Architecture Design & Implementation Specialist > > Mobile: > +91 8424039903 > https://www.linkedin.com/in/krishnakant-r-mane/ > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000eb298c062f37100f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Differing search_path valu= es can lead to problems like this.

On Fri, Feb 28, 2025 at 12:01=E2=80=AFPM Krishnakant Mane <kkproghub@gmail.com> wrote:
=
=20 =20 =20

Ok here you go.

select create_immv('plantskillpayment', 'select distinct kwapp_plant.id as plantid, kwapp_ski= ll.id as skillid, kwapp_skill.skillname, kwapp_plant.plantname, kwapp_pltsklpaylvl.level, kwapp_pltsklpaylvl.pay from kwapp_skill, kwapp_plant,=C2=A0 kwapp_pltsklpaylvl=C2=A0 where kwapp_skill.id=C2=A0 =3D kwapp_pltsklpaylvl.skillid_id=C2=A0 and kwapp_plant.id =3D kwapp_pltsklpaylvl.plantid_id');


You see, the point is this works perfectly on all local machines with exact same versions and same data.

Regards.

On 2/28/25 22:24, Ron Johnson wrote:
=20
On Fri, Feb 28, 2025 at 11:41=E2=80=AFAM Krishnaka= nt Mane <kkpr= oghub@gmail.com> wrote:

Hello all.

I am not able to use create_immv in postgresql 16.6 even after installing it and doing create extention.

I did a git clone of the repository and then make sudo make install to install it.

The issue is not happening on my local ubuntu 24.04 machine but on ubuntu 24.04 on aws free tier.

All dependencies are in place, that's why the extentio= n got installed in the first place.

I get the error "function create_immv(unknown, unknow= n) does not exist.

all the tables related to this view exist, data is present and same setup works perfectly on my local machine, same OS and postgresql version.

Can someone suggest what could be the solution?

Show your work!

What command did you run to get that error?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
--
=20 =20
Krishnakant Mane
Software Architecture Design & Implementation Specialist

Mobile:
+91 8424039903
https://www.linkedin.com/in/krishnakant-r-mane/


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--000000000000eb298c062f37100f--