public inbox for [email protected]
help / color / mirror / Atom feedRe: create_immv issue on aws Ubuntu even after create extention
6+ messages / 3 participants
[nested] [flat]
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-02-28 18:40 Ron Johnson <[email protected]>
2025-03-01 05:29 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Ron Johnson @ 2025-02-28 18:40 UTC (permalink / raw)
To: pgsql-general
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 <[email protected]>
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 <[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!
>
> --
> *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] 6+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
2025-02-28 18:40 Re: create_immv issue on aws Ubuntu even after create extention Ron Johnson <[email protected]>
@ 2025-03-01 05:29 ` Krishnakant Mane <[email protected]>
2025-03-01 16:47 ` Re: create_immv issue on aws Ubuntu even after create extention Adrian Klaver <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Krishnakant Mane @ 2025-03-01 05:29 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; pgsql-general
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
> <[email protected]> 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
>> <[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!
> --
> *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] 6+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
2025-02-28 18:40 Re: create_immv issue on aws Ubuntu even after create extention Ron Johnson <[email protected]>
2025-03-01 05:29 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
@ 2025-03-01 16:47 ` Adrian Klaver <[email protected]>
2025-03-02 01:25 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Adrian Klaver @ 2025-03-01 16:47 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 2/28/25 21:29, Krishnakant Mane wrote:
> 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.
How did you install Postgres on the AWS EC2 instance?
Did you install the postgresql-server-dev-16 package?
>
> 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.
Define not work.
>
> Regards.
>
> On 3/1/25 00:10, Ron Johnson wrote:
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
2025-02-28 18:40 Re: create_immv issue on aws Ubuntu even after create extention Ron Johnson <[email protected]>
2025-03-01 05:29 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
2025-03-01 16:47 ` Re: create_immv issue on aws Ubuntu even after create extention Adrian Klaver <[email protected]>
@ 2025-03-02 01:25 ` Krishnakant Mane <[email protected]>
2025-03-02 01:33 ` Re: create_immv issue on aws Ubuntu even after create extention Adrian Klaver <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Krishnakant Mane @ 2025-03-02 01:25 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 3/1/25 22:17, Adrian Klaver wrote:
> On 2/28/25 21:29, Krishnakant Mane wrote:
>> 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.
>
> How did you install Postgres on the AWS EC2 instance?
>
> Did you install the postgresql-server-dev-16 package?
>
Yes I did.
>>
>> 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.
>
> Define not work.
>
create extension command works successfully.
But when I try creating the same immv on the server it says function
create_immv (unknown, unknown ) does not exist.
Note that this works on my local machine.
>>
>> Regards.
>>
>> On 3/1/25 00:10, Ron Johnson wrote:
>
--
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] 6+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
2025-02-28 18:40 Re: create_immv issue on aws Ubuntu even after create extention Ron Johnson <[email protected]>
2025-03-01 05:29 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
2025-03-01 16:47 ` Re: create_immv issue on aws Ubuntu even after create extention Adrian Klaver <[email protected]>
2025-03-02 01:25 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
@ 2025-03-02 01:33 ` Adrian Klaver <[email protected]>
2025-03-02 01:39 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Adrian Klaver @ 2025-03-02 01:33 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 3/1/25 17:25, Krishnakant Mane wrote:
>
> On 3/1/25 22:17, Adrian Klaver wrote:
>> On 2/28/25 21:29, Krishnakant Mane wrote:
>>> 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.
>>
>> How did you install Postgres on the AWS EC2 instance?
Please answer above.
>>
>> Did you install the postgresql-server-dev-16 package?
>>
> Yes I did.
>> Define not work.
>>
>
> create extension command works successfully.
>
> But when I try creating the same immv on the server it says function
> create_immv (unknown, unknown ) does not exist.
Connect with psql then do:
1) \dx
This will show what extensions are installed and in what schema.
2) show search_path;
3) \df *.create_immv
Provide the outputs from the above three commands in your response.
>
> Note that this works on my local machine.
>
>>>
>>> Regards.
>>>
>>> On 3/1/25 00:10, Ron Johnson wrote:
>>
> --
> Email Signature
> *Krishnakant Mane*
> Software Architecture Design & Implementation Specialist
>
>
> Mobile:
> +91 8424039903
>
> https://www.linkedin.com/in/krishnakant-r-mane/
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
2025-02-28 18:40 Re: create_immv issue on aws Ubuntu even after create extention Ron Johnson <[email protected]>
2025-03-01 05:29 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
2025-03-01 16:47 ` Re: create_immv issue on aws Ubuntu even after create extention Adrian Klaver <[email protected]>
2025-03-02 01:25 ` Re: create_immv issue on aws Ubuntu even after create extention Krishnakant Mane <[email protected]>
2025-03-02 01:33 ` Re: create_immv issue on aws Ubuntu even after create extention Adrian Klaver <[email protected]>
@ 2025-03-02 01:39 ` Krishnakant Mane <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Krishnakant Mane @ 2025-03-02 01:39 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 3/2/25 07:03, Adrian Klaver wrote:
> On 3/1/25 17:25, Krishnakant Mane wrote:
>>
>> On 3/1/25 22:17, Adrian Klaver wrote:
>>> On 2/28/25 21:29, Krishnakant Mane wrote:
>>>> 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.
>>>
>>> How did you install Postgres on the AWS EC2 instance?
>
> Please answer above.
> sudo apt-get install postgresql postgresql-server-dev-16
>>>
>>> Did you install the postgresql-server-dev-16 package?
>>>
>> Yes I did.
>
>>> Define not work.
>>>
>>
>> create extension command works successfully.
>>
>> But when I try creating the same immv on the server it says function
>> create_immv (unknown, unknown ) does not exist.
>
> Connect with psql then do:
>
> 1) \dx
> This will show what extensions are installed and in what schema.
>
> 2) show search_path;
>
> 3) \df *.create_immv
>
> Provide the outputs from the above three commands in your response.
>
>
>>
>> Note that this works on my local machine.
>>
>>>>
>>>> Regards.
>>>>
>>>> On 3/1/25 00:10, Ron Johnson wrote:
>>>
>> --
>> Email Signature
>> *Krishnakant Mane*
>> Software Architecture Design & Implementation Specialist
>>
>>
>> Mobile:
>> +91 8424039903
>>
>> https://www.linkedin.com/in/krishnakant-r-mane/
>>
>
--
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] 6+ messages in thread
end of thread, other threads:[~2025-03-02 01:39 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-28 18:40 Re: create_immv issue on aws Ubuntu even after create extention Ron Johnson <[email protected]>
2025-03-01 05:29 ` Krishnakant Mane <[email protected]>
2025-03-01 16:47 ` Adrian Klaver <[email protected]>
2025-03-02 01:25 ` Krishnakant Mane <[email protected]>
2025-03-02 01:33 ` Adrian Klaver <[email protected]>
2025-03-02 01:39 ` 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