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 1toZFv-00CVFx-Ts for pgsql-general@arkaria.postgresql.org; Sun, 02 Mar 2025 02:40:40 +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 1toZFw-00Beew-Uz for pgsql-general@arkaria.postgresql.org; Sun, 02 Mar 2025 02:40:39 +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 1toZFw-00Been-JK for pgsql-general@lists.postgresql.org; Sun, 02 Mar 2025 02:40:39 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1toZFt-000Rrd-0z for pgsql-general@postgresql.org; Sun, 02 Mar 2025 02:40:38 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-60009c5dd51so72031eaf.1 for ; Sat, 01 Mar 2025 18:40:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740883237; x=1741488037; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=eBMnFSG0Of8M0t7oK+UgXrYSvW4BSDG3uW7niX0XWBU=; b=O4Ue37aojFFyxLO1J0rjYV0bNhHaZV6cqdtv3m+wrwcf1u6H4+ezw8zfdm32c5bPY3 kONy5ZqlHV9x8ZSC8bRGFTdcWjNiEOBS5fh55AHR9VXpYYHonWeHLlzFznmKRVf/jvwF XQ2wxX9UrcpRs0NuSAkj87N615dzUezS7A8V5QC8BnTGQjv+6OhG9615cOkXApPO1AAd 2J6bCdyYxplL1Em9LJSKESwaIjw1Wl7ydSKfUjRcdWMhENzXjnRTDB8UKwD4DtayFN9t 77/EV2LpL/Xj27w2SCJFyK3Tj4tH6OT3xF42RWb20cMa5kEf5HerJrVOQ62ub8Svv+Zk yjSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740883237; x=1741488037; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=eBMnFSG0Of8M0t7oK+UgXrYSvW4BSDG3uW7niX0XWBU=; b=GQgkdCpYKM7IoAvtPZg/HGF3dvEH9Ny9xw8590eWn9HMM49oChnI3Y+zvpWA/VCNdz IdPUbRb+a8bLIVRCax7jgxRLR0Lto1Ea8dkQwdNySSkDxFHgDDYCf/8GA7+O8moTk/di g3AQl9mxTp+1ZN2/BfvoQxB02zTTNOhB+/LcQSVkjpxJeO2tYVlSqjgnJfl9OLg5veap mlUK5Me7j6SPRng1Ix+JVSW+YbVVZWzGPg/Qn6BFjQBV0vLGv83gLuRyhUIUahNYarMW oajDt/RYXtTtc2GGfUvnNLoUzOPJr4y+5i+85k4ZcaoKv8ysfwlC+Fk0F57hfla8N06x 9aNQ== X-Forwarded-Encrypted: i=1; AJvYcCXLxaQJhrE7J4sQWqdcTKkqSzTJ4MOZuCokzfz5dbi8GqmwR5alIKGXIIf8qGqi73vy1Q4MEQeFEYaM7PaB@postgresql.org X-Gm-Message-State: AOJu0Yz8sco184WPauSwg8rtTAVpr4hVRyDIVM54hqWi6thajONuZ2vE Fe28q3V276vmiSMB7ofQwjJnGa08yl6Yg2veHj0B+UXGa2gAcO4NjUNbjgElm5/kTuCvCVAZA1q z2hLNn2ttEqx6wp6GvjVF7bZUx0CCmA== X-Gm-Gg: ASbGncvGsxdSwULlvoIR/EUz/DSuY1T0IdPtRcEOisOcaolZwB3GHHuV3tVoLmFhYFq Q74EFcOge8NS/GQRS4jDMvxygpIct5ikMICpX8e2HTnUJtmm5jeUMpSB9XmO6RXMcooi91iM2Ei YyudtL5fxcuYDa35mU6oiIREBg X-Google-Smtp-Source: AGHT+IFtjeJyGcIBuUiQj2XL7NloQxWG+j+VzvLqOtQQvxa6VqF/muVvc+vVhOiq2jjNF+zic1ScdUt+LRjfN+vtnvM= X-Received: by 2002:a05:6820:510:b0:5fe:9edb:eafe with SMTP id 006d021491bc7-5feb355ca56mr4185111eaf.5.1740883236964; Sat, 01 Mar 2025 18:40:36 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:7a88:0:b0:589:13f9:e937 with HTTP; Sat, 1 Mar 2025 18:40:36 -0800 (PST) In-Reply-To: <15e8a478-e29f-45e7-9ffd-0611a25a6c69@gmail.com> References: <9a1af622-980b-4d81-b997-085dea2f2972@gmail.com> <0b555632-2598-42d8-8e08-ce2881d21ed6@aklaver.com> <8998e624-ec5d-45b4-8470-accea4d855ee@gmail.com> <15e8a478-e29f-45e7-9ffd-0611a25a6c69@gmail.com> From: "David G. Johnston" Date: Sat, 1 Mar 2025 19:40:36 -0700 X-Gm-Features: AQ5f1JpZoj3vRwXjeR-wj8qWkvFFtuKDYrO-JzhG9Fd00F2nqutkW1EhQefwgXM Message-ID: Subject: Re: create_immv issue on aws Ubuntu even after create extention To: Krishnakant Mane Cc: Adrian Klaver , Ron Johnson , pgsql-general Content-Type: multipart/alternative; boundary="000000000000ef4ff1062f52f6df" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ef4ff1062f52f6df Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, March 1, 2025, Krishnakant Mane wrote: > > Can you tell me how exactly should the syntax be? > https://www.postgresql.org/docs/current/ddl-schemas.html > Is my function definition wrong? > It isn=E2=80=99t a function definition, it is a function call. David J. --000000000000ef4ff1062f52f6df Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, March 1, 2025, Krishnakant Mane <kkproghub@gmail.com> wrote:

Can you tell me how exactly should the syntax be?