...)
Thanks,
Erik Rijkers
.
Erik Rijkers
Op 5/6/24 om 19:44 schreef Jonathan S. Katz:
Hi,
Please find the draft of the 2024-05-09 release announcement.
'procedures that returns' should be
'procedures that return'
Typo. fix:
-attempted first. If the server ejectes GSS encryption, SSL is
+attempted first. If the server rejects GSS encryption, SSL is
Erik--- doc/src/sgml/libpq.sgml.orig 2024-04-09 06:28:36.254541932 +0200
+++ doc/src/sgml/libpq.sgml 2024-04-09 06:30:55.818541454 +0200
@@
Op 3/4/24 om 10:40 schreef Amit Langote:
Hi Jian,
Thanks for the reviews and sorry for the late reply. Replying to all
emails in one.
> [v40-0001-Add-SQL-JSON-query-functions.patch]
> [v40-0002-Show-function-name-in-TableFuncScan.patch]
> [v40-0003-JSON_TABLE.patch]
In my hands (applying
Op 12/7/23 om 10:32 schreef Amit Langote:
On Thu, Dec 7, 2023 at 12:26 AM Alvaro Herrera wrote:
On 2023-Dec-06, Amit Langote wrote:
I think I'm inclined toward adapting the LA-token fix (attached 0005),
This one needs to be fixed, so done.
On Thu, Dec 7, 2023 at 5:25 PM Peter Eisentraut
someone.
I've tested this, albeit mostly in the initial iterations (*shrug* but
a mention is nice)
Erik Rijkers
--
Daniel Gustafsson
Op 11/15/23 om 14:00 schreef Amit Langote:
Hi,
[..]
Attached updated patch. The version of 0001 that I posted on Oct 11
to add the error-safe version of CoerceViaIO contained many
unnecessary bits that are now removed.
--
Thanks, Amit Langote
EDB: http://www.enterprisedb.com
>
Hi,
At the moment, what is the patchset to be tested? The latest SQL/JSON
server I have is from September, and it's become unclear to me what
belongs to the SQL/JSON patchset. It seems to me cfbot erroneously
shows green because it successfully compiles later detail-patches (i.e.,
not the
Some small (grammatical) changes in event-trigger.sgml
(also one delete of 'community-we' (which I think is just confusing for
the not-postgresql-community reader).
Erik--- doc/src/sgml/event-trigger.sgml.orig 2023-10-16 17:16:00.017452340 +0200
+++ doc/src/sgml/event-trigger.sgml 2023-10-16
Op 9/27/23 om 15:55 schreef Amit Langote:
On Thu, Sep 21, 2023 at 9:41 PM Amit Langote wrote:
I don't knoe, maybe it's worthwhile to fix this (admittedly trivial)
fail in the tests? It's been there for a while.
Thanks,
Erik
diff -U3
Op 9/22/23 om 12:12 schreef Tatsuo Ishii:
Op 9/22/23 om 07:16 schreef Tatsuo Ishii:
Attached is the fix against v6 patch. I will include this in upcoming
v7 patch.
Attached is the v7 patch. It includes the fix mentioned above. Also
(Champion's address bounced; removed)
On my side his
:
-- using NEXT
-- using AFTER MATCH SKIP TO NEXT ROW
result of first_value(price) and next_value(price) are empty.
Erik Rijkers
this time the pattern matching engine is enhanced: previously it
recursed to row direction, which means if the number of rows in a
frame is large, it could exceed
Op 9/22/23 om 10:23 schreef Erik Rijkers:
Op 9/22/23 om 07:16 schreef Tatsuo Ishii:
Attached is the fix against v6 patch. I will include this in upcoming
v7 patch.
Attached is the v7 patch. It includes the fix mentioned above. Also
(Champion's address bounced; removed)
Sorry, I forgot
attached .diff file.
In these two statements:
-- using NEXT
-- using AFTER MATCH SKIP TO NEXT ROW
result of first_value(price) and next_value(price) are empty.
Erik Rijkers
this time the pattern matching engine is enhanced: previously it
recursed to row direction, which means if the number of rows
Op 9/19/23 om 13:56 schreef Amit Langote:
On Tue, Sep 19, 2023 at 7:18 PM Alvaro Herrera wrote:
0001: I wonder why you used Node for the ErrorSaveContext pointer
instead of the specific struct you want. I propose the attached, for
some extra type-safety. Or did you have a reason to do it
Op 9/18/23 om 13:14 schreef Erik Rijkers:
Op 9/18/23 om 12:20 schreef Amit Langote:
Hi Erik,
I am sorry to be bothering you with these somewhat idiotic SQL
statements but I suppose somehow it needs to be made more solid.
For 60 datatypes, I ran this statement:
select json_query(jsonb
Op 9/18/23 om 12:20 schreef Amit Langote:
Hi Erik,
I am sorry to be bothering you with these somewhat idiotic SQL
statements but I suppose somehow it needs to be made more solid.
For 60 datatypes, I ran this statement:
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
Op 9/18/23 om 05:15 schreef Amit Langote:
On Sun, Sep 17, 2023 at 3:34 PM Erik Rijkers wrote:
Op 9/14/23 om 10:14 schreef Amit Langote:
Hi Amit,
Just now I built a v14-patched server and I found this crash:
select json_query(jsonb '
{
"arr": [
{"arr": [2,3]
Op 9/14/23 om 10:14 schreef Amit Langote:
Hi Amit,
Just now I built a v14-patched server and I found this crash:
select json_query(jsonb '
{
"arr": [
{"arr": [2,3]}
, {"arr": [4,5]}
]
}'
, '$.arr[*].arr ? (@ <= 3)' returning anyarray WITH WRAPPER) --crash
;
server closed the
, this too
would be good to explain in the doc where JSON indexes are explained.
Erik Rijkers
Thanks,
David
p 9/13/23 om 22:01 schreef David E. Wheeler:
On Sep 13, 2023, at 01:11, Erik Rijkers wrote:
"All use of json*() functions preclude index usage."
That sentence is missing from the documentation.
Where did that come from? Why wouldn’t JSON* functions use indexes? I see that
the
index usage."
That sentence is missing from the documentation.
Erik Rijkers
-09-02 19:59:05.329 CEST 46723 LOG: terminating any other active
server processes
Erik Rijkers
.
Thanks,
Erik Rijkers
I found out that llvmjit_expr.c additions have been broken all along,
I mean since I rewrote the JsonExpr evaluation code to use soft error
handling back in January or so. For example, I had made CoerceiViaIO
evaluation code (EEOP_IOCOERCE ExprEvalStep) invoked
I normally pull from
https://git.postgresql.org/git/postgresql.git/
but for a few hours now it's been failing (while other git repo's are
still reachable).
Is it me or is there a hiccup there?
thanks,
Erik Rijkers
Op 8/26/23 om 04:51 schreef Jonathan S. Katz:
On 8/24/23 11:17 AM, Erik Rijkers wrote:
Op 8/24/23 om 16:32 schreef Jonathan S. Katz:
On 8/23/23 5:07 PM, David Rowley wrote:
On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz
wrote:
Hi,
When v15 docs have:
"27.2.7. Cascading Replic
Op 8/24/23 om 16:32 schreef Jonathan S. Katz:
On 8/23/23 5:07 PM, David Rowley wrote:
On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz
wrote:
Hi,
When v15 docs have:
"27.2.7. Cascading Replication
The cascading replication feature allows a standby server to accept
replication connections
Hello,
The following surprised me enough to think it might be a bug:
(17devel)
select
regexp_replace('Abc Def'
, '([a-z]) ([A-Z])'
, '\1 ' || lower('\2') );
regexp_replace
Abc Def
(1 row)
-- 'Abc Def' got
-- 'Abc def' expected
What do you think?
Thanks,
Erik
Op 8/14/23 om 14:51 schreef Pavel Stehule:> po 14. 8. 2023 v 11:32
odesílatel Alvaro Herrera
> with proposed function I can write
>
> select jsonb_populate_array(null:date[],
> '["2023-07-13","2023-07-14"]'::jsonb)
>
Not yet committed, but outstanding
SQL/JSON patches (v11) will let you do:
Op 8/8/23 om 03:15 schreef Jonathan S. Katz:
Please provide your feedback no later than August 10, 2023 0:00 AoE[1].
'You us' should be
'You use'
(2x)
Erik
Op 7/21/23 om 12:33 schreef Amit Langote:
Thanks for taking a look.
Hi Amit,
Is there any chance to rebase the outstanding SQL/JSON patches, (esp.
json_query)?
Thanks!
Erik Rijkers
adable translation of that in the docs
although it might be easier to just get get rid of the term
'json_api_common_syntax'.
HTH,
Erik Rijkers
paths'
Erik Rijkers
Op 5/24/23 om 15:58 schreef Bruce Momjian:
On Wed, May 24, 2023 at 12:23:02PM +0700, John Naylor wrote:
On Wed, May 24, 2023 at 11:19 AM Bruce Momjian wrote:
Typos:
'from standbys servers' should be
'from standby servers'
'reindexedb' should be
'reindexdb'
(2x: the next line mentions,
Op 5/21/23 om 19:07 schreef Jonathan S. Katz:
On 5/19/23 12:17 AM, Jonathan S. Katz wrote:
Hi,
Attached is a draft of the release announcement for PostgreSQL 16 Beta
Please provide feedback no later than May 24, 0:00 AoE. This will give
Thanks everyone for your feedback. Here is the updated
Op 5/19/23 om 06:17 schreef Jonathan S. Katz:
Hi,
Attached is a draft of the release announcement for PostgreSQL 16 Beta
Hi,
The usual small fry:
'continues to to' should be
'continues to'
'continues to give users to the ability' should be
'continues to give users the ability to'
Op 5/7/23 om 05:37 schreef Jonathan S. Katz:
Attached is a draft of the release announcement for the upcoming update
release on May 11, 2023.
Please provide any suggestions, corrections, or notable omissions no
later than 2023-05-11 0:00 AoE.
'leak in within a' should be
'leak within a'
SCALAR or ARRAY or OBJECT is specified, the
test is whether or not the JSON is of that particular type. If WITH
UNIQUE KEYS is specified, then any object in the expression is also
tested to see if it has duplicate keys."
Erik Rijkers
--- doc/src/sgml/func.sgml.orig 2023-04-12 06:16:40.517
Op 3/29/23 om 12:27 schreef Alvaro Herrera:
On 2023-Mar-28, Erik Rijkers wrote:
In the json_arrayagg() description, it says:
'If ABSENT ON NULL is specified, any NULL values are omitted.'
That's true, but as omitting NULL values is the default (i.e., also without
that clause) maybe it's better
values are omitted unless NULL ON NULL is specified'
I've found no bugs in functionality.
Thanks,
Erik Rijkers
]', '$[*]' returning bigint[] empty object
on error);
Can you have a look?
Thanks,
Erik Rijkers
PS
Log doesn't really have anything interesting:
2023-02-20 14:57:06.073 CET 1336 LOG: server process (PID 1493) was
terminated by signal 9: Killed
2023-02-20 14:57:06.073 CET 1336 DETAIL: Failed process
, and I think I would have noticed any fails.
That system says:
OpenSSL> OpenSSL 1.0.1e-fips 11 Feb 2013
FWIW, just now I built & ran check-world for 15 and 16 with
PG_TEST_EXTRA=ssl (which I didn't use before). Both finished ok.
Erik Rijkers
On 1/15/23 12:33, Alvaro Herrera wrote:
On 2023-Jan-15, Erik Rijkers wrote:
Hello,
Logical replication sometimes gets stuck with
ERROR: int2vector has too many elements
Weird. This error comes from int2vectorin which amusingly only wants to
read up to FUNC_MAX_ARGS values in the array
someone understands what's going wrong.
Thanks,
Erik Rijkers
logrepbug.sh
Description: application/shellscript
Can we change 'convey' to 'confer' in these recent doc changes?
Maybe 'convey a privilege' isn't exactly wrong but it leaves you
wondering what exactly is meant.
Thanks,
Erik
--- doc/src/sgml/ref/createuser.sgml.orig 2023-01-05 21:37:35.803839575 +0100
+++ doc/src/sgml/ref/createuser.sgml
Op 14-12-2022 om 05:54 schreef Pavel Stehule:
Hi
fresh rebase
typo alert:
v20221214-0003-LET-command.patch contains
errmsg("target session varible is of type %s"
('varible' should be 'variable')
Erik
-level transaction IDs are'
'subtransaction ID are' should be
'subtransaction IDs are'
In xact.sgml:
'Non-virtual TransactionId (or xid)'
should be
'Non-virtual TransactionIds (or xids)'
Erik Rijkers
Op 18-11-2022 om 22:19 schreef Robert Haas:
On Fri, Nov 18, 2022 at 1:50 PM Erik Rijkers wrote:
In grant.sgml,
'actualy permisions'
looks a bit unorthodox.
Fixed that, and the other mistake Álvaro spotted, and also bumped
catversion because I forgot that earlier.
Sorry to be nagging
Op 18-11-2022 om 19:43 schreef Robert Haas:
On Fri, Nov 18, 2022 at 12:50 PM Robert Haas wrote:
Here's a rebased v3 to see what cfbot thinks.
cfbot is happy, so committed.
In grant.sgml,
'actualy permisions'
looks a bit unorthodox.
he top-level transaction is reached,'
Thanks,
Erik Rijkers
()) --> 3
This laxness occurs in all releases, and with 'millennium',
'millisecond', and 'microsecond' (at least).
Even though it's not likely to cause much real-life headaches, and I
hesitate to call it a real bug, perhaps it would be better if it could
be a bit stricter.
Thanks,
Erik Rijkers
PREPARED. Two-phase transactions
'The commands'
should be
'The commands are'
thanks,
Erik Rijkers
I plan to apply this and backpatch it to all supported versions since
these details apply to all versions. These docs should enable our users
to much better understand and monitor Postgres
Op 12-09-2022 om 16:00 schreef Erik Rijkers:
Op 12-09-2022 om 09:58 schreef Daniel Gustafsson:
On 9 Sep 2022, at 11:00, Andrew Dunstan wrote:
On Sep 9, 2022, at 5:53 PM, John Naylor
wrote:
[v4-0001-Add-include-exclude-filtering-via-file-in-pg_dump.patch]
I noticed that pg_restore
with the same filter-file that was used to produce a dump with
pg_dump --filter.
Is that as designed? It seems a bit counterintuitive. It'd be nice if
that could be fixed. Admittedly, the 'same' problem in pg_restore -t,
also less than ideal.
(A messy bashdemo below)
thanks,
Erik Rijkers
t;
# dump without filter emits no spaces
echo -ne ">"
pg_dump -F c -f plainfile3 -t table0 -table1 -d testdb2
echo "<"
-
It's probably a small thing -- but I didn't find it.
thanks,
Erik Rijkers
--
Daniel Gustafsson https://vmware.com/
Op 07-09-2022 om 03:40 schreef Jonathan S. Katz:
Hi,
I've attached a draft of the PostgreSQL 15 Beta 4 release announcement.
Please review for correctness and if there are any omissions.
Please provide feedback on the draft no later than Sep 8, 2022 0:00 AoE.
'Fixes and changes in
Op 06-09-2022 om 17:16 schreef Simon Riggs:
New chapter on transaction management, plus a few related changes.
Markup and links are not polished yet, so please comment initially on
the topics, descriptions and wording.
[xact_docs.v2.patch]
Very clear explanations, thank you.
Two typos:
In funcs.sgml, the value fed into jsonb_path_exists_tz was wrong; fixed
as attached.
(was inadvertently reverted with the big JSON revert)
Erik Rijkers--- doc/src/sgml/func.sgml.orig 2022-09-02 16:16:21.406405542 +0200
+++ doc/src/sgml/func.sgml 2022-09-02 16:17:41.751838806 +0200
@@ -16533,7
Op 02-09-2022 om 11:44 schreef David Rowley:
Over on [1], there was a question about why it wasn't possible to
create the following table:
CREATE TABLE foobar(
id BIGINT NOT NULL PRIMARY KEY,
baz VARCHAR NULL DEFAULT NULL
) PARTITION BY HASH(my_func(id));
The attached attempts to
Op 24-08-2022 om 08:37 schreef Pavel Stehule:
I fixed these.
> [v20220824-1-*.patch]
Hi Pavel,
I noticed just now that variable assignment (i.e., LET) unexpectedly
(for me anyway) cast the type of the input value. Surely that's wrong?
The documentation says clearly enough:
'The
Op 22-08-2022 om 10:27 schreef Peter Smith:
PSA new set of v2* patches.
Hi,
In the second file a small typo, I think:
"enclosed by parenthesis" should be
"enclosed by parentheses"
thanks,
Erik
Op 21-08-2022 om 09:54 schreef Pavel Stehule:
ne 21. 8. 2022 v 6:36 odesílatel Julien Rouhaud napsal:
On Sat, Aug 20, 2022 at 08:44:49PM +0200, Erik Rijkers wrote:
Op 20-08-2022 om 20:09 schreef Pavel Stehule:
should be fixed now>
Yep, all tests OK now.
Thanks!
Erik
Op 20-08-2022 om 20:09 schreef Pavel Stehule:
Hi
LET public.svar2 = (10, 20, 30);
ALTER TYPE public.svar_test_type DROP ATTRIBUTE b;
SELECT public.svar;
- svar
- (10,)
+ svar
+-
+ (10,16)
(1 row)
SELECT public.svar2;
svar2
-
(10,30)
(1 row)
I
Op 20-08-2022 om 15:41 schreef Pavel Stehule:
so 20. 8. 2022 v 15:36 odesílatel Erik Rijkers napsal:
Op 20-08-2022 om 15:32 schreef Erik Rijkers:
Op 19-08-2022 om 17:29 schreef Pavel Stehule:
make check fails as a result of the errors in the attached
session_variables.out.
Sorry
Op 20-08-2022 om 15:32 schreef Erik Rijkers:
Op 19-08-2022 om 17:29 schreef Pavel Stehule:
make check fails as a result of the errors in the attached
session_variables.out.
Sorry, that should have been this diffs file, of course (attached).
Erikdiff -U3
/home/aardvark/pg_stuff
Op 19-08-2022 om 17:29 schreef Pavel Stehule:
pá 19. 8. 2022 v 15:57 odesílatel Pavel Stehule
napsal:
Hi
I am sending fresh update
- enhanced work with composite types - now the used composite type can be
enhanced, reduced and stored value is converted to expected format
- enhancing
Op 02-08-2022 om 07:28 schreef John Naylor:
On Tue, Aug 2, 2022 at 1:05 AM Erik Rijkers <mailto:e...@xs4all.nl>> wrote:
>
> Recent typos...
The part of the sentence inside parentheses is not clear to me, before
or after the patch:
Dropping an extension causes its co
Recent typos...
--- ./doc/src/sgml/ref/drop_extension.sgml.orig 2022-08-01 19:38:18.249729884
+0200
+++ ./doc/src/sgml/ref/drop_extension.sgml 2022-08-01 19:40:33.312359069
+0200
@@ -32,7 +32,7 @@
DROP EXTENSION removes extensions from the database.
Dropping an extension causes its
ema_variable'
instead of session_variable:
-A schema_variable
--variable=schema_variable
Surely those should be changed as well.
Erik Rijkers--- ./doc/src/sgml/ref/alter_variable.sgml.orig 2022-07-22 12:18:47.905664314 +0200
+++ ./doc/src/sgml/ref/alter_variable.sgml 2022-07-22 12:34:52.928275143 +0
:374: element link: validity error : IDREF attribute
linkend references an unknown ID "catalog-pg-variable"
make: *** [Makefile:135: html-stamp] Error 4
Erik Rijkers
Regards
Pavel
On 7/14/22 17:45, Andrew Dunstan wrote:
On 2022-07-08 Fr 16:20, Andrew Dunstan wrote:
On 2022-07-08 Fr 16:03, Erik Rijkers wrote:
Hi,
Attached are a few small changes to the JSON_TABLE section in func.sgml.
The first two changes are simple typos.
Then there was this line
of that compound term, and
rewrite the explanations using only the current parameter names
(context_item, path_expression, etc).
But I wasn't sure and I haven't done any such changes in the attached.
Perhaps I'll give it a try during the weekend.
Erik Rijkers
--- ./doc/src/sgml/func.sgml.orig 2022-07
ing but that's not really the point)
Thanks,
Erik Rijkers
Op 29-06-2022 om 02:04 schreef Jonathan S. Katz:
Hi,
Attached is a draft of the release announcement for PostgreSQL 15 Beta
2. Please provide feedback on technical accuracy and if there are
glaring omissions.
Hardly 'glaring' but still:
'Multiples fixes' should be
'Multiple fixes'
Op 29-06-2022 om 15:00 schreef Amit Kapila:
On Mon, Jun 27, 2022 at 8:46 PM Andrew Dunstan wrote:
On 2022-06-26 Su 11:44, Erik Rijkers wrote:
JSON/SQL jsonpath
For example, a jsonpath string with deliberate typo 'like_regexp'
(instead of 'like_regex'):
select js
from (values (jsonb
Op 29-06-2022 om 02:04 schreef Jonathan S. Katz:
Hi,
'not advise you to run PostgreSQL 15 Beta 1'should be
'not advise you to run PostgreSQL 15 Beta 2'
Erik
to use 'invalid token', which is better:
select js
from (values (jsonb '{"a":"b"}')) as f(js)
where js @? '$ ? (@.a .= "b")';
ERROR: syntax error, unexpected invalid token at or near "=" of
jsonpath input
thanks,
Erik Rijkers
'::date;
ERROR: invalid input syntax for type date: "112-04-30 BCE"
LINE 1: select '112-04-30 BCE'::date;
The same goes for '112-04-30 AD' (works) and its CE version (errors out).
Or is this as expected?
Erik Rijkers
Best,
David.
funcs.sgml has
42 <@ '{[1,7)}'::int4multirange
and calls it true. The attached fixes that.
Included are two more changes where actual output differs a bit from
what the doc examples show.
Erik
--- doc/src/sgml/func.sgml.orig 2022-05-17 17:50:40.975410855 +0200
+++
Op 16-05-2022 om 20:53 schreef Andrew Dunstan:
On 2022-05-16 Mo 13:52, Erik Rijkers wrote:
-
2.
This example in func.sgml says it gives 't' but on my instance it
returns 'f'. Is the example correct?
jsonb_path_exists_tz('["2015-08-01 12:00:00 -05"]', '$[*] ?
(@.datetime() <
Op 16-05-2022 om 16:49 schreef Andrew Dunstan:
[sqljson-dox-rework-2.patch]
Two issues, derived from func.sgml:
-
1.
I noticed that some json functions, for instance json_object(), in their
output insert unexpected spaces before the separator-colon:
testdb=# select json_object('{a,
complicated json_table examples can be run easily.
Erik Rijkers
--
Andrew Dunstan
EDB: https://www.enterprisedb.com--- doc/src/sgml/func.sgml.orig 2022-05-14 06:32:28.564537299 +0200
+++ doc/src/sgml/func.sgml 2022-05-14 08:10:05.313313154 +0200
@@ -16287,7 +16287,7
slide' should be
'server side'
'Add extensions to define their own' should be
'Allow extensions to define their own'
And one strangely unfinished sentence:
'They also can only be'
Erik Rijkers
, bool
skip_errors,
| ^~~~
(Compiling with gcc 6.3.0 does not complain.)
Below are the two configure lines, FWIW.
Erik Rijkers
# cassert-build: no warning/note
./configure \
--prefix=/home/aardvark/pg_stuff/pg_installations/pgsql.HEAD \
--bindir=/home/aardvark/pg
Op 04-05-2022 om 21:12 schreef Andrew Dunstan:
I don't see how rowseq can be anything but 1. Each invocation of
After some further experimentation, I now think you must be right, David.
Also, looking at the DB2 docs:
https://www.ibm.com/docs/en/i/7.2?topic=data-using-json-table
Op 04-05-2022 om 13:55 schreef Andrew Dunstan:
On 2022-05-03 Tu 20:39, David G. Johnston wrote:
On Tue, May 3, 2022 at 5:27 PM Andrew Dunstan wrote:
On 2022-05-03 Tu 11:19, Erik Rijkers wrote:
> Hi
>
> I've copied some statements from the .pdf called:
>
statement (called 'table 15' in the
.pdf) as in the attached bash file. But the result is different: as
implemented by 15devel, the column rowseq is always 1. It seems to me
that that is wrong; it should count 1, 2, 3 as indeed the example-result
column in that pdf shows.
What do you think?
Er
Op 20-04-2022 om 06:54 schreef Kyotaro Horiguchi:
At Tue, 19 Apr 2022 10:55:26 -0700, Andres Freund wrote in
Hi,
On 2022-04-19 10:36:24 -0700, Andres Freund wrote:
On 2022-04-19 13:50:25 +0200, Erik Rijkers wrote:
The 12th run of statbug.sh crashed and gave a corefile.
I ran through quite
Op 19-04-2022 om 19:36 schreef Andres Freund:
Hi,
On 2022-04-19 13:50:25 +0200, Erik Rijkers wrote:
The 12th run of statbug.sh crashed and gave a corefile.
I ran through quite a few iterations by now, without reproducing :(
I guess there's some timing issue and you're hitting on your system
Op 19-04-2022 om 11:25 schreef Kyotaro Horiguchi:
Thaks Erik.
At Tue, 19 Apr 2022 07:00:30 +0200, Erik Rijkers wrote in
Op 19-04-2022 om 02:15 schreef Kyotaro Horiguchi:
Could you read tabstat, *tabstat, trans, *trans here?
To be honest I'm not sure how to, but I gave it a try:
I
Op 19-04-2022 om 02:15 schreef Kyotaro Horiguchi:
At Mon, 18 Apr 2022 10:57:02 +0200, Erikjan Rijkers wrote in
Hm. Just now I've recompiled and retried and after 5 runs got the
same crash. Then tried on another machine (also old, I'm afraid),
and built 1a8b11053 and ran the same thing. That
environment it will need some
tweaking)
Thanks,
Erik Rijkers
statbug.sh
Description: application/shellscript
Op 29-03-2022 om 12:50 schreef Matthias van de Meent:
On Tue, 29 Mar 2022 at 11:10, Kyotaro Horiguchi wrote:
At Tue, 29 Mar 2022 17:06:21 +0900 (JST), Kyotaro Horiguchi
wrote in
At Mon, 28 Mar 2022 18:36:46 +0900 (JST), Kyotaro Horiguchi
wrote in
Then, I found that portal->holdSnapshot
)
thanks,
Erik Rijkers
bugsnapshot.sh
Description: application/shellscript
know if there's anything else you see.
At this stage I think I have finished with the actual code, and I'm
concentrating on improving the docs a bit.
> [ v59 ]
FWIW, I went through func.sgml (of v59) once.
Erik Rijkers
--- doc/src/sgml/func.sgml.orig 2022-03-25 22:17:13.908660140 +0
Op 21-03-2022 om 21:13 schreef Greg Stark:
Hm. Actually... These changes were split off from the JSON_TABLE
patches? Are they still separate or have they been merged into those
other patches since? I see the JSON_TABLE thread is getting more
comments do those reviews include these patches?
The provided link
https://www.postgresql.org/docs/release/
leads to
https://www.postgresql.org/docs/release/14.2/
which gives 'Not Found' for me (Netherlands)
At least one person on IRC reports it 'works' for them but it seems
there still something wrong..
Erik Rijkers
Op 28-01-2022 om 21:27 schreef Alvaro Herrera:
MERGE, v10. I am much more comfortable with this version; I have
removed a bunch of temporary hacks and cleaned up the interactions with
table AM and executor, which is something that had been bothering me for
a while. The complete set of changes
Committed Isolation Level'. Likely
copied from the paragraph above: 'The DELETE'; but there it refers to an
earlier mention of DELETE.)
Erik Rijkers
1 - 100 of 243 matches
Mail list logo
