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 1to48e-005WfM-3F for pgsql-general@arkaria.postgresql.org; Fri, 28 Feb 2025 17:27:05 +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 1to48e-00BJeY-BE for pgsql-general@arkaria.postgresql.org; Fri, 28 Feb 2025 17:27:02 +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 1to48d-00BJdg-QL for pgsql-general@lists.postgresql.org; Fri, 28 Feb 2025 17:27:02 +0000 Received: from mail-pl1-x630.google.com ([2607:f8b0:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1to48Y-000D9W-1d for pgsql-general@postgresql.org; Fri, 28 Feb 2025 17:27:02 +0000 Received: by mail-pl1-x630.google.com with SMTP id d9443c01a7336-2210d92292eso10678595ad.1 for ; Fri, 28 Feb 2025 09:26:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740763618; x=1741368418; 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=t5woc7i+dSDCqjh2Ayk6e2CQb0cUli+HRHJcQcyRZEg=; b=QYT3lU/9X0gvTUoI2iarGm/fgaW+DwCy+LgI5dsB7Hk3TYQj6rxdWQQmcFdIJDZ0+9 +Krm9XlJ5TebQO9HAV0X2rAmMEDhP30hJy1tgIvfwLGBoIYoGnGzry0ZBHzxlDOS4WWC zTR05Pr2C1svFRtjMbI7Pd7m+a1MXQP2TWTAzwEChKs+ImD/6t/QId63eLq9T3vXQOu3 n+ePEtGffTtz02TG+Qvbi7U4RTnHPGLhAoSixD5GvVZUGho46PBZ40E7G/z7aApOjuHk L6FY+fvKQDHV5N7g6wgCuXb/ZNxObZcQTNjg+OF3zR16+WyS0/XSiZ/tEZErjurlXklD Mitw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740763618; x=1741368418; 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=t5woc7i+dSDCqjh2Ayk6e2CQb0cUli+HRHJcQcyRZEg=; b=Cix2ssj6FeEkbCaNQwlYcFoOq2k1XYZe21miMKdHT54HPwqv+qNblXb1pYHy6Ms8Pz l226JCUD8tmW8CQT+r6GaUznVy0xTKjx4A5+Sgwtx1ZqM64LID1slKD5YYmVznsupkXK /P59MtG1WdtCj9Ni+/091ezlK5W+J1EouhZrfIPdN4cDy/w+IVEmyi2STLPOzJqe0gS0 sCqtJqmgD9Zc45kmqQC53/s/JpE6YSzM29VCdAeTfaSF3XvNloU1b13tcjKSoGSEME0/ YRmhxGbustRADQX/liJAqPGOi113bCzIb4ZVecEXaiNaDpnH7yXxuEp7cfQgXn6fTu4Y tlYw== X-Forwarded-Encrypted: i=1; AJvYcCUtEF7b21adcEsMqz1p4xMrSKeOF6q6UC59uV5fLyBfMKXx4Le5lvQd3jAhfK0mWAuRwQg9CJP7dg0ZRzaC@postgresql.org X-Gm-Message-State: AOJu0YzpH+o3dpOiJ8ZYrSOi6v2r9Yg4BjkxjqjDL5xHwjDnpzI2pbhx Hb1PWR4SPcXJiMqCqFUOur5Q5hNMay0lNI0qYc8tY3m7BxeMnADSnfuAsw== X-Gm-Gg: ASbGncsSyMguLU1DgMevbIY/2D6u7SVDr9XEDh/pi1AJTOrMnSEH/aMwNnEcPNeTIy7 PXfo9ojyk/GFoBN2STl1WPXl1uUK6QFd27uH8IBrTCh1wmwLgXhwy3PMNdkbYoT9fBd+6IoxSi5 jvTltCnhqAgolNhIjOKzSBgg7q9l9pYqUTQr0nMVMw5otl0+a90eX8HAmcLCjC7O/ZpY5/EiJYN t/w5r7UNE1bLjIStXYaSzcSRju6aAsVypA3E4ZsGM9ktyMcl7spA4N4NUuRrrv4dP60M7VK6j8m npTfanUt7/izHvXOVLU4WF7fc9UYoL2UQE5ALTii0LosZe+v2/xYLh90mR89fHbMmXuS+64= X-Google-Smtp-Source: AGHT+IE/QA6N7bZdETTwB8YIBOtO+Ax3OcxDgwQR8IxwPWRgeLl5HetPeT9vtfkkrJYgWI2b5vsAeQ== X-Received: by 2002:a17:90b:3845:b0:2ee:c9b6:c267 with SMTP id 98e67ed59e1d1-2febab403a5mr7118428a91.9.1740763617655; Fri, 28 Feb 2025 09:26:57 -0800 (PST) Received: from ?IPV6:2402:e280:3e2e:391:61c8:4fe6:498:1881? ([2402:e280:3e2e:391:61c8:4fe6:498:1881]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2fea67530d0sm4065843a91.10.2025.02.28.09.26.55 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 28 Feb 2025 09:26:57 -0800 (PST) Content-Type: multipart/alternative; boundary="------------8PjAYy9WgkJDK9O8ebm2tXlg" Message-ID: Date: Fri, 28 Feb 2025 22:56:52 +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. --------------8PjAYy9WgkJDK9O8ebm2tXlg Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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! -- Email Signature *Krishnakant Mane* Software Architecture Design & Implementation Specialist Mobile: +91 8424039903 https://www.linkedin.com/in/krishnakant-r-mane/ --------------8PjAYy9WgkJDK9O8ebm2tXlg Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


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!
--
Email Signature
Krishnakant Mane
Software Architecture Design & Implementation Specialist

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