public inbox for [email protected]
help / color / mirror / Atom feedFrom: Krishnakant Mane <[email protected]>
To: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: create_immv issue on aws Ubuntu even after create extention
Date: Fri, 28 Feb 2025 22:31:53 +0530
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaBguoe+RY04g9t8PLGyVBkEmnfvmkJ=k0mqOvtyE4jopA@mail.gmail.com>
References: <[email protected]>
<CANzqJaBguoe+RY04g9t8PLGyVBkEmnfvmkJ=k0mqOvtyE4jopA@mail.gmail.com>
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
> <[email protected]> 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!
--
Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist
Mobile:
+91 8424039903
https://www.linkedin.com/in/krishnakant-r-mane/
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: create_immv issue on aws Ubuntu even after create extention
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox