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 1twPTK-00EBW5-N7 for pgsql-general@arkaria.postgresql.org; Sun, 23 Mar 2025 17:50:54 +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 1twPTJ-002ojr-CS for pgsql-general@arkaria.postgresql.org; Sun, 23 Mar 2025 17:50:53 +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 1twPTI-002ojj-GY for pgsql-general@lists.postgresql.org; Sun, 23 Mar 2025 17:50:53 +0000 Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1twPTF-000i8U-0n for pgsql-general@lists.postgresql.org; Sun, 23 Mar 2025 17:50:52 +0000 Received: from phl-compute-07.internal (phl-compute-07.phl.internal [10.202.2.47]) by mailfhigh.phl.internal (Postfix) with ESMTP id C150D1140169; Sun, 23 Mar 2025 13:50:47 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-07.internal (MEProxy); Sun, 23 Mar 2025 13:50:47 -0400 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=1742752247; x=1742838647; bh=GUvUEG/pWqgNCI+2hziXNga0xwVbAqNBpcJju20Ia7g=; b= GEPz+5VpanyibqE2vWqdvXwSStTi/Qbrg3YwaX+kTjlgCz3IRWzeuf299mV9sON6 rUSAuBahx9JjLYaRZBnu5hgGLNKl0/sqwrxHCneZDibUYcEd3GDTApy73M5uy+hp Lo203sH053oxdRlu/SXGXuFKvQ7CiZWOEtojCjEG2/JsIJi2B6EmLSzznWeFs+bY jZeZWt+ZXFqXtcHM8B7Tcu1TkMH+3KtYLQgA4kbLj4hSxR2NeAifVY80AKp7wn9p 2+GA1i7D7fTT23iZZc7B7FFXGLNCElvcB/YboVVT8uEIuAhK3AEktrbG+B9VCZPd To7xzQC4I/fP7+JncfN2Aw== 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=1742752247; x= 1742838647; bh=GUvUEG/pWqgNCI+2hziXNga0xwVbAqNBpcJju20Ia7g=; b=G 5O++YZqH23f79nz7+b8s17I+UdQuRa4kwJD3CPtTy5Z2u0FU2OR4vW7H03Da7Q2w bD32BWd/I1CbI4dqSGnyRp6Miweb8ERH5yrJoTER0AN0W8nYObGdyrPB9q20z73Y ux8o0DpKYzkoryTQNy4U4PiUKoFKefhm6UqPr/doHzTs3/Qd3vJHB+AuYEQCyZAW yR6bVno4HK+i80RWpurbq3eZTJRluuixdfncjgnO1cPeEUKgU+MHws5hplv0k+V1 N4l8D7UC7X0cUK0QLtREctJr0de1QEcE+h4ldYNMSiY/bsbsGzd8DOy2a5iS/3fn 6n57i2l0QZ2qp/YTPz8AQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduheejheduucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddt vdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvh gvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepgfdufeekhfevfeel veeiueevhedvuddukeduvddvlefhueeuieejtdeuvdevvdeunecuffhomhgrihhnpehpoh hsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhep mhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpd hnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehikhho rhhothdtudesghhmrghilhdrtghomhdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrd hprgdruhhspdhrtghpthhtohepuggrvhhiugdrghdrjhhohhhnshhtohhnsehgmhgrihhl rdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhosh htghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 23 Mar 2025 13:50:46 -0400 (EDT) Message-ID: <4e713159-7c31-4fda-a41f-f9d070aaf35e@aklaver.com> Date: Sun, 23 Mar 2025 10:50:45 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Determine server version from psql script To: Igor Korot , Tom Lane Cc: "David G. Johnston" , "pgsql-generallists.postgresql.org" References: <90741d5f-5cda-4c4a-84f4-c470129732f4@aklaver.com> <473602.1742698901@sss.pgh.pa.us> 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 On 3/23/25 10:38, Igor Korot wrote: > Hi, Tom, > > > > 2 things, however. > 1. Apparently CREATE OR RELACE TRIGGER syntax is available since v17, > which is the current one. So I hadto adjust the numbers.. 😀 Really?: https://www.postgresql.org/docs/14/sql-createtrigger.html "CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name ..." -- Adrian Klaver adrian.klaver@aklaver.com