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 1to5I2-005nr0-Tt for pgsql-general@arkaria.postgresql.org; Fri, 28 Feb 2025 18:40:52 +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 1to5I3-00CuCE-WE for pgsql-general@arkaria.postgresql.org; Fri, 28 Feb 2025 18:40:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1to5I3-00CuC5-D8 for pgsql-general@lists.postgresql.org; Fri, 28 Feb 2025 18:40:50 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1to5I0-000DTX-06 for pgsql-general@postgresql.org; Fri, 28 Feb 2025 18:40:49 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-5fcef5dc742so604389eaf.1 for ; Fri, 28 Feb 2025 10:40:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740768047; x=1741372847; 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=4AcMaTEvlGfIV2fTh6DNZNy37H8ca/ZX5tsaiOHBSI0=; b=l2UvcBgT7YxWfJln8VqdinmAN1Dp4atH+1Awi6Zpl7yrI8RB1G4negpb5+kOxCn5om +hBzW9IOSGSUua6iZ8+OwiqhwJyy4dFt/UQldkQiEWXXATzfneVl7+aG9hw+CKA92fBP UW2Yh7ZLjeJLW2XDMYPz2dfLx4ZOiaA8rgEKb63pFmCRMJARzE7CrdwUh/hiDBRbT1g5 SVld4kpqPqSKV9X6N8Q1NCRBw2SNvnmqHgA20QynCycKc7Ux92efxICFQKKnYzuV0ctg cMzSG6eBV0E0m4GvyZZ1ymFxTWoeDxSt7/bQoonAnuegf1gHC/OGimpYn8VoaSC2Qu9O AggA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740768047; x=1741372847; 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=4AcMaTEvlGfIV2fTh6DNZNy37H8ca/ZX5tsaiOHBSI0=; b=ha5inKrGgF30CdRDwCIFJmN+zJSS4kB+dTL07qDWve9NXexIKstlwP+iBj0KivvU8x HxpRffisfF6qFQN33e+LB/LPoQAWE45CTvpa94W/Gi+N6XVF3Wr2fqLhpvRtwM/FFwID H9VSMQ9qLvSrCVFz169mnGkQcYYDBXtUe5uNxWGX6IMJhbAZZtgvUEOl7wLoUV9yScG8 Yq02vqNPE7XK7QqtzjJE964SrtMKminStNMlE6UwTkYmLDeipD2iCLi9Oq9/1BHISYl3 0Oj/TR+xtnTjNcTohXS8sPWUo9Ih/Sg5eof9J1Wq2MGEdMfJZWQT41HBlv+8GM7IfmGK sRvA== X-Gm-Message-State: AOJu0YzJzQKeLMu+fWwg00Hahzg8Ly0n+/BBUkNt7TtKkAx9iD8Qh3VO Orrd31DvxsMfD6byQrR0hKON9Ery/d1S6nvGRUqBCCzPq4dtOmfPTVwyziYKBQ6NwHEs4Bav60l gNRgKxOdgSpE2Ve6tMk+oFUd4+LgLXJH+ X-Gm-Gg: ASbGncvGCB+6JzEpZiqW4t5+chdkJRiglZ/q/OROe1ynXgzEmS3FjPc9bRUMCNRKFt2 C6YEznP/Ezbf8UIlk3fJbduFNp6teJJ3n8d1OTLVIwDEIi2CqAeaW9dQ1IhEKMfLcGov3kuwvr8 ifnxAfnTjkUlYLg4LtDiazanjQ4+jVtKyGfC+3EjAIZw== X-Google-Smtp-Source: AGHT+IGYnKpfmd0ZiI8byLT7jkd3CqvbOz58h9PDW0jIJDROyu3GbxyGUignfLEONq9/YL2L0+nfr8mEclbSzExyamM= X-Received: by 2002:a05:6870:a114:b0:29e:5de2:cffb with SMTP id 586e51a60fabf-2c1784388c6mr2929451fac.17.1740768047063; Fri, 28 Feb 2025 10:40:47 -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 13:40:36 -0500 X-Gm-Features: AQ5f1JrspHV7RnsSMeTcAPCsSjfZAa6hw0ViqqaJswJ-4Z1aqwsKwEnJ5mDPdiU Message-ID: Subject: Re: create_immv issue on aws Ubuntu even after create extention To: pgsql-general Content-Type: multipart/alternative; boundary="00000000000014eb1b062f382575" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000014eb1b062f382575 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable When you know that the SELECT statement runs on the local machines, then on each server, run these SQL statements: SHOW search_path; SELECT * FROM pg_extension; On Fri, Feb 28, 2025 at 12:26=E2=80=AFPM Krishnakant Mane wrote: > > On 2/28/25 22:53, Ron Johnson wrote: > > > Differing search_path values can lead to problems like this. > > So what can I do to resolve 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 >>> 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 extention got installed i= n >>> 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 >>> setup works perfectly on my local machine, same OS and postgresql versi= on. >>> >>> 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/ >> > > > -- > 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! --00000000000014eb1b062f382575 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
When you know that the SELECT statement runs on the local = machines, then on each server, run these SQL statements:

SHOW search_path;
SELECT * FROM=
 pg_extension;

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


On 2/28/25 22:53, Ron Johnson wrote:
=20

Differing search_path values can lead to problems like this.

So what can I do to resolve this?
On Fri, Feb 28, 2025 at 12:01=E2=80=AFPM Krishnaka= nt Mane <kkpr= oghub@gmail.com> wrote:

Ok here you go.

select create_immv('plantskillpayment', 'selec= t 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,=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:
On Fri, Feb 28, 2025 at 11:41=E2=80=AFAM Krishnakant Mane <kkproghub@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 th= e 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 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!
--
Krishnakant Mane
Software Architecture Design & Implementation Specialist

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


--
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!
--00000000000014eb1b062f382575--