public inbox for [email protected]
help / color / mirror / Atom feedRe: create_immv issue on aws Ubuntu even after create extention
2+ messages / 2 participants
[nested] [flat]
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-02-28 20:09 Adrian Klaver <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Adrian Klaver @ 2025-02-28 20:09 UTC (permalink / raw)
To: Krishnakant Mane <[email protected]>; Ron Johnson <[email protected]>; 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
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: create_immv issue on aws Ubuntu even after create extention
@ 2025-03-01 05:25 Krishnakant Mane <[email protected]>
parent: Adrian Klaver <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Krishnakant Mane @ 2025-03-01 05:25 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; Ron Johnson <[email protected]>; 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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-03-01 05:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-28 20:09 Re: create_immv issue on aws Ubuntu even after create extention Adrian Klaver <[email protected]>
2025-03-01 05:25 ` Krishnakant Mane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox