create_immv issue on aws Ubuntu even after create extention

From: Krishnakant Mane <kkproghub(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: create_immv issue on aws Ubuntu even after create extention
Date: 2025-02-28 16:41:41
Message-ID: 9a1af622-980b-4d81-b997-085dea2f2972@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist

Mobile:
+91 8424039903

https://www.linkedin.com/in/krishnakant-r-mane/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-02-28 16:54:48 Re: create_immv issue on aws Ubuntu even after create extention
Previous Message Alicja Kucharczyk 2025-02-28 15:16:38 Re: Azure Database for PostgreSQL flexible server: password authentication failed