public inbox for [email protected]
help / color / mirror / Atom feedRe: create_immv issue on aws Ubuntu even after create extention
11+ messages / 3 participants
[nested] [flat]
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 01:53 Adrian Klaver <[email protected]>
0 siblings, 1 reply; 11+ messages in thread
From: Adrian Klaver @ 2025-03-02 01:53 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 3/1/25 17:39, Krishnakant Mane wrote:
>
>>> 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.
See above and provide answers.
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 02:14 Krishnakant Mane <[email protected]>
parent: Adrian Klaver <[email protected]>
0 siblings, 2 replies; 11+ messages in thread
From: Krishnakant Mane @ 2025-03-02 02:14 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 3/2/25 07:23, Adrian Klaver wrote:
> On 3/1/25 17:39, Krishnakant Mane wrote:
>>
>
>>>> 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.
>>>
pg_ivm | 1.10 | pg_catalog
plpgsql | 1.0 | pg_catalog.
>>> 2) show search_path;
>>> "$user" public.
>>> 3) \df *.create_immv
>>> pgivm | create_immv | bigint | text, text | func.
>>> Provide the outputs from the above three commands in your response.
>
> See above and provide answers.
>
--
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] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 02:21 Adrian Klaver <[email protected]>
parent: Krishnakant Mane <[email protected]>
1 sibling, 0 replies; 11+ messages in thread
From: Adrian Klaver @ 2025-03-02 02:21 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 3/1/25 18:14, Krishnakant Mane wrote:
>
> On 3/2/25 07:23, Adrian Klaver wrote:
>> On 3/1/25 17:39, Krishnakant Mane wrote:
>>>
>>
>>>>> 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.
>>>>
> pg_ivm | 1.10 | pg_catalog
>
> plpgsql | 1.0 | pg_catalog.
>
>
>>>> 2) show search_path;
>>>> "$user" public.
>>>> 3) \df *.create_immv
>>>> pgivm | create_immv | bigint | text, text | func.
>>>> Provide the outputs from the above three commands in your response.
>>
>> See above and provide answers.
So the extension functions are in the pgivm schema.
You will need to either always schema qualify the functions:
select pgivm.create_imv();
or add the pgivm schema to the search_path.
For how to do that see the link I provided earlier in this thread:
https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH
Using the info from above you will probably want to persist the
search_path setting in postgresql.conf as:
https://www.postgresql.org/docs/current/runtime-config-client.html
as
search_path
>>
> --
> 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] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 02:24 David G. Johnston <[email protected]>
parent: Krishnakant Mane <[email protected]>
1 sibling, 2 replies; 11+ messages in thread
From: David G. Johnston @ 2025-03-02 02:24 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; +Cc: Adrian Klaver <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On Saturday, March 1, 2025, Krishnakant Mane <[email protected]> wrote:
>
> pg_ivm | 1.10 | pg_catalog
>
> plpgsql | 1.0 | pg_catalog.
>
>
> 2) show search_path;
> "$user" public.
> 3) \df *.create_immv
> pgivm | create_immv | bigint | text, text | func.
> Provide the outputs from the above three commands in your response.
>
> See this issue for why this is different now.
https://github.com/sraoss/pg_ivm/pull/116
Then deal with the fact it is no longer installed to pg_control but instead
pgivm. With usual schema qualifications or search_path techniques.
David J.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 02:36 Krishnakant Mane <[email protected]>
parent: David G. Johnston <[email protected]>
1 sibling, 1 reply; 11+ messages in thread
From: Krishnakant Mane @ 2025-03-02 02:36 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; +Cc: Adrian Klaver <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 3/2/25 07:54, David G. Johnston wrote:
> On Saturday, March 1, 2025, Krishnakant Mane <[email protected]> wrote:
>
>
> pg_ivm | 1.10 | pg_catalog
>
> plpgsql | 1.0 | pg_catalog.
>
>
>>>> 2) show search_path;
>>>> "$user" public.
>>>> 3) \df *.create_immv
>>>> pgivm | create_immv | bigint | text, text | func.
>>>> Provide the outputs from the above three commands in your response.
>
> See this issue for why this is different now.
>
> https://github.com/sraoss/pg_ivm/pull/116
>
> Then deal with the fact it is no longer installed to pg_control but
> instead pgivm. With usual schema qualifications or search_path techniques.
> Thank you david.
Can you tell me how exactly should the syntax be?
Is my function definition wrong?
> David J.
>
--
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] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 02:39 Krishnakant Mane <[email protected]>
parent: David G. Johnston <[email protected]>
1 sibling, 1 reply; 11+ messages in thread
From: Krishnakant Mane @ 2025-03-02 02:39 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; +Cc: Adrian Klaver <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On 3/2/25 07:54, David G. Johnston wrote:
> On Saturday, March 1, 2025, Krishnakant Mane <[email protected]> wrote:
>
>
> pg_ivm | 1.10 | pg_catalog
>
> plpgsql | 1.0 | pg_catalog.
>
>
>>>> 2) show search_path;
>>>> "$user" public.
>>>> 3) \df *.create_immv
>>>> pgivm | create_immv | bigint | text, text | func.
>>>> Provide the outputs from the above three commands in your response.
>
> See this issue for why this is different now.
>
> https://github.com/sraoss/pg_ivm/pull/116
>
> Then deal with the fact it is no longer installed to pg_control but
> instead pgivm. With usual schema qualifications or search_path techniques.
>
Thank you, it worked. now pgivm.create_immv works.
I should have got it before.
> David J.
>
--
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] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 02:40 David G. Johnston <[email protected]>
parent: Krishnakant Mane <[email protected]>
0 siblings, 0 replies; 11+ messages in thread
From: David G. Johnston @ 2025-03-02 02:40 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; +Cc: Adrian Klaver <[email protected]>; Ron Johnson <[email protected]>; pgsql-general
On Saturday, March 1, 2025, Krishnakant Mane <[email protected]> wrote:
>
> Can you tell me how exactly should the syntax be?
>
https://www.postgresql.org/docs/current/ddl-schemas.html
> Is my function definition wrong?
>
It isn’t a function definition, it is a function call.
David J.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 03:14 Adrian Klaver <[email protected]>
parent: Krishnakant Mane <[email protected]>
0 siblings, 1 reply; 11+ messages in thread
From: Adrian Klaver @ 2025-03-02 03:14 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; David G. Johnston <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-general
>> Then deal with the fact it is no longer installed to pg_control but
>> instead pgivm. With usual schema qualifications or search_path techniques.
>>
> Thank you, it worked. now pgivm.create_immv works.
>
> I should have got it before.
Did you not read my previous post?
>
> --
> Email Signature
> *Krishnakant Mane*
> Software Architecture Design & Implementation Specialist
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 03:35 Krishnakant Mane <[email protected]>
parent: Adrian Klaver <[email protected]>
0 siblings, 1 reply; 11+ messages in thread
From: Krishnakant Mane @ 2025-03-02 03:35 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; David G. Johnston <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-general
On 3/2/25 08:44, Adrian Klaver wrote:
>
>>> Then deal with the fact it is no longer installed to pg_control but
>>> instead pgivm. With usual schema qualifications or search_path
>>> techniques.
>>>
>> Thank you, it worked. now pgivm.create_immv works.
>>
>> I should have got it before.
>
> Did you not read my previous post?
>
Actually I depend on a screen reader given my total blindness. Somehow
it is playing some tricks with thunderbird these days.
Some times when there are multiple nested blocks, I may miss the text.
But any ways thank you very much.
I had doubted it on similar lines, but could not pinpoint the issue.
Regards.
>>
>
>> --
>> Email Signature
>> *Krishnakant Mane*
>> Software Architecture Design & Implementation Specialist
>
>
--
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] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 04:23 Adrian Klaver <[email protected]>
parent: Krishnakant Mane <[email protected]>
0 siblings, 1 reply; 11+ messages in thread
From: Adrian Klaver @ 2025-03-02 04:23 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; David G. Johnston <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-general
On 3/1/25 19:35, Krishnakant Mane wrote:
For my future reference does something like this response work better?
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-02 06:35 Krishnakant Mane <[email protected]>
parent: Adrian Klaver <[email protected]>
0 siblings, 0 replies; 11+ messages in thread
From: Krishnakant Mane @ 2025-03-02 06:35 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; David G. Johnston <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-general
Yes perfect thank you.
Besides, I will soon switch over to Mac air m3 and voice over does not
have such problems.
This screen reader Orca is great as well and I am very sure, that it
being open source, will have the issue fixed at the earliest.
Regards.
On 3/2/25 09:53, Adrian Klaver wrote:
> On 3/1/25 19:35, Krishnakant Mane wrote:
>
>
> For my future reference does something like this response work better?
>
--
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] 11+ messages in thread
end of thread, other threads:[~2025-03-02 06:35 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-03-02 01:53 Re: create_immv issue on aws Ubuntu even after create extention Adrian Klaver <[email protected]>
2025-03-02 02:14 ` Krishnakant Mane <[email protected]>
2025-03-02 02:21 ` Adrian Klaver <[email protected]>
2025-03-02 02:24 ` David G. Johnston <[email protected]>
2025-03-02 02:36 ` Krishnakant Mane <[email protected]>
2025-03-02 02:40 ` David G. Johnston <[email protected]>
2025-03-02 02:39 ` Krishnakant Mane <[email protected]>
2025-03-02 03:14 ` Adrian Klaver <[email protected]>
2025-03-02 03:35 ` Krishnakant Mane <[email protected]>
2025-03-02 04:23 ` Adrian Klaver <[email protected]>
2025-03-02 06:35 ` 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