Hi,
Compiling gcc 15.1 utters these protests (at least, with
--enable-cassert) that I don't think I saw with gcc 14:
jsonb_util.c: In function ‘compareJsonbContainers’:
jsonb_util.c:301:34: warning: ‘va.type’ may be used uninitialized
[-Wmaybe-uninitialized]
301 |
Op 2/11/25 om 01:09 schreef Jonathan S. Katz:
Hi,
Attached is a draft of the 2025-02-13 update release announcement.
Please provide feedback no later than 2025-02-13 0:00 UTC.
worst cas
worst case
Erik
On 1/22/25 06:34, Amit Kapila wrote:
Doc: Update the interaction of tablesync with wal_retrieve_retry_interval.
Branch
--
master
Details
---
https://git.postgresql.org/pg/commitdiff/4a0e7314f11ee03adfe9df945598c068b4179314
Hi,
In this sentence :
"The initial data in existing subscrib
doc-build fails: a slash tumbled backwards in doc/src/sgml:
$ grep 'xref.*.\\>' *.sgml
plpgsql.sgml: (see ).
That should simply be a forward slash, of course.
Thanks,
Erik Rijkers
Op 8/1/24 om 08:12 schreef Pavel Stehule:
Hi
fresh rebase + fix format in doc
Regards
Pavel
Op 7/5/24 om 14:35 schreef Amit Langote:
Hi Jian,
Thanks for the reviews.
> [v3-0001-SQL-JSON-Various-improvements-to-SQL-JSON-query-f.patch]
i.e., from the patch for doc/src/sgml/func.sgml
Small changes:
4x:
'a SQL' should be
'an SQL'
('a SQL' does never occur in the docs; it's alwa
ntroduces'; just not both...)
Thanks,
Erik Rijkers
it might work keep the list smaller.
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
@@ -18
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 with
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 wro
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
> [v24-0001-A
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 S
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
/home/aardvark/pg_stuff/pg_sandbox/pgsql.json_table/src
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 adress
:
-- 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 forg
; see 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 ro
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 that
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]}]}',
'$.a[*].a?(@
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":
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 co
in the fullness of Knowledge of the manual. Yes, 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
ot;All use of json*() functions preclude 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
l run fine.
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)
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 Replicatio
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 and
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
-- &#x
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:
sel
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
, we might need a readable 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
)
'SQL JSON paths' should be
'SQL/JSON 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 t
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'
'pg_
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'
Er
of a specified type. If 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.ori
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) ma
it's better to say:
'Any NULL values are omitted unless NULL ON NULL is specified'
I've found no bugs in functionality.
Thanks,
Erik Rijkers
'[3,4]', '$[*]' 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 13
include a make check, 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
2.2.0.
I hope 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 20
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
'Only top-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
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.
I
remember well how it confused me, many years ago. Better, IMHO:
'Once the top-level transaction is reached,'
Thanks,
Erik Rijkers
x from now()) --> 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
MMIT PREPARED and
+ ROLLBACK 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 us
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
;"
# 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 PostgreSQ
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:
'n
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 c
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 result
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 h
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 find_com
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
7;schema_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.92
tgres.sgml: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
o remove all uses 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
-
'solved' by casting 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'
Pleas
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
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
some improvement can be thought of?
Similar messages in release 14 seem 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
elect '112-04-30 BCE'::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
+++ doc/src/sgml/func.sgml
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"]&#x
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, 1,
ble so that the more 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
x27;Previously the actual schema'
'inforcement' should be
'enforcement'
(surely?)
'server 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 create_placeholders, 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 \
-
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
(s
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:
a and 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
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 y
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:
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 is
ons or not)
thanks,
Erik Rijkers
bugsnapshot.sh
Description: application/shellscript
1 - 100 of 251 matches
Mail list logo
