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
adrian.klaver@xxxxxxxxxxx
