public inbox for [email protected]
help / color / mirror / Atom feedRe: create_immv issue on aws Ubuntu even after create extention
3+ messages / 2 participants
[nested] [flat]
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-02-28 17:01 Krishnakant Mane <[email protected]>
2025-02-28 17:23 ` Re: create_immv issue on aws Ubuntu even after create extention Ron Johnson <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Krishnakant Mane @ 2025-02-28 17:01 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; pgsql-general
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
2025-02-28 17:01 Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
@ 2025-02-28 17:23 ` Ron Johnson <[email protected]>
2025-02-28 17:26 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Ron Johnson @ 2025-02-28 17:23 UTC (permalink / raw)
To: pgsql-general
Differing search_path values can lead to problems like this.
On Fri, Feb 28, 2025 at 12:01 PM Krishnakant Mane <[email protected]>
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 <[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!
>
> --
> *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!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
2025-02-28 17:01 Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
2025-02-28 17:23 ` Re: create_immv issue on aws Ubuntu even after create extention Ron Johnson <[email protected]>
@ 2025-02-28 17:26 ` Krishnakant Mane <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Krishnakant Mane @ 2025-02-28 17:26 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; pgsql-general
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
> <[email protected]> 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
>> <[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!
> --
> *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/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-02-28 17:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-28 17:01 Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
2025-02-28 17:23 ` Ron Johnson <[email protected]>
2025-02-28 17:26 ` Krishnakant Mane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox