Re: Doc: Minor update for enable_partitionwise_aggregate

2023-10-10 Thread David Rowley
On Wed, 11 Oct 2023 at 16:26, Andrew Atkinson wrote: > > Thank you for the feedback and clarifications Ashutosh. How about this? > > "which allows grouping or aggregation on partitioned tables to be performed > separately for each partition." This looks good to me. I can take care of this. Davi

Re: CREATE DATABASE with filesystem cloning

2023-10-10 Thread Peter Eisentraut
On 07.10.23 07:51, Thomas Munro wrote: Here is an experimental POC of fast/cheap database cloning. Here are some previous discussions of this: https://www.postgresql.org/message-id/flat/20131001223108.GG23410%40saarenmaa.fi https://www.postgresql.org/message-id/flat/511B5D11.4040507%40socials

Re: [PoC] run SQL over ciphertext

2023-10-10 Thread Peter Eisentraut
On 10.10.23 08:42, Mingyu Li wrote: We have developed an extension, allowing PostgreSQL to run queries over encrypted data. This functionality is achieved via user-defined functions that extend encrypted data types and support commonly used expression operations. Our tests validated its effecti

Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag

2023-10-10 Thread Drouvot, Bertrand
Hi, On 10/11/23 5:40 AM, Michael Paquier wrote: On Wed, Oct 11, 2023 at 08:26:42AM +0900, Michael Paquier wrote: /* flags for InitPostgres() */ #define INIT_PG_LOAD_SESSION_LIBS 0x0001 #define INIT_PG_OVERRIDE_ALLOW_CONNS 0x0002 +#define INIT_PG_BYPASS_ROLE_LOGIN 0x0004 In 00

Add null termination to string received in parallel apply worker

2023-10-10 Thread Zhijie Hou (Fujitsu)
Hi, The parallel apply worker didn't add null termination to the string received from the leader apply worker via the shared memory queue. This action doesn't bring bugs as it's binary data but violates the rule established in StringInfo, which guarantees the presence of a terminating '\0' at the

Re: Pre-proposal: unicode normalized text

2023-10-10 Thread Peter Eisentraut
On 10.10.23 16:02, Robert Haas wrote: On Tue, Oct 10, 2023 at 2:44 AM Peter Eisentraut wrote: Can you restate what this is supposed to be for? This thread appears to have morphed from "let's normalize everything" to "let's check for unassigned code points", but I'm not sure what we are aiming

Re: Pre-proposal: unicode normalized text

2023-10-10 Thread Peter Eisentraut
On 11.10.23 03:08, Jeff Davis wrote: * unicode_is_valid(text): returns true if all codepoints are assigned, false otherwise We need to be careful about precise terminology. "Valid" has a defined meaning for Unicode. A byte sequence can be valid or not as UTF-8. But a string containing u

<    1   2