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 1qJJEj-000139-Hh for pgsql-general@arkaria.postgresql.org; Tue, 11 Jul 2023 19:41:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJJEi-0001iJ-Ev for pgsql-general@arkaria.postgresql.org; Tue, 11 Jul 2023 19:41:24 +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 1qJJEh-0001i9-F6 for pgsql-general@lists.postgresql.org; Tue, 11 Jul 2023 19:41:24 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qJJEZ-003Wyj-Am for pgsql-general@lists.postgresql.org; Tue, 11 Jul 2023 19:41:22 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id 7708C3200344; Tue, 11 Jul 2023 15:41:11 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Tue, 11 Jul 2023 15:41:11 -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:sender:subject:subject:to:to; s=fm1; t= 1689104470; x=1689190870; bh=sK/IcbTil7+3Uffuwquo2HAbekTpOdipGjI 09aATzZA=; b=f1cpGqbFxqBUub+zhKW0Cv/845ffCVXBS0JPhgYJ1mrKyUD4fNw KMDVOu5R/bn89siWptc4l2I6o7bIPi/bjYg54HG3ruB4q/N1iNRN1H8F7coOJCrr sxxpO8bLs33oJ/olYWIsOdg3fb+uvxXr9uPZtUjNpcNED1ZiGLqhqo3KOr3Vic3g MxIGu5CaD8S+YfBLn6VGT59mRFqM8e4GDQxluCrkQuu5THecrQYlfLI2rjFIZ+ML DWSy+Au+QoKMk8omSgiMXxxfDg3W69JTKqJKaivzatVhKNMQi+PGmrHOXB/2V7Ok GdvjbHjQJsmbkzQt6Ip3TlGX65qLFMdNTfg== 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:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1689104470; x=1689190870; bh=sK/IcbTil7+3Uffuwquo2HAbekTpOdipGjI 09aATzZA=; b=RjCPgYmI6kP0sMTPc61rK43RrbEfFsLODVGR5n7lYhhwlNolOWb YAcO6xmrh3GbvRo0763NfAfdStpyvG4hUUqInhm9qPt37wN/4548t/u2j9CKWt1o f6RKMnk1lTGZFhUPc1sMOV9ev5ojC47xVzH8oHJLkCFU2YM1CvMmUdkgerrjKyBY eZbvkwWr2mRDX5j6dCd1bxC5jWMvbukMdUwUjZwwDj0tX8YVQMUv4MrUEheQ5hSy Ue1QmSRtNTU7ibtxGArsKbsaDbP5wY4aDsUVwDkmWYmr4M3wdTgLg4FQaNJ5qVJa RBCyPd8PgXwqzKFvirw9x7ch/4sXkGiymww== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrfedtgddugeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtfeejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhephfegveekfeelffdvgfdvfefftdeujeehheeuieff hfefiefhvdfhgfetgfdvuefgnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrgh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughr ihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 11 Jul 2023 15:41:10 -0400 (EDT) Message-ID: <87e07b97-fac2-7dae-4f7e-43e3d6cfb978@aklaver.com> Date: Tue, 11 Jul 2023 12:41:09 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: How to add function schema in search_path in option definitio To: Lorusso Domenico Cc: pgsql-general@lists.postgresql.org References: <9f3db764-804e-7154-3f8c-f5f19628178e@aklaver.com> <20230709110149.hdjv6vhukz2sz3c6@hjp.at> 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 7/11/23 12:35, Lorusso Domenico wrote: > yes, but this is a code inside each function. >  having 20 functions I've to start executing this instruction 20 times, > one per function. > I know it could work, I looking for something of more smart :-) Here: https://www.postgresql.org/message-id/66677cb3-17b3-20d1-1c22-9a7ac3208921%40aklaver.com I provide options 1) and 3) to use instead of including the path change in the functions(s). > > Il giorno dom 9 lug 2023 alle ore 23:21 Adrian Klaver > > ha scritto: > > On 7/9/23 13:47, Lorusso Domenico wrote: > > Hello Adrian and Peter, > > yes the set parameter in function definition is also my preferred > > choice, but.... > > > > I need to add the schema to path, not to substitute the path, > this is my > > problem > > > > This post: > > https://www.postgresql.org/message-id/9f3db764-804e-7154-3f8c-f5f19628178e%40aklaver.com > > showed a way to do that. > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > > > -- > Domenico L. > > per stupire mezz'ora basta un libro di storia, > io cercai di imparare la Treccani a memoria... [F.d.A.] -- Adrian Klaver adrian.klaver@aklaver.com