Content-Type: multipart/alternative;
 boundary="------------wKmUvVSOkoGuuC0EaRdKB7Bd"
Message-ID: <8998e624-ec5d-45b4-8470-accea4d855ee@gmail.com>
Date: Sun, 2 Mar 2025 07:44:01 +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>
 <CANzqJaC6aC01wFJAp3ZDDRjhjQhKvoKo-LCBD9X4RGBnqQ60Wg@mail.gmail.com>
 <a0db6853-324c-4acc-ac27-61f7d73ba2e7@gmail.com>
 <0b555632-2598-42d8-8e08-ce2881d21ed6@aklaver.com>
 <dd6f888f-71b0-4f66-8264-0dafc7d09383@gmail.com>
 <b97d6b8d-08c0-418c-b220-48d3da43327d@aklaver.com>
 <d7673366-1d39-4f9f-a9c9-5f12cdd9df53@gmail.com>
 <f8dd2cf6-f492-4f9a-a250-65c44905e72e@aklaver.com>
Content-Language: en-US
From: Krishnakant Mane <kkproghub@gmail.com>
In-Reply-To: <f8dd2cf6-f492-4f9a-a250-65c44905e72e@aklaver.com>
Archived-At: <https://www.postgresql.org/message-id/8998e624-ec5d-45b4-8470-accea4d855ee%40gmail.com>
Precedence: bulk

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


On 3/2/25 07:23, Adrian Klaver wrote:
> On 3/1/25 17:39, Krishnakant Mane wrote:
>>
>
>>>> But when I try creating the same immv on the server it says 
>>>> function create_immv (unknown, unknown ) does not exist.
>>>
>>> Connect with psql then do:
>>>
>>> 1) \dx
>>> This will show what extensions are installed and in what schema.
>>>
pg_ivm | 1.10 | pg_catalog

plpgsql | 1.0 | pg_catalog.


>>> 2) show search_path;
>>> "$user" public.
>>> 3) \df *.create_immv
>>> pgivm | create_immv | bigint | text, text | func.
>>> Provide the outputs from the above three commands in your response.
>
> See above and provide answers.
>
-- 
Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist 	


Mobile: 	
	+91 8424039903

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

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

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 3/2/25 07:23, Adrian Klaver wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:f8dd2cf6-f492-4f9a-a250-65c44905e72e@aklaver.com">On
      3/1/25 17:39, Krishnakant Mane wrote:
      <br>
      <blockquote type="cite">
        <br>
      </blockquote>
      <br>
      <blockquote type="cite">
        <blockquote type="cite">
          <blockquote type="cite">But when I try creating the same immv
            on the server it says function create_immv (unknown, unknown
            ) does not exist.
            <br>
          </blockquote>
          <br>
          Connect with psql then do:
          <br>
          <br>
          1) \dx
          <br>
          This will show what extensions are installed and in what
          schema.
          <br>
          <br>
        </blockquote>
      </blockquote>
    </blockquote>
    <p>pg_ivm | 1.10 | pg_catalog</p>
    <p>plpgsql | 1.0 | pg_catalog.</p>
    <p><br>
    </p>
    <blockquote type="cite"
      cite="mid:f8dd2cf6-f492-4f9a-a250-65c44905e72e@aklaver.com">
      <blockquote type="cite">
        <blockquote type="cite">2) show search_path;
          <br>
          "$user" public.<br>
          3) \df *.create_immv
          <br>
          pgivm | create_immv | bigint | text, text | func. <br>
          Provide the outputs from the above three commands in your
          response.
          <br>
        </blockquote>
      </blockquote>
      <br>
      See above and provide answers.
      <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>

--------------wKmUvVSOkoGuuC0EaRdKB7Bd--