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.
--
