Re: create_immv issue on aws Ubuntu even after create extention

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.