| From: | Krishnakant Mane <kkproghub(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: create_immv issue on aws Ubuntu even after create extention |
| Date: | 2025-03-02 02:14:01 |
| Message-ID: | 8998e624-ec5d-45b4-8470-accea4d855ee@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3/2/25 07:23, Adrian Klaver wrote:
> On 3/1/25 17:39, Krishnakant Mane wrote:
>>
>
>>>> But when I try creating the same immv on the server it says
>>>> function create_immv (unknown, unknown ) does not exist.
>>>
>>> Connect with psql then do:
>>>
>>> 1) \dx
>>> This will show what extensions are installed and in what schema.
>>>
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 above and provide answers.
>
--
Email Signature
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist
Mobile:
+91 8424039903
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2025-03-02 02:21:36 | Re: create_immv issue on aws Ubuntu even after create extention |
| Previous Message | Adrian Klaver | 2025-03-02 01:53:06 | Re: create_immv issue on aws Ubuntu even after create extention |