Re: create_immv issue on aws Ubuntu even after create extention

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Krishnakant Mane <kkproghub(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: create_immv issue on aws Ubuntu even after create extention
Date: 2025-02-28 20:09:35
Message-ID: 078a3947-c88b-413b-86c2-6e25a0459df1@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/28/25 09:26, Krishnakant Mane wrote:
>
> On 2/28/25 22:53, Ron Johnson wrote:
>>
>> Differing search_path values can lead to problems like this.
>>
> So what can I do to resolve this?

In psql do:

\dx

That will show you what extensions are installed and in what schema.

Then read this:

https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH

It explains search_path and how to modify it.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Krishnakant Mane 2025-03-01 05:25:33 Re: create_immv issue on aws Ubuntu even after create extention
Previous Message Ron Johnson 2025-02-28 18:40:36 Re: create_immv issue on aws Ubuntu even after create extention