Re: LWLock SerializableFinishedList

2025-09-05 Thread Justin
On Fri, Sep 5, 2025 at 1:02 PM Alec Cozens wrote: > Hi > > > > I’m having trouble with PostgreSQL 16.8 on Windows where for maybe days it > all works perfectly until the number of active connections start > increasing, until over say 10 minutes all 97 connections are active but > seemingly waitin

Re: PostgreSQL include directive in plpgsql language PL/pgSQL

2025-09-05 Thread Ron Johnson
On Fri, Sep 5, 2025 at 9:14 AM PALAYRET Jacques wrote: > Hello, > > In a PL/pgSQL function, there is no command for sharing a common part of > the body of several functions, is there? > > In my case, I would like a function that returns a numeric value; this > value is associated with several oth

LWLock SerializableFinishedList

2025-09-05 Thread Alec Cozens
Hi I'm having trouble with PostgreSQL 16.8 on Windows where for maybe days it all works perfectly until the number of active connections start increasing, until over say 10 minutes all 97 connections are active but seemingly waiting on LWLock on SerializableFinishedList. They will remain in thi

Re: PostgreSQL include directive in plpgsql language PL/pgSQL

2025-09-05 Thread Merlin Moncure
On Fri, Sep 5, 2025 at 7:14 AM PALAYRET Jacques wrote: > Hello, > > In a PL/pgSQL function, there is no command for sharing a common part of > the body of several functions, is there? > > In my case, I would like a function that returns a numeric value; this > value is associated with several oth

Re: PostgreSQL include directive in plpgsql language PL/pgSQL

2025-09-05 Thread Tom Lane
"David G. Johnston" writes: > On Friday, September 5, 2025, PALAYRET Jacques > wrote: >> Is there an equivalent of #include (include directive) in functions >> (written in plpgsql language)? > No, there is not. And there won't be one in the future either, as it would give server filesystem acce

Re: PostgreSQL include directive in plpgsql language PL/pgSQL

2025-09-05 Thread David G. Johnston
On Friday, September 5, 2025, PALAYRET Jacques wrote: > > > Is there an equivalent of #include (include directive) in functions > (written in plpgsql language)? > No, there is not. David J.

PostgreSQL include directive in plpgsql language PL/pgSQL

2025-09-05 Thread PALAYRET Jacques
Hello, In a PL/pgSQL function, there is no command for sharing a common part of the body of several functions, is there? In my case, I would like a function that returns a numeric value; this value is associated with several other parameters, some numeric and others textual. It would not be

Re: Latest patches break one of our unit-test, related to RLS

2025-09-05 Thread Dominique Devienne
On Fri, Sep 5, 2025 at 1:10 AM Ron Johnson wrote: > Dumb question: did you read the release notes? Well, now I have. Carefully. Nothing stands out. There's RLS mentioned, but for indexing only. So no smoking gun. We'll have to investigate... :( > In our case, 17.6 "pg_dump --schema-only" broke i