Re: search_path for PL/pgSQL functions partially cached? - Mailing list pgsql-general

From David G. Johnston
Subject Re: search_path for PL/pgSQL functions partially cached?
Date
Msg-id CAKFQuwYTsfYmw9TNiXH=r2WUvDo7QpS+jtYAxK3an2OG7anpMA@mail.gmail.com
Whole thread Raw
In response to Re: search_path for PL/pgSQL functions partially cached?  (Jan Behrens <jbe-mlist@magnetkern.de>)
List pgsql-general
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 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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: search_path for PL/pgSQL functions partially cached?
Next
From: Laurenz Albe
Date:
Subject: Re: search_path for PL/pgSQL functions partially cached?