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 1tUFd2-00FFZK-3P for pgsql-general@arkaria.postgresql.org; Sun, 05 Jan 2025 01:40:32 +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 1tUFd1-00Eug4-BY for pgsql-general@arkaria.postgresql.org; Sun, 05 Jan 2025 01:40:31 +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 1tUFd1-00Eufv-19 for pgsql-general@lists.postgresql.org; Sun, 05 Jan 2025 01:40:30 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tUFcz-000GxW-13 for pgsql-general@lists.postgresql.org; Sun, 05 Jan 2025 01:40:30 +0000 Received: by mail-oi1-x232.google.com with SMTP id 5614622812f47-3eb972dd8e5so6385812b6e.2 for ; Sat, 04 Jan 2025 17:40:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736041226; x=1736646026; darn=lists.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=OkyJbkdMaGmgCCyE3q24JcEu/JIs6D/5AQcX1rvb0yQ=; b=ZlGhYXiJtXmZLKdXEeHhGxed1mvgftUW771ItSqtBQcOJ95SFdiSch0cYvDAPOc7d5 RPk5GMyG9KMhOmYViaLA2IeX80cVAa8JDh8UK8J2XX6iGUPyC+YQyev43BUeC6gKtVdZ 40Fu3tO/byX7GwPXp2CEySUdITpO15Ri2IxPRWZGUCLnx5xXQARL6i8IPhu9BJ31x0rL UuHcj7UjgrKwmJPs/R5s2yuKIaIw1pA1EfiNqiIQ5XPD9WrKdzafeO3isWu7+qYmRsQH qt062yYfBHEK07EBtmGMZtN3GXnxw6k1Om0a/oxRJ/LKgTVFShboSIokeZZaO/8sYIHZ g4/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736041226; x=1736646026; 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=OkyJbkdMaGmgCCyE3q24JcEu/JIs6D/5AQcX1rvb0yQ=; b=H/MQRQCwhK+tvPBGdw93Y2uKw+IcNJ3jQ/ZgwEl0UUjyIrJ9z5hxGeG+78LInzICb0 3LG1aFwoN7zZPyFtSHu5IoEZvFBJz9X60CivPBeQz0mKWjxRiaaZRzp/efX5amjOy8a/ Hx1KyI4H8qieNdDzNQzaB3jXg7qPvOG+XOeGDyKJHZftJTVR3OZxhklT1TALKq6zSP40 DXlxzO29A69g4JyU9hIjtJpwkKyA7+5LhRScyz555kVNyQ/cfPZq2ZGj2HWcyOoCn3e6 H2gSyMbIbxxzZjoQ76ZwkprhKS/5yyiYOSWI/htxThWQkVi4I6m8Q0I0icSSLrZcOP6i PBWQ== X-Forwarded-Encrypted: i=1; AJvYcCV/B2KkdOsSO6jTBUyhdErtsjlxBZRcnAgydRsFoAhnOaY4h7NlesrcKFHSKMoFjqMkifkyCdT9+KgRFsjI@lists.postgresql.org X-Gm-Message-State: AOJu0Yxv8HsjkbIHaGXH7JwvH8E4U5cVKd3yHxg23H7ZVBaqw2E/lyCq vqVA0jYN5OKRmI3OAnzDVfUDxdguAVXdmWnyjKWC1ZiWBoQlagtX7u1PfBOf+X8cInr+MOXk4Vz HHt+K3c0pdLKWHF2a7T3B7X4YcJQ= X-Gm-Gg: ASbGncvJ09YxLm2kN7bV8pC/2wZcehAptwcjq+Vz4E3TyDbfIVvc2ujNNgrtg2xV8ok hiaEBl9wGPdFBTRbkh3mUlDFFx2Hz6WwgEJCcGw== X-Google-Smtp-Source: AGHT+IHRtO7CEfVls3bkZ9RyfabdZJdp3kjCL/oMEOQ8t8yZlBsfLYSU7FhxHCJ3imy1hFx0v0Btr7tA4celSuOH/SE= X-Received: by 2002:a05:6808:1807:b0:3eb:45e7:2bb2 with SMTP id 5614622812f47-3ed88f8891amr26093704b6e.10.1736041226041; Sat, 04 Jan 2025 17:40:26 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a8a:1872:0:b0:577:9519:f64a with HTTP; Sat, 4 Jan 2025 17:40:25 -0800 (PST) In-Reply-To: <20250105001249.cdca9dd84a3061c06f936ca7@magnetkern.de> References: <20241227205025.1d059f72c7c08d23c9648c26@magnetkern.de> <20241228004009.267f21b78394c934f27f9974@magnetkern.de> <20250103135332.7910a008714abaa04d32e5e2@magnetkern.de> <20250103174849.f071d9c6942f76a9b812157c@magnetkern.de> <20250103223312.dde69ae482776e4f1b0c2258@magnetkern.de> <14e035fb-ab35-4a73-a637-ad0180067b07@aklaver.com> <20250104002203.2aed83d48d795ce6fbbd3b61@magnetkern.de> <20250105001249.cdca9dd84a3061c06f936ca7@magnetkern.de> From: "David G. Johnston" Date: Sat, 4 Jan 2025 18:40:25 -0700 Message-ID: Subject: Re: search_path for PL/pgSQL functions partially cached? To: Jan Behrens Cc: Adrian Klaver , Tom Lane , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000009800eb062aeb9881" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009800eb062aeb9881 Content-Type: text/plain; charset="UTF-8" On Saturday, January 4, 2025, Jan Behrens wrote: > > I re-read section 41.11.2. on Plan Caching: > > "The PL/pgSQL interpreter parses the function's source text and > produces an internal binary instruction tree the first time the > function is called (within each session). The instruction tree fully > translates the PL/pgSQL statement structure, > The type of a plpgsql variable is by definition its structure; established in a statement, so this is actually covered by that paragraph. But I would be for adding a bit more specific terminology here. David J. --0000000000009800eb062aeb9881 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, January 4, 2025, Jan Behrens <jbe-mlist@magnetkern.de> wrote:

I re-read section 41.11.2. on Plan Caching:

"The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree the first time the
function is called (within each session). The instruction tree fully
translates the PL/pgSQL statement structure,

The type of a plpgsql variable is by defin= ition its structure; established in a statement, so this is actually covere= d by that paragraph.=C2=A0 But I would be for adding a bit more specific te= rminology here.

David J.

--0000000000009800eb062aeb9881--