Re: create_immv issue on aws Ubuntu even after create extention

From: Krishnakant Mane <kkproghub(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(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-03-01 05:25:33
Message-ID: 32b3f07f-2eb0-4980-9129-f4f7b062bfc2@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you.

Just a quick question.

should it be in pg_catalog?

if yes then it is so.

On 3/1/25 01:39, Adrian Klaver wrote:
> 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.
>
>
--
Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist

Mobile:
+91 8424039903

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Krishnakant Mane 2025-03-01 05:29:20 Re: create_immv issue on aws Ubuntu even after create extention
Previous Message Adrian Klaver 2025-02-28 20:09:35 Re: create_immv issue on aws Ubuntu even after create extention