Content-Type: multipart/alternative;
 boundary="------------FyPMqYGWfPGcTCdQPLjsk1Pd"
Message-ID: <ffec0364-dbc7-4855-afee-975ccb6f5fb5@gmail.com>
Date: Fri, 28 Feb 2025 22:31:53 +0530
MIME-Version: 1.0
User-Agent: Betterbird (Linux)
Subject: Re: create_immv issue on aws Ubuntu even after create extention
To: 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>
Content-Language: en-US
From: Krishnakant Mane <kkproghub@gmail.com>
In-Reply-To: <CANzqJaBguoe+RY04g9t8PLGyVBkEmnfvmkJ=k0mqOvtyE4jopA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/ffec0364-dbc7-4855-afee-975ccb6f5fb5%40gmail.com>
Precedence: bulk

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

Ok here you go.

select create_immv('plantskillpayment', 'select distinct kwapp_plant.id 
as plantid, kwapp_skill.id as skillid, kwapp_skill.skillname, 
kwapp_plant.plantname, kwapp_pltsklpaylvl.level, kwapp_pltsklpaylvl.pay 
from kwapp_skill, kwapp_plant,  kwapp_pltsklpaylvl  where 
kwapp_skill.id  = kwapp_pltsklpaylvl.skillid_id  and kwapp_plant.id = 
kwapp_pltsklpaylvl.plantid_id');


You see, the point is this works perfectly on all local machines with 
exact same versions and same data.

Regards.

On 2/28/25 22:24, Ron Johnson wrote:
> On Fri, Feb 28, 2025 at 11:41 AM Krishnakant Mane 
> <kkproghub@gmail.com> wrote:
>
>     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?
>
> Show your work!
>
> What command did you run to get that error?
>
> -- 
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
-- 
Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist 	


Mobile: 	
	+91 8424039903

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

--------------FyPMqYGWfPGcTCdQPLjsk1Pd
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>Ok here you go.</p>
    <p>select create_immv('plantskillpayment', 'select distinct
      kwapp_plant.id as plantid, kwapp_skill.id as skillid,
      kwapp_skill.skillname, kwapp_plant.plantname,
      kwapp_pltsklpaylvl.level, kwapp_pltsklpaylvl.pay from kwapp_skill,
      kwapp_plant,  kwapp_pltsklpaylvl  where kwapp_skill.id  =
      kwapp_pltsklpaylvl.skillid_id  and kwapp_plant.id =
      kwapp_pltsklpaylvl.plantid_id');<br>
    </p>
    <p><br>
    </p>
    <p>You see, the point is this works perfectly on all local machines
      with exact same versions and same data.</p>
    <p>Regards.<br>
    </p>
    <div class="moz-cite-prefix">On 2/28/25 22:24, Ron Johnson wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CANzqJaBguoe+RY04g9t8PLGyVBkEmnfvmkJ=k0mqOvtyE4jopA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">On Fri, Feb 28, 2025 at 11:41 AM Krishnakant Mane
          &lt;<a href="mailto:kkproghub@gmail.com"
            moz-do-not-send="true" class="moz-txt-link-freetext">kkproghub@gmail.com</a>&gt;
          wrote:</div>
        <div class="gmail_quote gmail_quote_container">
          <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div>
              <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>
            </div>
          </blockquote>
          <div>Show your work!</div>
          <div><br>
          </div>
          <div>What command did you run to get that error?</div>
          <div><br>
          </div>
        </div>
        <span class="gmail_signature_prefix">-- </span><br>
        <div dir="ltr" class="gmail_signature">
          <div dir="ltr">Death to &lt;Redacted&gt;, and butter sauce.
            <div>Don't boil me, I'm still alive.<br>
              <div>
                <div>&lt;Redacted&gt; lobster!</div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </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>

--------------FyPMqYGWfPGcTCdQPLjsk1Pd--