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
<kkprog...@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!
--
Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist
Mobile:
+91 8424039903
https://www.linkedin.com/in/krishnakant-r-mane/
