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 1toa6y-00Ch08-3Z for pgsql-general@arkaria.postgresql.org; Sun, 02 Mar 2025 03:35:29 +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 1toa6y-00Cmch-9b for pgsql-general@arkaria.postgresql.org; Sun, 02 Mar 2025 03:35:26 +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 1toa6x-00CmcY-RS for pgsql-general@lists.postgresql.org; Sun, 02 Mar 2025 03:35:26 +0000 Received: from mail-pj1-x1029.google.com ([2607:f8b0:4864:20::1029]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1toa6s-000Sor-1w for pgsql-general@postgresql.org; Sun, 02 Mar 2025 03:35:26 +0000 Received: by mail-pj1-x1029.google.com with SMTP id 98e67ed59e1d1-2feb9076cdcso5009781a91.0 for ; Sat, 01 Mar 2025 19:35:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740886522; x=1741491322; darn=postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=sDbfrmbDBTrV1J5HLUpYTXF0WyuPQ3nlaGHaTW7/18Q=; b=UwLtB/XMGQP/OhsfqnuuzfZVzqY0CTPVK/JetMnNrmrYu5LlY9vgV6nm5+wi1S/ipT rCjTyXRYXXlHziWL2iWBB9PtVjwMaTusBkGBsetOGdOmUhWu/VCYYmsrlNIRuIzSCXDb 0fCcU5gBaNrpS5COvpv6VicoJpWNEwXBiSQwBPckfihs7HOlz0CfDcGXMdtuPDsD7mCK mKFh2egFdkWD/+Z47gwRBgmJ28AEJPhV3b4oLnJi+ZBUFSZepjBs2n6f5bkk8UxIH1wu qkXlXUptKrWYyJ+zFt2TjGthj+6lRKa202fyMR5O/ALKYs4r0yzplDk4Ybfaacdpgaoy F9yw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740886522; x=1741491322; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=sDbfrmbDBTrV1J5HLUpYTXF0WyuPQ3nlaGHaTW7/18Q=; b=CBBscpqcodLFP3ZUMD6Vh9YzEkuvxUMDfL6hc9z8P5zzcuSJolPp2NICHczqx6fP+T obZGhkE0fqvYKFdCGypmCu1bl6j1ucH2e5N2UaUGM2qrvFzJoH/AzKNMU4slIxX3oQpq rfsANdrp1GvdJdxFMtmMz+p7kTgug1BUUHx7P6M34s1Ki2g/VJS2o4q0lCYveu02K1x2 WpovCIu/OC4Vr3jXMm8StBFo6QUzSkuphs97EeO7D3rg2cZoVJHtPus+cyvhyu8mnEJJ YLGxacxP8OI82FTCc8CoAfMUvUnxJ1TbgpaRcp+hw92ce81vlL+rD703kSJUP17aorOG 6eJw== X-Forwarded-Encrypted: i=1; AJvYcCVExAKNoiM+xGTRVtV6TxEMuzkTfO8HQEKqfjK0WqwoUP4qq9fKi6VSsxhFYvVlQeQ7lOS5TlPPVGgQotez@postgresql.org X-Gm-Message-State: AOJu0YwFxoBi/Wm8/5FKworUiEkJdUAW316AVKk6N+AGpuARmNdSz562 lOpDYXd+TmX6zYiYcOD1mVpQltXnv/PR7qq1nSH+fXzSkLeCa++g X-Gm-Gg: ASbGncsm/PhiZ+EjlGzShAJN6xkkyODhlFW6emfexAYfdKb2YLR+9q1PNCFTCGFlemq mGpR4bZcjolrXhgINfP2vVUozU2OxdAuWwAsso8G/k1pr2rRQZVFNzQG9Hi8pDRxa16QX85LGUN aqBUqxgNJROuaeD774eJwIiRMRxnxBDb/fhbVtph7tZquGusGMMs+UqRfpnsqPYa8LOik+Gw8Uy ct4IvUe/cAGnojfbxDGLSSQUIy1gourjGyQW0hvJYgcSPW+2tZQ3ZN9IRBoLx+FFSUoCRvmroE6 KJ8xdAYEdySwMOymp5/PheHhPjmtaTkTF/GEQS3qpt1BwQga5kQSuIB39oHcToCDN8jqBPHaEvv X4umMq1hozyfVkOiu X-Google-Smtp-Source: AGHT+IG+ZznV+2TnCAnwa3jfdcLhg31L9uytWQmCXbav+ZwFsqG41p6u+QJUn6DIgmCPde+Tb3hEUA== X-Received: by 2002:a17:90b:4c4d:b0:2ee:e945:5355 with SMTP id 98e67ed59e1d1-2febab78d10mr12598300a91.19.1740886521773; Sat, 01 Mar 2025 19:35:21 -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-2fea696d58esm6337855a91.30.2025.03.01.19.35.19 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 01 Mar 2025 19:35:21 -0800 (PST) Content-Type: multipart/alternative; boundary="------------x3ZUiJ2dxqB9RW6QH1rQkF1f" Message-ID: <8aa636b5-27ea-4614-b8b2-f826f95cdfa3@gmail.com> Date: Sun, 2 Mar 2025 09:05:16 +0530 MIME-Version: 1.0 User-Agent: Betterbird (Linux) Subject: Re: create_immv issue on aws Ubuntu even after create extention To: Adrian Klaver , "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: 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. --------------x3ZUiJ2dxqB9RW6QH1rQkF1f Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 3/2/25 08:44, Adrian Klaver wrote: > >>> 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? > Actually I depend on a screen reader given my total blindness. Somehow it is playing some tricks with thunderbird these days. Some times when there are multiple nested blocks, I may miss the text. But any ways thank you very much. I had doubted it on similar lines, but could not pinpoint the issue. Regards. >> > >> -- >> Email Signature >> *Krishnakant Mane* >> Software Architecture Design & Implementation Specialist > > -- Email Signature *Krishnakant Mane* Software Architecture Design & Implementation Specialist Mobile: +91 8424039903 https://www.linkedin.com/in/krishnakant-r-mane/ --------------x3ZUiJ2dxqB9RW6QH1rQkF1f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


On 3/2/25 08:44, Adrian Klaver wrote:

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?

Actually I depend on a screen reader given my total blindness.  Somehow it is playing some tricks with thunderbird these days.

Some times when there are multiple nested blocks, I may miss the text.

But any ways thank you very much.

I had doubted it on similar lines, but could not pinpoint the issue.

Regards.



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


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

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