Re: [PATCH] Add XMLText function (SQL/XML X038)

so 26. 8. 2023 v 22:47 odesílatel Chapman Flack napsal: > On 2023-08-26 16:00, Pavel Stehule wrote: > > Saxon can be an interesting library, but nobody knows if integration > > with > > Postgres is possible. Their C implementation is Java compiled/executed > > by GraalV. > > Indeed, such an

Re: pg_upgrade fails with in-place tablespace

Could you please provide more thoughts about this issue? pg_upgrade is the final issue of in-place tablespace and we are on the cusp of success. -- Best regards, Rui Zhao

Re: broken master regress tests

Hi so 26. 8. 2023 v 23:52 odesílatel Thomas Munro napsal: > On Sun, Aug 27, 2023 at 3:03 AM Pavel Stehule > wrote: > > So it looks so IPC::Run::run is ignore parent environment > > I guess the new initdb template captures lc_messages in > postgresql.conf, when it runs earlier? I guess if you

Re: Extract numeric filed in JSONB more effectively

On 2023-08-22 08:16, Chapman Flack wrote: On 2023-08-22 01:54, Andy Fan wrote: After we label it, we will get error like this: select (a->'a')::int4 from m; ERROR: cannot display a value of type internal Without looking in depth right now, I would double-check what relabel node is being

Re: broken master regress tests

On Sun, Aug 27, 2023 at 3:03 AM Pavel Stehule wrote: > So it looks so IPC::Run::run is ignore parent environment I guess the new initdb template captures lc_messages in postgresql.conf, when it runs earlier? I guess if you put $node->append_conf('postgresql.conf', 'lc_messages=C'); into

Re: [PATCH] Add XMLText function (SQL/XML X038)

On 2023-08-26 16:00, Pavel Stehule wrote: Saxon can be an interesting library, but nobody knows if integration with Postgres is possible. Their C implementation is Java compiled/executed by GraalV. Indeed, such an integration would probably not be in core. Of the two possible-ways-forward

Re: [PATCH] Add XMLText function (SQL/XML X038)

Hi so 26. 8. 2023 v 21:23 odesílatel Chapman Flack napsal: > On 2023-08-26 13:02, Alvaro Herrera wrote: > > Sadly, all the projects seem to have been pretty much abandoned in the > > meantime. Zorba has been dead for 9 years, xqilla for 6. Even XQC, > > the > > API they claim to implement, is

Re: [PATCH] Add XMLText function (SQL/XML X038)

On 2023-08-26 13:02, Alvaro Herrera wrote: Sadly, all the projects seem to have been pretty much abandoned in the meantime. Zorba has been dead for 9 years, xqilla for 6. Even XQC, the API they claim to implement, is dead. Sounds like bad news for the "XQC as integration point" proposal,

Re: Error in calculating length of encoded base64 string

On 2023-Jun-09, Tom Lane wrote: > Gurjeet Singh writes: > > On Thu, Jun 8, 2023 at 7:35 AM Tom Lane wrote: > >> This bug is very ancient, dating to commit 79d78bb26 which > >> added encode.c. (The other instances were presumably copied > >> from there.) Still, it doesn't quite seem worth

Re: [PATCH] Add XMLText function (SQL/XML X038)

On 2023-Aug-25, Chapman Flack wrote: > On 2023-08-25 10:49, Vik Fearing wrote: > > I do not think this should be addressed in this patch because > > there are quite a lot of functions that need to handle this. > > Indeed, as described in [0], we still largely provide the SQL/XML:2003 > notion of

Re: Format list of catalog files in makefile vertically

On 2023-Aug-25, Peter Eisentraut wrote: > I propose to reformat the catalog lists in src/backend/catalog/Makefile to > be more vertical, one per line. This makes it easier to keep that list in > sync with src/include/catalog/meson.build, and visually compare both lists. > Also, it's easier to

Fwd: Invitation to Test and Contribute to Pgperffarm

-- Forwarded message - From: Anil Date: Sat, Aug 26, 2023 at 9:37 PM Subject: Invitation to Test and Contribute to Pgperffarm To: Hello Pgperffarm Community, I'm Anil, a GSoC'23 contributor to Pgperffarm. I'm excited to share our progress as the program approaches its

Re: broken master regress tests

Hi pá 25. 8. 2023 v 9:12 odesílatel Pavel Stehule napsal: > > > pá 25. 8. 2023 v 8:22 odesílatel Matthias van de Meent < > boekewurm+postg...@gmail.com> napsal: > >> >> >> On Fri, 25 Aug 2023, 05:54 Pavel Stehule, >> wrote: >> >>> Hi >>> >>> today build is broken on my Fedora 39 >>> >>>

Re: RFC: Logging plan of the running query

On Fri, Aug 25, 2023 at 7:43 AM James Coleman wrote: > > On Thu, Aug 17, 2023 at 10:02 AM torikoshia > wrote: > > > > On 2023-06-16 01:34, James Coleman wrote: > > > Attached is v28 > > > which sets ProcessLogQueryPlanInterruptActive to false in errfinish > > > when necessary. Once built with

Re: PSQL error: total cell count of XXX exceeded

Thank you David. >From the code logic, I don't think this check is meant to check the limit: If it enters the double-loop (cont.nrows * cont.ncolumns) in printQuery(), the check should be always false (except overflow happened). So, if want to check the limit, we could have done this check

Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue

On Mon, Aug 21, 2023 at 04:44:33PM -0700, Jacob Champion wrote: > On Mon, Aug 21, 2023 at 4:22 PM Michael Paquier wrote: >> There are additionally two more comments in the SSL tests that could >> be removed, I guess. Here's a v4, with Robert's latest suggestion >> added. > > LGTM. Okay.