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
>> 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!
>>
>> --
>> *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!
