Re: create_immv issue on aws Ubuntu even after create extention

On 3/2/25 07:54, David G. Johnston wrote:
> On Saturday, March 1, 2025, Krishnakant Mane <kkproghub(at)gmail(dot)com> 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/