Re: create_immv issue on aws Ubuntu even after create extention

On Saturday, March 1, 2025, Krishnakant Mane <kkproghub@gmail.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 david.

Can you tell me how exactly should the syntax be?

Is my function definition wrong?

David J.