MIME-Version: 1.0
References: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com>
In-Reply-To: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 28 Feb 2025 11:54:48 -0500
Message-ID: <CANzqJaBguoe+RY04g9t8PLGyVBkEmnfvmkJ=k0mqOvtyE4jopA@mail.gmail.com>
Subject: Re: create_immv issue on aws Ubuntu even after create extention
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c7febd062f36aa59"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBguoe%2BRY04g9t8PLGyVBkEmnfvmkJ%3Dk0mqOvtyE4jopA%40mail.gmail.com>
Precedence: bulk

--000000000000c7febd062f36aa59
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Feb 28, 2025 at 11:41=E2=80=AFAM 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?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000c7febd062f36aa59
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Feb 28, 2025 at 11:41=E2=80=AFAM =
Krishnakant Mane &lt;<a href=3D"mailto:kkproghub@gmail.com">kkproghub@gmail=
.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><u></u>

 =20

   =20
 =20
  <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&#39;s why the extention got
      installed in the first place.</p>
    <p>I get the error &quot;function create_immv(unknown, unknown) does no=
t
      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></blockquot=
e><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=3D"gmail_signature_p=
refix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D=
"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I=
&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div=
></div></div></div>

--000000000000c7febd062f36aa59--