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 1toZmj-00Ccmv-Du for pgsql-general@arkaria.postgresql.org; Sun, 02 Mar 2025 03:14:34 +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 1toZmi-00CKZm-QO for pgsql-general@arkaria.postgresql.org; Sun, 02 Mar 2025 03:14:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1toZmi-00CKYG-F4 for pgsql-general@lists.postgresql.org; Sun, 02 Mar 2025 03:14:31 +0000 Received: from fout-a6-smtp.messagingengine.com ([103.168.172.149]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1toZme-000S3Q-20 for pgsql-general@postgresql.org; Sun, 02 Mar 2025 03:14:29 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfout.phl.internal (Postfix) with ESMTP id 4D9C21381260; Sat, 1 Mar 2025 22:14:27 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Sat, 01 Mar 2025 22:14:27 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1740885267; x=1740971667; bh=4UfZcsBVkbymuQl7SVWMpyO6x11VTLPYymjzcP0KjZE=; b= icdhV2PLyL81MctHFXWJ1fkFeY0mxN87IA2nTgAw2XGtPws47SUowMKw4S3fe8Hr /AtQVvYwakH7qMyYrtiveOCWG7ZFOW21ojhV6wC0W7VJrYHQYiL4/voQ4uz7brgu +R6NCdRkS7H/ip1KrmEaSgPmvGPcZgOMzRpIeRGPOi78/3xltAS67akmyIfHMkyD TeVb9ZX8CS5mmU1xvy4m6I+wfjwqvhtZ1CrYasBxmblgxOC0eFvNEgifUR2OQUM+ XkDbvzawKju/LfzUbiR56YzYwjRM9Z4WUUlpeDF8pzfBM4/O7Ers3nlzEYZz9obj KprXKB37W67e7NemsVry0g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1740885267; x= 1740971667; bh=4UfZcsBVkbymuQl7SVWMpyO6x11VTLPYymjzcP0KjZE=; b=X GCvMDFi132dLaTtleVhe6+adziROkfumRAbh2MCURgzQoU4cfXlP7m2LHKvQbCJ5 jm3Y+ywA8dudGaoui46mopQgN8zV1MBCEwa41DXVhAOfFARXw3G6ljmrFKpfRSXE zz7i2pm2JUE10cGPUd613LBcHxu8lF6BjHngibxrQ0M9u8uVh/ByN7Yg4CPulOU1 jgwz+x4b7MRSldWWMrSE5a4/Tz1DLrAd0IIdsw3It2HS+Us4FzMriwaMxpgQ5xAm xEM1w0ymLIW73qvL/BYEL/nCiUivOx2XsccUOuMNzsZslijpOcGHC53PG8NhHs1D tdnG+lKR2aWM/PtlVs8wA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdelhedutdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddv jeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvg hrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeefgeefieeutdfggfet gefgheekjeehteeileeigfetieekjedvieeviefgheevtdenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegr khhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuth dprhgtphhtthhopehkkhhprhhoghhhuhgssehgmhgrihhlrdgtohhmpdhrtghpthhtohep uggrvhhiugdrghdrjhhohhhnshhtohhnsehgmhgrihhlrdgtohhmpdhrtghpthhtoheprh honhhljhhohhhnshhonhhjrhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhl qdhgvghnvghrrghlsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 1 Mar 2025 22:14:26 -0500 (EST) Message-ID: Date: Sat, 1 Mar 2025 19:14:25 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: create_immv issue on aws Ubuntu even after create extention To: Krishnakant Mane , "David G. Johnston" Cc: Ron Johnson , pgsql-general References: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com> <0b555632-2598-42d8-8e08-ce2881d21ed6@aklaver.com> <8998e624-ec5d-45b4-8470-accea4d855ee@gmail.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >> 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. Did you not read my previous post? > > -- > Email Signature > *Krishnakant Mane* > Software Architecture Design & Implementation Specialist -- Adrian Klaver adrian.klaver@aklaver.com