Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p15I7-00015w-H0 for pgsql-general@arkaria.postgresql.org; Fri, 02 Dec 2022 12:37:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p15I5-0005Q4-HK for pgsql-general@arkaria.postgresql.org; Fri, 02 Dec 2022 12:37:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p15I5-0005Pv-6i for pgsql-general@lists.postgresql.org; Fri, 02 Dec 2022 12:37:17 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p15I2-0008Ur-B2 for pgsql-general@lists.postgresql.org; Fri, 02 Dec 2022 12:37:16 +0000 Received: by mail-ej1-x62e.google.com with SMTP id ud5so11248134ejc.4 for ; Fri, 02 Dec 2022 04:37:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Cn6Vkebgi4MnfKoNVXLoKvWJJZ6r2oHTEFL21PZbMMk=; b=ev02hvLDCw+mnAWV50uOYLcfKeY3vcPhVGMAWvkOqPAjq1HwqME0A+ARmrNx3un6U9 FBGtltsTHyA3W3ifsSXroo8h8rChSeZ8iogeYO4UE+4nveEAADKteTwysNC9HXGlrNgm L1ahAwYsYZDSRZWX934l/nAT53RTBFBU1NXEGEHBcYMqOfc78cP77G9M++LN918RM3y4 eAgeTOJzsovEkoQz6mj5jnBBB2lkqxEIpUOsdYfIeMO1E6BCWkpjnk9nhZrUMJ+Lpy1T Zq5a2ALd2qxjiaxos0iQWBmsBl9Wnmc3kUygArnKM7CBZWLB15lw7g1Fr8hbW6UsOYyE 0abQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=Cn6Vkebgi4MnfKoNVXLoKvWJJZ6r2oHTEFL21PZbMMk=; b=nFs/25T2qKVIGx8QlGLoKulHQlX7O/CCct1YRX/d5wDDhWR0yKaeFrs+wAcUgBrhy5 uQTKy/mMGkAhvcysGEY1T0cJaznkFUtNVtN4MZtBbF5OOnfFgq9qFtNHcqxrrZL+96Bs iCqdtqsJM3BNBTEeLGMDthbMzOfJVY52+4pf4BXzjtm8+/fSK13AKX9F66sIt8UjsnQc yI0EzF76sHLKx3MlFblyfwHgUemZJTzsMB9ss7amrDqMSJzH3GyjHim5kR1kq+QxTUdz rJbeLAUgszqRyTRe+QCJKa/bHfh0ReKSDMDEOgIB7JrU3BUSf0V+wql8LF5LX9NmAhLN J85A== X-Gm-Message-State: ANoB5plurJ78G6LyHcLRVUk9uOXbd1bHVf436e09bx9SIlwBWgm7ETMU PndpXWM1XzKQNa/wzAVc9nQY8A== X-Google-Smtp-Source: AA0mqf6y8kYkP+3ytDr7v5ahsn1+wfTy2rdpvQXJ14zyVnkqyA1lzmYYXb0KWHwceQPk11s9nF07KQ== X-Received: by 2002:a17:906:350e:b0:7ae:f441:6ade with SMTP id r14-20020a170906350e00b007aef4416ademr48034059eja.436.1669984633348; Fri, 02 Dec 2022 04:37:13 -0800 (PST) Received: from localhost.localdomain (mobiledyn-62-240-134-195.mrsn.at. [62.240.134.195]) by smtp.gmail.com with ESMTPSA id vf6-20020a170907238600b007bebfc97f44sm2952173ejb.75.2022.12.02.04.37.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 02 Dec 2022 04:37:12 -0800 (PST) Message-ID: Subject: Re: Stored procedure code no longer stored in v14 and v15, changed behaviour From: Laurenz Albe To: "Martijn Tonies (Upscene Productions)" , Dominique Devienne , pgsql-general@lists.postgresql.org Date: Fri, 02 Dec 2022 13:37:11 +0100 In-Reply-To: <661B1D571A89455FAE64C8F316D1EAA3@MARTIJNWS> References: <23DE96C56DFC404096553A22DDC5093B@MARTIJNWS> <1579912.1669908194@sss.pgh.pa.us> <661B1D571A89455FAE64C8F316D1EAA3@MARTIJNWS> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2022-12-02 at 08:49 +0100, Martijn Tonies (Upscene Productions) wrote: > So do InterBase, Firebird, SQL Server, MySQL (except for Views, strangely > enough), > MariaDB, NexusDB, SQL Anywhere, and, frankly, all others I know of. > > And this is used all the time by database developers. > > And at least InterBase and Firebird -also- stored a 'parsed version' (in > binary). Great; then go ahead and use those databases, if it is important for you. In the same vein, I don't think any of those databases have trigram or bloom indexes. Perhaps we should improve the acceptance of PostgreSQL by removing those features? Yours, Laurenz Albe