create_immv issue on aws Ubuntu even after create extention - Mailing list pgsql-general

From Krishnakant Mane
Subject create_immv issue on aws Ubuntu even after create extention
Date
Msg-id 9a1af622-980b-4d81-b997-085dea2f2972@gmail.com
Whole thread Raw
Responses Re: create_immv issue on aws Ubuntu even after create extention
List pgsql-general

Hello all.

I am not able to use create_immv in postgresql 16.6 even after installing it and doing create extention.

I did a git clone of the repository and then make sudo make install to install it.

The issue is not happening on my local ubuntu 24.04 machine but on ubuntu 24.04 on aws free tier.

All dependencies are in place, that's why the extention got installed in the first place.

I get the error "function create_immv(unknown, unknown) does not exist.

all the tables related to this view exist, data is present and same setup works perfectly on my local machine, same OS and postgresql version.

Can someone suggest what could be the solution?

Regards.



Krishnakant Mane
Software Architecture Design & Implementation Specialist

Mobile:
+91 8424039903
https://www.linkedin.com/in/krishnakant-r-mane/

pgsql-general by date:

Previous
From: Alicja Kucharczyk
Date:
Subject: Re: Azure Database for PostgreSQL flexible server: password authentication failed
Next
From: Ron Johnson
Date:
Subject: Re: create_immv issue on aws Ubuntu even after create extention