Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them

2025-06-05 Thread Feike Steenbergen
On Thu, 5 Jun 2025 at 12:49, Peter Eisentraut wrote: > I propose to address this by not allowing the use of user-defined > functions in generation expressions for now. The attached patch > implements this. This assumes that all built-in functions are > trustworthy, for this purpose, which seems

Possibly hard-to-read message

2025-06-05 Thread David G. Johnston
On Thursday, June 5, 2025, Peter Eisentraut wrote: > On 07.04.25 02:55, Daniel Gustafsson wrote: > >> On 7 Apr 2025, at 02:43, David G. Johnston >>> wrote: >>> >> >> How about: >>> >>> + "if set to a number, overrides the default two second \\watch >>> interval\n" >>> >>> I do like the consi

Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them

2025-06-05 Thread Christoph Berg
Re: Tom Lane > > Extending the idea, perhaps the check could be moved to run-time and > > recursively check that only immutable functions are called, including > > user-defined immutable functions? > > I don't think I'd trust that. UDFs can claim to be immutable but > be lying about it. That's w

Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring

2025-06-05 Thread Andres Freund
Hi, On 2025-06-03 12:24:38 -0700, MARK CALLAGHAN wrote: > When measuring the time to create a connection, it is ~2.3X longer with > io_method=io_uring then with io_method=sync (6.9ms vs 3ms), and the > postmaster process uses ~3.5X more CPU to create connections. I can reproduce that - the reason

Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them

2025-06-05 Thread Robert Haas
On Thu, Jun 5, 2025 at 11:19 AM jian he wrote: > I think it will work. > because we already require the generated column expression to be > immutable functions. > > The above functions you mentioned are all not immutable. Hmm. I guess I have no evidence that we have built-in immutable functions t

Re: sslinfo extension - add notbefore and notafter timestamps

2025-06-05 Thread Cary Huang
On Mon, 10 Mar 2025 12:29:28 -0700 Cary Huang wrote --- > The attached v14 is the rebased patch that updated the OpenSSL API calls to > be compatible in > version 1.1.1 (and beyond), which is the new minimum OpenSSL version > supported in PostgreSQL. > > > Cary Huang > --

Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX

2025-06-05 Thread David Rowley
On Fri, 6 Jun 2025 at 08:14, Robert Treat wrote: > I know this thread is rather old and there doesn't seem to be full > agreement on the ALTER vs GUC implementation idea, and even though I > agree with the sentiment that the GUC system is little more than the > "half-baked take on planner hints",

<    1   2