Content-Type: multipart/alternative;
 boundary="------------4dFp5p2cwSQZnKMuLuQ12LGV"
Message-ID: <ebf1054b-e5b2-4980-891e-c31af59f0b77@gmail.com>
Date: Sun, 2 Mar 2025 08:09:20 +0530
MIME-Version: 1.0
User-Agent: Betterbird (Linux)
Subject: Re: create_immv issue on aws Ubuntu even after create extention
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: 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>
 <8998e624-ec5d-45b4-8470-accea4d855ee@gmail.com>
 <CAKFQuwYWq2sEa8CRedrrTKNEpYoDRUW1rcm8xcw4O+Ua2bG1fw@mail.gmail.com>
Content-Language: en-US
From: Krishnakant Mane <kkproghub@gmail.com>
In-Reply-To: <CAKFQuwYWq2sEa8CRedrrTKNEpYoDRUW1rcm8xcw4O+Ua2bG1fw@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/ebf1054b-e5b2-4980-891e-c31af59f0b77%40gmail.com>
Precedence: bulk

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


On 3/2/25 07:54, David G. Johnston wrote:
> On Saturday, March 1, 2025, Krishnakant Mane <kkproghub@gmail.com> wrote:
>
>
>     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 this issue for why this is different now.
>
> https://github.com/sraoss/pg_ivm/pull/116
>
> Then deal with the fact it is no longer installed to pg_control but 
> instead pgivm. With usual schema qualifications or search_path techniques.
>
Thank you, it worked.  now pgivm.create_immv works.

I should have got it before.

> David J.
>
-- 
Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist 	


Mobile: 	
	+91 8424039903

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

--------------4dFp5p2cwSQZnKMuLuQ12LGV
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:54, David G. Johnston
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKFQuwYWq2sEa8CRedrrTKNEpYoDRUW1rcm8xcw4O+Ua2bG1fw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      On Saturday, March 1, 2025, 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:<br>
      <blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
        <div>
          <p><br>
          </p>
          <div>pg_ivm | 1.10 | pg_catalog<br>
          </div>
          <p>plpgsql | 1.0 | pg_catalog.</p>
          <p><br>
          </p>
          <blockquote type="cite">
            <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.</blockquote>
            </blockquote>
          </blockquote>
        </div>
      </blockquote>
      <div>See this issue for why this is different now.</div>
      <div><br>
      </div>
      <div><a href="https://github.com/sraoss/pg_ivm/pull/116"
          moz-do-not-send="true" class="moz-txt-link-freetext">https://github.com/sraoss/pg_ivm/pull/116</a></div>
      <div><br>
      </div>
      <div>Then deal with the fact it is no longer installed to
        pg_control but instead pgivm. With usual schema qualifications
        or search_path techniques.</div>
      <div><br>
      </div>
    </blockquote>
    <p>Thank you, it worked.  now pgivm.create_immv works.</p>
    <p>I should have got it before.<br>
    </p>
    <blockquote type="cite"
cite="mid:CAKFQuwYWq2sEa8CRedrrTKNEpYoDRUW1rcm8xcw4O+Ua2bG1fw@mail.gmail.com">
      <div>David J.</div>
      <div><br>
      </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>

--------------4dFp5p2cwSQZnKMuLuQ12LGV--