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
<kkprog...@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
<kkprog...@gmail.com> wrote:
Ok here you go.
select create_immv('plantskillpayment', 'select distinct
kwapp_plant.id <http://kwapp_plant.id> as plantid,
kwapp_skill.id <http://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 <http://kwapp_skill.id> =
kwapp_pltsklpaylvl.skillid_id and kwapp_plant.id
<http://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!
--
*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/
