Content-Type: multipart/alternative;
 boundary="------------UDS1dIIho6UYBnPN5ydCXjFV"
Message-ID: <32b3f07f-2eb0-4980-9129-f4f7b062bfc2@gmail.com>
Date: Sat, 1 Mar 2025 10:55:33 +0530
MIME-Version: 1.0
User-Agent: Betterbird (Linux)
Subject: Re: create_immv issue on aws Ubuntu even after create extention
To: Adrian Klaver <adrian.klaver@aklaver.com>,
 Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com>
 <CANzqJaBguoe+RY04g9t8PLGyVBkEmnfvmkJ=k0mqOvtyE4jopA@mail.gmail.com>
 <ffec0364-dbc7-4855-afee-975ccb6f5fb5@gmail.com>
 <CANzqJaDyiugA8eFG3rK0x37d70MBDLrL6VTcC9T5S4iLh7WmpQ@mail.gmail.com>
 <a200123e-e27f-4995-ac3a-69026afaf942@gmail.com>
 <078a3947-c88b-413b-86c2-6e25a0459df1@aklaver.com>
Content-Language: en-US
From: Krishnakant Mane <kkproghub@gmail.com>
In-Reply-To: <078a3947-c88b-413b-86c2-6e25a0459df1@aklaver.com>
Archived-At: <https://www.postgresql.org/message-id/32b3f07f-2eb0-4980-9129-f4f7b062bfc2%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------UDS1dIIho6UYBnPN5ydCXjFV
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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/

--------------UDS1dIIho6UYBnPN5ydCXjFV
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Thank you.<br>
    </p>
    <p>Just a quick question.</p>
    <p>should it be in pg_catalog?</p>
    <p>if yes then it is so.<br>
    </p>
    <div class="moz-cite-prefix">On 3/1/25 01:39, Adrian Klaver wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:078a3947-c88b-413b-86c2-6e25a0459df1@aklaver.com">On
      2/28/25 09:26, Krishnakant Mane wrote:
      <br>
      <blockquote type="cite">
        <br>
        On 2/28/25 22:53, Ron Johnson wrote:
        <br>
        <blockquote type="cite">
          <br>
          Differing search_path values can lead to problems like this.
          <br>
          <br>
        </blockquote>
        So what can I do to resolve this?
        <br>
      </blockquote>
      <br>
      In psql do:
      <br>
      <br>
      \dx
      <br>
      <br>
      That will show you what extensions are installed and in what
      schema.
      <br>
      <br>
      Then read this:
      <br>
      <br>
<a class="moz-txt-link-freetext" href="https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH">https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH</a>
      <br>
      <br>
      It explains search_path and how to modify it.
      <br>
      <br>
      <br>
    </blockquote>
    <div class="moz-signature">-- <br>
      <title>Email Signature</title>
      <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
      <table
style="FONT-FAMILY: Tahoma, sans-serif; width: 400px; background: transparent !important;"
        cellspacing="0" cellpadding="0" border="0">
        <tbody>
          <tr>
            <td
style="WIDTH: 240px; padding-bottom: 10px;FONT-FAMILY: Tahoma, sans-serif; font-size: 9pt; line-height: 18px;"><span
style="FONT-FAMILY: Tahoma, sans-serif; FONT-SIZE: 12pt; COLOR: #2c7da5; line-height: 13pt"><strong>Krishnakant
                  Mane</strong></span><span
style="FONT-FAMILY: Tahoma, sans-serif; FONT-SIZE: 9pt; LINE-HEIGHT: 11pt; COLOR: #000000;"><br>
                Software Architecture Design &amp; Implementation
                Specialist</span></td>
            <td
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma, sans-serif; WIDTH: 160px; COLOR: #000000;padding-top 4px; vertical-align: top; text-align: right;">
              <table
style="float: right; background: transparent !important;">
                <tbody>
                  <tr>
                  </tr>
                </tbody>
              </table>
              <br>
            </td>
          </tr>
          <tr>
            <td colspan="2"
style="FONT-SIZE: 9pt; padding-top: 10px; padding-bottom: 10px; line-height: 14pt; border-top: 1px solid #2c7da5;">
              <table style=" background: transparent !important;"
                cellspacing="0" cellpadding="0">
                <tbody>
                  <tr>
                    <td style="width: 79px;"><span
style="padding: 0px; margin: 0px; font-size: 9pt;  line-height: 18px; font-weight: bold; font-family: Tahoma, sans-serif;color: #000000; vertical-align: top;">Mobile:</span></td>
                    <td style="width: 10px;"><br>
                    </td>
                    <td style="width: 311px;"><span
style="padding: 0px; margin: 0px; font-size: 9pt; line-height: 18px; font-family: Tahoma, sans-serif;color: #000000; vertical-align: top;">+91
                        8424039903</span></td>
                  </tr>
                </tbody>
              </table>
            </td>
          </tr>
          <tr>
            <td colspan="2"
style="padding-top: 10px; FONT-SIZE: 8pt; color: #0d3549; line-height: 11px;  max-width: 420px; text-align: justify;">
              <a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/krishnakant-r-mane/">https://www.linkedin.com/in/krishnakant-r-mane/</a> </td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>
</html>

--------------UDS1dIIho6UYBnPN5ydCXjFV--