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 1qUrOx-00FByY-14 for pgsql-hackers@arkaria.postgresql.org; Sat, 12 Aug 2023 16:23:43 +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 1qUrOv-001OKM-1C for pgsql-hackers@arkaria.postgresql.org; Sat, 12 Aug 2023 16:23:41 +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 1qUrOu-001OGv-Nt for pgsql-hackers@lists.postgresql.org; Sat, 12 Aug 2023 16:23:41 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qUrOq-0026Qw-6Q for pgsql-hackers@postgresql.org; Sat, 12 Aug 2023 16:23:39 +0000 Received: by mail-pl1-x62e.google.com with SMTP id d9443c01a7336-1bdca7cc28dso4901835ad.1 for ; Sat, 12 Aug 2023 09:23:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1691857413; x=1692462213; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=g2/0k6yW9wKYegB+Oqc4Wej9eLiuLsE+oaVabhF5SZg=; b=Y3UNqu1FINb7+yn1frkZNXf4Z2Zuidgt31fjHVHzrP/HwDmNGvjdvLyGKhkb6kfcAm 1izqiN0ceH9xB7jkPGcZypepw2V/Zc+WCwfBWxSZzTuwqe60cyMlHUc77awtPme8DswL T9XEsb2Cz91O5o+TJ3aU1bX5ur2wDBk21vnTqV2lX6Ahsrn7UqXeSI+EZdvnyIApsVXi z68bLmg5Y4xyQh1c/x6Ucyr6LikUMjY2Nh8yMlS1wmjxbfbBPp1sgJErR7qA2O23Q9Rr rjrUJBV6oZO0o9bnG7aKmj88iWpQEsX7AYveJZUJ8bAe3qOWAgZ4jzZ8gtIY/oce7RaG J0bg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691857413; x=1692462213; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=g2/0k6yW9wKYegB+Oqc4Wej9eLiuLsE+oaVabhF5SZg=; b=HcjC9iend2+YQa2rGHlzq7C6O7i0HCe5smbS4Oz5ML9tkURRtagtOb9YBKlH865JvL pii+N9WQBG6FneAz6sMSBFelcapKgZioqkfGwQ4JV5cdbp6xy48Ya38dvPMz1zxE5Ysh /qaNBfFLiSSsHTIsblqCuZZa2tH3qnIClqgL/+bnPt9w/795Vtfo+rVl1d/HGwjpT1n8 DI48fFiTmo1X4imgY8ri/3ZyVyI5hV8qcLYjp6IXsdFxzzlSGAx2K/8njAW2ri/41e+g M6eUQ7okzhOOEQ8v7d6YNm7MmVqPf6UEBkAuhO7fYJXbb/mGj9q++QD3DLkZfvAfGsa4 Q89A== X-Gm-Message-State: AOJu0YxXyPNDmiVRcSFueZxbAUNS99tT+ds7EeWdE43dgzXN8qkCJqhG DcvtF3dM5QPm7EWpYVSwkcALDZ8FkHasNoekl4c= X-Google-Smtp-Source: AGHT+IH3nA5jbk9O4UbKFls119R1xIxb2Y3QI7UxrHK4Wv4VtXHWaUWpBUJzLGTjUCV8tuUI8lf1qg== X-Received: by 2002:a17:903:22cc:b0:1b6:797d:33fb with SMTP id y12-20020a17090322cc00b001b6797d33fbmr5985565plg.64.1691857413391; Sat, 12 Aug 2023 09:23:33 -0700 (PDT) Received: from jeff-laptop.lan (c-98-45-81-55.hsd1.ca.comcast.net. [98.45.81.55]) by smtp.gmail.com with ESMTPSA id w14-20020a170902e88e00b001bbdf33b878sm6026992plg.272.2023.08.12.09.23.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 12 Aug 2023 09:23:33 -0700 (PDT) Message-ID: <4168fd47dc34291d0eca0b4ed1207db922cce3ce.camel@j-davis.com> Subject: Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } From: Jeff Davis To: Joe Conway , pgsql-hackers@postgresql.org Date: Sat, 12 Aug 2023 09:23:31 -0700 In-Reply-To: <53f0b7f1-6290-3b99-5040-ac3541df1475@joeconway.com> References: <2710f56add351a1ed553efb677408e51b060e67c.camel@j-davis.com> <0e51f9e2-9272-ccb3-9219-39d7695f7c50@joeconway.com> <53f0b7f1-6290-3b99-5040-ac3541df1475@joeconway.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 2023-08-12 at 09:50 -0400, Joe Conway wrote: > Hmm, I guess I was too hasty -- seems we have some magic related to > this=20 > already. I was worried after your first email. But yes, the magic is in FuncnameGetCandidates(), which simply ignores functions in the temp namespace. It would be better if we were obviously safe rather than magically safe, though. Regards, Jeff Davis