Re: PLPGSQL - store fetched records in array of record

2025-07-02 Thread Adrian Klaver
On 7/2/25 07:26, Durumdara wrote: Sorry. I forgot to mention that I have two arrays (records). One for the modifiable elements, and one for the checkable elements. If there is a conflict between the actual mod. item and one of the checkable items, the checkable item will move to the end of the

Re: Postgresql support for Windows Server 2025

2025-07-02 Thread Laurenz Albe
On Wed, 2025-07-02 at 20:12 +0530, Gaurav Aradhya wrote: > Can you please let me know when Postgresql 17.x  shall be supported for > Windows Server 2025? Greatly appreciated your feedback. If you want to know if it is working, the best answer is "as soon as someone donates a Windows 2025 buildfarm

Re: Postgresql support for Windows Server 2025

2025-07-02 Thread Adrian Klaver
On 7/2/25 07:42, Gaurav Aradhya wrote: Greetings, Can you please let me know when Postgresql 17.x  shall be supported for Windows Server 2025? Greatly appreciated your feedback. The Windows packaging is done by EDB, someone from there will need to see this and respond or you could contact th

Re: Postgresql support for Windows Server 2025

2025-07-02 Thread David G. Johnston
On Wednesday, July 2, 2025, Gaurav Aradhya wrote: > > Can you please let me know when Postgresql 17.x shall be supported for > Windows Server 2025? Greatly appreciated your feedback. > Impossible to guess when someone may choose to set up a build farm member running that OS. David J.

Postgresql support for Windows Server 2025

2025-07-02 Thread Gaurav Aradhya
Greetings, Can you please let me know when Postgresql 17.x shall be supported for Windows Server 2025? Greatly appreciated your feedback. Thanks Gaurav

Re: Simulate a PITR in postgresql 16

2025-07-02 Thread Franklin Anderson de Oliveira Souza
I don't know exactly what I did wrong but redoing what I described in the email worked perfectly! Thanks everyone! Enviado do Gmail para celular Em seg., 30 de jun. de 2025 às 15:35, Franklin Anderson de Oliveira Souza < frankli...@gmail.com> escreveu: > I'm trying to simulate a PITR in postgr

Re: PLPGSQL - store fetched records in array of record

2025-07-02 Thread Durumdara
Sorry. I forgot to mention that I have two arrays (records). One for the modifiable elements, and one for the checkable elements. If there is a conflict between the actual mod. item and one of the checkable items, the checkable item will move to the end of the modification list. And the actual mo

Re: PLPGSQL - store fetched records in array of record

2025-07-02 Thread Ron Johnson
On Wed, Jul 2, 2025 at 8:21 AM Durumdara wrote: > Hello! > > I have to store some fetched records into two lists (arrays) to work with > them. > There's almost certainly a way to do what you need done without using arrays. Might require a bit of rethinking, though. -- Death to , and butter sa

Re: PLPGSQL - store fetched records in array of record

2025-07-02 Thread David G. Johnston
On Wednesday, July 2, 2025, Durumdara wrote: > > > Is there any way to avoid this? To use a "simple untyped record" in an > array without "dependencies"? > Use jsonb David J.

PLPGSQL - store fetched records in array of record

2025-07-02 Thread Durumdara
Hello! I have to store some fetched records into two lists (arrays) to work with them. I can use the RECORD type in a FOR SELECT loop to get one row data. declare f record; begin for f in select title, length But if I tried to define an "array of record", I got an error message. declare