Content-Type: multipart/alternative;
 boundary="------------EsgLJAvxQdsrBSeylmTQ4ozo"
Message-ID: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com>
Date: Fri, 28 Feb 2025 22:11:41 +0530
MIME-Version: 1.0
User-Agent: Betterbird (Linux)
Content-Language: en-US
To: pgsql-general <pgsql-general@postgresql.org>
From: Krishnakant Mane <kkproghub@gmail.com>
Subject: create_immv issue on aws Ubuntu even after create extention
Archived-At: <https://www.postgresql.org/message-id/9a1af622-980b-4d81-b997-085dea2f2972%40gmail.com>
Precedence: bulk

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

Hello all.

I am not able to use create_immv in postgresql 16.6 even after 
installing it and doing create extention.

I did a git clone of the repository and then make sudo make install to 
install it.

The issue is not happening on my local ubuntu 24.04 machine but on 
ubuntu 24.04 on aws free tier.

All dependencies are in place, that's why the extention got installed in 
the first place.

I get the error "function create_immv(unknown, unknown) does not exist.

all the tables related to this view exist, data is present and same 
setup works perfectly on my local machine, same OS and postgresql version.

Can someone suggest what could be the solution?

Regards.


Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist 	


Mobile: 	
	+91 8424039903

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

--------------EsgLJAvxQdsrBSeylmTQ4ozo
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>Hello all.</p>
    <p>I am not able to use create_immv in postgresql 16.6 even after
      installing it and doing create extention.</p>
    <p>I did a git clone of the repository and then make sudo make
      install to install it.</p>
    <p>The issue is not happening on my local ubuntu 24.04 machine but
      on ubuntu 24.04 on aws free tier.</p>
    <p>All dependencies are in place, that's why the extention got
      installed in the first place.</p>
    <p>I get the error "function create_immv(unknown, unknown) does not
      exist.</p>
    <p>all the tables related to this view exist, data is present and
      same setup works perfectly on my local machine, same OS and
      postgresql version.</p>
    <p>Can someone suggest what could be the solution?</p>
    <p>Regards.<br>
    </p>
    <p><br>
    </p>
    <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>

--------------EsgLJAvxQdsrBSeylmTQ4ozo--