Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1toYIa-00CINv-1F for pgsql-general@arkaria.postgresql.org; Sun, 02 Mar 2025 01:39:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1toYIa-00AG6J-4E for pgsql-general@arkaria.postgresql.org; Sun, 02 Mar 2025 01:39:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1toYIZ-00AG6A-Nt for pgsql-general@lists.postgresql.org; Sun, 02 Mar 2025 01:39:18 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1toYIU-000S5x-1s for pgsql-general@postgresql.org; Sun, 02 Mar 2025 01:39:17 +0000 Received: by mail-pj1-x102a.google.com with SMTP id 98e67ed59e1d1-2fcb6c42c47so5111565a91.1 for ; Sat, 01 Mar 2025 17:39:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740879554; x=1741484354; darn=postgresql.org; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=KYRk+9z6S18UPmB/PsCZpMeca93bsJyeyX44aRaEjDg=; b=DwLwb0EvbPwZYQK+hJ/J9B9DRHP1sWBcn1z4pZo+GJhjJ21464y2n6MYf7KHciNe7+ 3xWZgf8Ui51PJHcRgC904zC79mvKpeToypzvkKx3peFTmHHjFzCNc6/pm4S+YC0FiLFS BLS57MAN/9faqANT+vkx+JAvPbxhwzKkHjEPFztmmSyBLYNrG2RHjpy6KmA+FQRo+0JO 5Lklx8NWoGVboSfl8XzfWW0dwRNEpsQ72Sbd5Ge3uC/y+tj77HqCSug94AdzPVTF2hJ2 A13aIw/1jun4HzuwRcYWwMR2/QTLUbRgNhVn/uWlBVMAV9ci6wHAJwUv2Mv9xyiA17GJ xkfA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740879554; x=1741484354; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=KYRk+9z6S18UPmB/PsCZpMeca93bsJyeyX44aRaEjDg=; b=ECnU9DGgjnJ02KcKHwAGVGo6X1JQltA6uIuPqCfkUrCLAEJBN4QF21i0JWwdcA/iwh MIFE2qcnLtBP6XCUlemdm5nSRjRGKnymIMVAw9S0dJvEZxM/QMmdT/bQdBcP6mcZVGyC 5tMRRTnIBCrQcIuBG2K1SYYdJYuHiCbfGKXko3BLzA3yQ+neKqKLGmpxEXLV6b1frXTJ 0S/r8e1G04EIMDrIiHkr9oIhUgwS+Vo7G8wQLjST/8Qfsr8yxWFLKVJosE/xVRhZnDFe Ued0nMJE9kb8kSQYTPwnBvcboScjn9f/xcuqcBONbO0Ef+mANi2AQ8DI1sWGvWa415ie 5AaA== X-Forwarded-Encrypted: i=1; AJvYcCU0jNFZppLcc2VG+rCV5ZszFMgpiiMqt3U646QpMB8WMNegyoJ12AEJrgNR6KI07TNPNgoXQehRTFv15MZT@postgresql.org X-Gm-Message-State: AOJu0YxFiCMYcRU7mYsdfc7D584Cvi+c+a84lyBG/nzUtwgmQkU56YHw s+Auft2HvR3PHro5Cr6HlwC8ELiKA/ehvhHjZmRmlTGTkQGwXqbP X-Gm-Gg: ASbGncuc0V6YtZkyeHKejDIvHGvAiYyITf228g3E5Rw1tVMWU/FDsxuXDQHGiJc036p YE8r0wkX01Bsnw7djOWHHnMz5J09ufi6gMP1CZA1TiZG6JJvFVCf8FQqmFvUcWmc8MOO+/8mrpR TuT1PoDPbw+X8rRU7+o0RUXeWUdZRlkbjoTmyBhT8gR+0BcMtGuFGJ62NUzNiWblj/kwWz4Ks5n UTp6VyUQux/S+LORzII/tsorunM98EyC/K2tJU57nzmLRRhD32DQ7Uett9YezOCYJLfSIM+Zx/W vZ6fFzACtX+JxqA6v498iLzFu63SBzUDNDJhdGFz9XhRAZAtflfe0N625qGzlu68b6R0WFyoJoH POachvrSt9PSEFPuM X-Google-Smtp-Source: AGHT+IHlKKI4GcMwpzAsUb2oK/Dlj3fKwyh/X46C9d1fFWw5vyPR6tL4NroQqtXpKE05ine4ye3yAw== X-Received: by 2002:a17:90a:e70e:b0:2ee:94d1:7a9d with SMTP id 98e67ed59e1d1-2febabf7f45mr11620046a91.32.1740879553577; Sat, 01 Mar 2025 17:39:13 -0800 (PST) Received: from ?IPV6:2402:e280:3e2e:391:d595:23f9:c1f8:deb8? ([2402:e280:3e2e:391:d595:23f9:c1f8:deb8]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2fea67ac58asm6187787a91.28.2025.03.01.17.39.11 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 01 Mar 2025 17:39:12 -0800 (PST) Content-Type: multipart/alternative; boundary="------------BfCMnz63LHb3aF30dR6z265Q" Message-ID: Date: Sun, 2 Mar 2025 07:09:09 +0530 MIME-Version: 1.0 User-Agent: Betterbird (Linux) Subject: Re: create_immv issue on aws Ubuntu even after create extention To: Adrian Klaver , Ron Johnson , pgsql-general References: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com> <0b555632-2598-42d8-8e08-ce2881d21ed6@aklaver.com> Content-Language: en-US From: Krishnakant Mane In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------BfCMnz63LHb3aF30dR6z265Q Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 3/2/25 07:03, Adrian Klaver wrote: > On 3/1/25 17:25, Krishnakant Mane wrote: >> >> On 3/1/25 22:17, Adrian Klaver wrote: >>> On 2/28/25 21:29, Krishnakant Mane wrote: >>>> All done, but no result. >>>> >>>> I feel it is possible that the latest code must be flawed or >>>> something. >>>> >>>> Well, as a matter of fact, I never had to compile the extention on >>>> my local ubuntu 24.04 machine. >>> >>> How did you install Postgres on the AWS EC2 instance? > > Please answer above. > sudo apt-get install postgresql postgresql-server-dev-16 >>> >>> Did you install the postgresql-server-dev-16 package? >>> >> Yes I did. > >>> Define not work. >>> >> >> create extension command works successfully. >> >> 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. > > 2) show search_path; > > 3) \df *.create_immv > > Provide the outputs from the above three commands in your response. > > >> >> Note that this works on my local machine. >> >>>> >>>> Regards. >>>> >>>> On 3/1/25 00:10, Ron Johnson wrote: >>> >> -- >> Email Signature >> *Krishnakant Mane* >> Software Architecture Design & Implementation Specialist >> >> >> Mobile: >>     +91 8424039903 >> >> https://www.linkedin.com/in/krishnakant-r-mane/ >> > -- Email Signature *Krishnakant Mane* Software Architecture Design & Implementation Specialist Mobile: +91 8424039903 https://www.linkedin.com/in/krishnakant-r-mane/ --------------BfCMnz63LHb3aF30dR6z265Q Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


On 3/2/25 07:03, Adrian Klaver wrote:
On 3/1/25 17:25, Krishnakant Mane wrote:

On 3/1/25 22:17, Adrian Klaver wrote:
On 2/28/25 21:29, Krishnakant Mane wrote:
All done, but no result.

I feel it is possible that the latest code must be flawed or something.

Well, as a matter of fact, I never had to compile the extention on my local ubuntu 24.04 machine.

How did you install Postgres on the AWS EC2 instance?

Please answer above.
sudo apt-get install postgresql postgresql-server-dev-16

Did you install the postgresql-server-dev-16 package?

Yes I did.

Define not work.


create extension command works successfully.

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.

2) show search_path;

3) \df *.create_immv

Provide the outputs from the above three commands in your response.



Note that this works on my local machine.


Regards.

On 3/1/25 00:10, Ron Johnson wrote:

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


Mobile:    
    +91 8424039903

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


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

Mobile:
+91 8424039903
https://www.linkedin.com/in/krishnakant-r-mane/
--------------BfCMnz63LHb3aF30dR6z265Q--