Content-Type: multipart/alternative;
 boundary="------------yTx0pZRn22RyrY0gGzOFAM3P"
Message-ID: <dd6f888f-71b0-4f66-8264-0dafc7d09383@gmail.com>
Date: Sun, 2 Mar 2025 06:55:25 +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>
Content-Language: en-US
From: Krishnakant Mane <kkproghub@gmail.com>
In-Reply-To: <0b555632-2598-42d8-8e08-ce2881d21ed6@aklaver.com>
Archived-At: <https://www.postgresql.org/message-id/dd6f888f-71b0-4f66-8264-0dafc7d09383%40gmail.com>
Precedence: bulk

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


On 3/1/25 22:17, Adrian Klaver wrote:
> On 2/28/25 21:29, Krishnakant Mane wrote:
>> All done, but no result.
>>
>> I feel it is possible that the latest code must be flawed or something.
>>
>> Well, as a matter of fact, I never had to compile the extention on my 
>> local ubuntu 24.04 machine.
>
> How did you install Postgres on the AWS EC2 instance?
>
> Did you install the postgresql-server-dev-16 package?
>
Yes I did.
>>
>> I just did a create extention and it worked just fine.
>>
>> But on my aws server I had to compile it manually and still it does 
>> not work.
>
> Define not work.
>

create extension command works successfully.

But when I try creating the same immv on the server it says function 
create_immv (unknown, unknown ) does not exist.

Note that this works on my local machine.

>>
>> Regards.
>>
>> On 3/1/25 00:10, Ron Johnson wrote:
>
-- 
Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist 	


Mobile: 	
	+91 8424039903

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

--------------yTx0pZRn22RyrY0gGzOFAM3P
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><br>
    </p>
    <div class="moz-cite-prefix">On 3/1/25 22:17, Adrian Klaver wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:0b555632-2598-42d8-8e08-ce2881d21ed6@aklaver.com">On
      2/28/25 21:29, Krishnakant Mane wrote:
      <br>
      <blockquote type="cite">All done, but no result.
        <br>
        <br>
        I feel it is possible that the latest code must be flawed or
        something.
        <br>
        <br>
        Well, as a matter of fact, I never had to compile the extention
        on my local ubuntu 24.04 machine.
        <br>
      </blockquote>
      <br>
      How did you install Postgres on the AWS EC2 instance?
      <br>
      <br>
      Did you install the postgresql-server-dev-16 package?
      <br>
      <br>
    </blockquote>
    Yes I did.<br>
    <blockquote type="cite"
      cite="mid:0b555632-2598-42d8-8e08-ce2881d21ed6@aklaver.com">
      <blockquote type="cite">
        <br>
        I just did a create extention and it worked just fine.
        <br>
        <br>
        But on my aws server I had to compile it manually and still it
        does not work.
        <br>
      </blockquote>
      <br>
      Define not work.
      <br>
      <br>
    </blockquote>
    <p><br>
    </p>
    <p>create extension command works successfully.</p>
    <p>But when I try creating the same immv on the server it says
      function create_immv (unknown, unknown ) does not exist.</p>
    <p>Note that this works on my local machine.<br>
    </p>
    <blockquote type="cite"
      cite="mid:0b555632-2598-42d8-8e08-ce2881d21ed6@aklaver.com">
      <blockquote type="cite">
        <br>
        Regards.
        <br>
        <br>
        On 3/1/25 00:10, Ron Johnson wrote:
        <br>
      </blockquote>
      <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>

--------------yTx0pZRn22RyrY0gGzOFAM3P--