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 1toFPk-008El1-Rx for pgsql-general@arkaria.postgresql.org; Sat, 01 Mar 2025 05:29:30 +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 1toFPl-0051TC-Uz for pgsql-general@arkaria.postgresql.org; Sat, 01 Mar 2025 05:29:28 +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 1toFPl-0051PA-Gl for pgsql-general@lists.postgresql.org; Sat, 01 Mar 2025 05:29:28 +0000 Received: from mail-pl1-x633.google.com ([2607:f8b0:4864:20::633]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1toFPg-000Iok-11 for pgsql-general@postgresql.org; Sat, 01 Mar 2025 05:29:27 +0000 Received: by mail-pl1-x633.google.com with SMTP id d9443c01a7336-222e8d07dc6so52185845ad.1 for ; Fri, 28 Feb 2025 21:29:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740806963; x=1741411763; darn=postgresql.org; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=puwCqtF5lGWfRjUKG7ln2bvKVZkO77PG0oO/YwzLAuc=; b=ADLnOSQS4qQJJSsBE6UgkfnpBfEOC+qHECJw+TfBfR/x3/2iTwbQIJjsa5oEyvMSOz 8ObBDWMB9DOz6XpIbDj3mGtvmFWgKgIvD/nA1kIVhiHfCtabHYIcLV8CTKakvhTrCaJI GHWXaE+c4N2axtLuggGq14xOVOfXwVkOXtu5qqHCoS26biXSbNAUNa2/7LZKUEF0DjtP 1qZIDX8SifRSNeaff9/gAHcz46iz0iFyby7cgYzLLDI+aI//zA5bw/8EutwgilrkildW SlJ9Zl4adVfpsb+npQ9OgGHiw1Gx5gNrbZNLlESfsxtouK1tWihGNY6+x0yJYX1QvuUx FpZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740806963; x=1741411763; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=puwCqtF5lGWfRjUKG7ln2bvKVZkO77PG0oO/YwzLAuc=; b=uZ28YrO2LmfNdgSadXY7aed/hoA0dKFMrpELRGBuIo3wtW9IHIN2O+BdEvl31DPmx0 s6pUOn4dtHFcSBhGJH7gDP3q9NYc8fqIq/TWj9bofEWMveazUGt2csiZbZN23dCh0JAL rPgiBSqtot+uqBcgqxZY2S6ZtN/guowUjxPlLUsIz3moUdeLo8uIbtODQ9gULJ+EEywB TUCr8Ael5m49zJvJRpOF7kx0lVt3InkrcmUrKYSKJRgJtxBZoqUsFpqZWpuSBtko/8Os /osBaC35FB9yT/uZ8T+NK6DU2DshZ3Jra2HNOMoTI7PRdnsCTpboeip44+ALCHGhDC3A jmow== X-Forwarded-Encrypted: i=1; AJvYcCVhHoe1TO1nD6ulilf8dj6WD5KwvXiHMWS565VbxfpoYo+6j06PxN7JDjlHmctMtpHzls0QJw9ungIzMIpb@postgresql.org X-Gm-Message-State: AOJu0YxWEuViRv6TEvUTN/Rz6MNEFdqTmBSukAXvx9Xgoz1t9oUpmI84 LdK8XoijarhQIButVz1hms/1fOD7V3D39sCqdS42ZdpygH+6eKYtbgY+XQ== X-Gm-Gg: ASbGncsjP3D/4mce8Ftm1sIFK/8EtnbIgO2IZJuAW/2CEJ+EPD9DnKjR1SlHdRuu61c k+xjIwBcITcqikSwY656YD12hALF33ciaQ7aFuih2+J+PXe7D2F74XeV64UmYTh4stm03oYo556 fHiTrYcSYQ6QK0vIeApuLgyG1LEjYlgYMYVKuqNzzCtI95C4oQ2wINL9hXruafxvlpfLpr9U5WV /UvY6c5niIyrMjbFpzPr+Xja1T+pAYIJ/CvobSdTEA0U2WxA7c7aGvZRG/RsGr06UcdUnVEp6Qf Pwcv/I1dyEGaV1M2W9W+RXyuB9BfDLUGddCBrO7h0vMJcssCBDMWEL1sOPumL4dGsfEScgCDCXz vNMmvFDwBvk3aX0fl X-Google-Smtp-Source: AGHT+IEfK4Hhk4GHvIU3Q+9R3fdDb/6/4M+EGdWXwWGfBWnxr6+BTVC00jU06nUaYboSnSl2KMAeLQ== X-Received: by 2002:a17:902:c951:b0:215:a56f:1e50 with SMTP id d9443c01a7336-22367434616mr107592845ad.8.1740806963254; Fri, 28 Feb 2025 21:29:23 -0800 (PST) Received: from ?IPV6:2402:e280:3e2e:391:de08:b7a3:f7d7:1ae7? ([2402:e280:3e2e:391:de08:b7a3:f7d7:1ae7]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-223504c5979sm42103255ad.151.2025.02.28.21.29.21 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 28 Feb 2025 21:29:22 -0800 (PST) Content-Type: multipart/alternative; boundary="------------YWSaoeDCP0vPp1pU44yZ0lMq" Message-ID: Date: Sat, 1 Mar 2025 10:59:20 +0530 MIME-Version: 1.0 User-Agent: Betterbird (Linux) Subject: Re: create_immv issue on aws Ubuntu even after create extention To: Ron Johnson , pgsql-general References: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com> Content-Language: en-US From: Krishnakant Mane In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------YWSaoeDCP0vPp1pU44yZ0lMq Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit All done, but no result. I feel it is possible that the latest code must be flawed or something. Well, as a matter of fact, I never had to compile the extention on my local ubuntu 24.04 machine. I just did a create extention and it worked just fine. But on my aws server I had to compile it manually and still it does not work. Regards. On 3/1/25 00:10, Ron Johnson wrote: > 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 PM 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 PM 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   = >> kwapp_pltsklpaylvl.skillid_id  and kwapp_plant.id >> = 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 AM 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 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 , 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/ > > > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! -- Email Signature *Krishnakant Mane* Software Architecture Design & Implementation Specialist Mobile: +91 8424039903 https://www.linkedin.com/in/krishnakant-r-mane/ --------------YWSaoeDCP0vPp1pU44yZ0lMq Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

All done, but no result.

I feel it is possible that the latest code must be flawed or something.

Well, as a matter of fact, I never had to compile the extention on my local ubuntu 24.04 machine.

I just did a create extention and it worked just fine.

But on my aws server I had to compile it manually and still it does not work.

Regards.

On 3/1/25 00:10, Ron Johnson wrote:
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 PM Krishnakant Mane <kkproghub@gmail.com> 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 PM Krishnakant Mane <kkproghub@gmail.com> 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  = kwapp_pltsklpaylvl.skillid_id  and kwapp_plant.id = 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 AM 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 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 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/


--
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/


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

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