Home > mailing lists

Mailing lists [pgsql-bugs]

1 October

05:22 Re: BUG #19672: int8shl/int8shr Undefined Behavior on Out-of-Range Shift Amounts David Rowley
06:04 Re: BUG #19705: One NaN box makes a BRIN box_inclusion_ops index omit unrelated rows shihao zhong
06:09 Re: BUG #19728: A logical replication apply worker segfaults dereferencing a NULL `MyLogicalRepWorker->stream_filese Ajin Cherian
06:35 Re: autovacuum: automatically propagate updated parameters Masahiko Sawada
07:26 Re: autovacuum: automatically propagate updated parameters Bharath Rupireddy
08:45 Re: autovacuum: automatically propagate updated parameters Masahiko Sawada
10:11 Re: autovacuum: automatically propagate updated parameters Daniel Gustafsson
17:27 PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Vladimir Savin
18:07 Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation rahul@rhyadav.dev
19:15 Re: PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Andrey Rachitskiy
21:29 Wrong results: hashed SubPlan referenced twice after OR-qual extraction reuses a stale hash table (13 to 19beta4) Samuel Olaoye
21:31 Re: autovacuum: automatically propagate updated parameters Masahiko Sawada
22:36 Re: PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Vladimir Savin

2 October

06:17 Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup shihao zhong
06:22 Backend crash (signal 11) in pg_trgm makesign() after ALTER TABLE ... SET STORAGE on a column with a gist_trgm_ops index Thiago Bonfante
06:25 Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup David G. Johnston
06:49 Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup Michael Paquier
07:07 Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup shihao zhong
07:32 Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup Michael Paquier
08:15 Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation shihao zhong
10:00 Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation rahul@rhyadav.dev
10:33 Re: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
10:47 Re: Wrong results: hashed SubPlan referenced twice after OR-qual extraction reuses a stale hash table (13 to 19beta4) rahul@rhyadav.dev
10:57 Re: Backend crash (signal 11) in pg_trgm makesign() after ALTER TABLE ... SET STORAGE on a column with a gist_trgm_ops index Andrey Rachitskiy
11:04 Re: PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Andrey Rachitskiy
11:12 Re: PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Vladimir Savin
11:29 Re: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Jiří Kavalík
12:21 Re: BUG #19628: Uninterruptible vacuum during hash index processing mostafa nabil
14:33 Re: Backend crash (signal 11) in pg_trgm makesign() after ALTER TABLE ... SET STORAGE on a column with a gist_trgm_ops index Thiago Bonfante
21:01 Re: BUG #19701: GIN trigram index loses rows at similarity_threshold 0 Manu
21:20 Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY Nate Clark

3 October

00:55 Re: BUG #19628: Uninterruptible vacuum during hash index processing Heikki Linnakangas
01:03 BUG #19735: `jsonb_object_agg_unique_strict` drops a JSONB `null` value as if it were SQL NULL PG Bug reporting form
01:35 BUG #19736: `JSON_OBJECT ... ABSENT ON NULL` accepts invalid keys when the value is NULL PG Bug reporting form
01:36 BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses PG Bug reporting form
01:36 BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond PG Bug reporting form
01:37 BUG #19739: Parameterized first autocommit statement can have different `transaction_timestamp()` and `statement PG Bug reporting form
01:38 BUG #19740: `has_language_privilege` returns TRUE for a nonexistent language OID when the user is a superuser PG Bug reporting form
01:38 BUG #19741: `avg(double precision)` overflows on cancelling finite inputs whose mean is representable PG Bug reporting form
07:05 Re: BUG #19628: Uninterruptible vacuum during hash index processing shihao zhong
07:12 Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation shihao zhong
13:17 Subject: Re: PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Victor Rusaleev
19:17 BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" PG Bug reporting form

4 October

00:34 Re: BUG #19741: `avg(double precision)` overflows on cancelling finite inputs whose mean is representable Tom Lane
00:53 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
00:58 Re: BUG #19739: Parameterized first autocommit statement can have different `transaction_timestamp()` and `statement Tom Lane
04:00 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
08:10 BUG #19743: pgcrypto crypt(): sha-crypt rounds= silently wraps modulo 2^32 PG Bug reporting form
08:16 BUG #19744: contrib/seg output truncates to 6 significant digits, breaking dump/restore PG Bug reporting form
08:17 BUG #19745: tsquery input: 33 nested "!" raise XX000 via elog(), escaping pg_input_is_valid() PG Bug reporting form
08:18 BUG #19746: interval with INT64_MIN microseconds prints a value interval_in rejects PG Bug reporting form
08:19 BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements PG Bug reporting form
08:19 BUG #19748: tsvectorrecv accepts duplicate lexemes and position 0 that tsvectorin rejects PG Bug reporting form
08:20 BUG #19749: bpchar_ops declares equalimage although bpchar equality ignores trailing spaces PG Bug reporting form
08:23 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
08:33 BUG #19750: tsquery output omits parentheses, so the text reparses to a different value PG Bug reporting form
08:37 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" David Rowley
08:42 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
12:51 Re: BUG #19725: PostgreSQL 18.6: pg_restore read failure with io_uring, not observed with worker weijie JL
16:12 Re: Backend crash (signal 11) in pg_trgm makesign() after ALTER TABLE ... SET STORAGE on a column with a gist_trgm_ops index Kirill Reshke
16:39 Re: BUG #19740: `has_language_privilege` returns TRUE for a nonexistent language OID when the user is a superuser Laurenz Albe
16:54 Re: BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond Laurenz Albe
18:04 Issue Installing PostGIS via Stack Builder on MacBook (Apple Silicon / ARM64) – Application Buffers/Freezes Hariharan Murugesan
19:03 Re: BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond Tom Lane
19:14 Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses jian he
20:01 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
21:41 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
22:38 Re: BUG #19735: `jsonb_object_agg_unique_strict` drops a JSONB `null` value as if it were SQL NULL shihao zhong
22:39 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane

5 October

00:43 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
03:36 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
05:20 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
05:35 Re: BUG #19731: `first_value` returns an excluded peer for a nonempty `EXCLUDE TIES` frame shihao zhong
05:39 Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f shihao zhong
06:37 Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY Ayush Tiwari
06:49 Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup Michael Paquier
07:14 Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs shihao zhong
10:19 Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs Rahul
10:48 Spurious curly bracket in "CREATE FUNCTION"/"CREATE PROCEDURE" doc Lele Gaifax
12:47 Re: BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond Andrey Borodin
13:20 Re: BUG #19628: Uninterruptible vacuum during hash index processing Heikki Linnakangas
14:20 Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f Andrey Rachitskiy
16:52 BUG #19751: MIN aggregate + FETCH FIRST 1 ROW WITH TIES causes false 21000 error when index scan is forced PG Bug reporting form
17:34 Re: Issue Installing PostGIS via Stack Builder on MacBook (Apple Silicon / ARM64) – Application Buffers/Freezes Andrew Dunstan
18:10 Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs shihao zhong
18:21 Re: BUG #19751: MIN aggregate + FETCH FIRST 1 ROW WITH TIES causes false 21000 error when index scan is forced Tom Lane
19:57 Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs Rahul
20:39 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
21:24 Re: BUG #19750: tsquery output omits parentheses, so the text reparses to a different value Tom Lane
21:38 Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs shihao zhong
21:39 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
21:48 Re: BUG #19748: tsvectorrecv accepts duplicate lexemes and position 0 that tsvectorin rejects Tom Lane
22:02 Re: BUG #19745: tsquery input: 33 nested "!" raise XX000 via elog(), escaping pg_input_is_valid() Tom Lane

6 October

00:34 Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements Tom Lane
00:52 Re: BUG #19744: contrib/seg output truncates to 6 significant digits, breaking dump/restore Tom Lane
03:41 Re: Spurious curly bracket in "CREATE FUNCTION"/"CREATE PROCEDURE" doc Tom Lane
06:39 Re: BUG #19749: bpchar_ops declares equalimage although bpchar equality ignores trailing spaces Peter Geoghegan
07:22 Re: 42P16 error when dropping and adding column Fujii Masao
09:02 Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Narayanan Venkateswaran
12:21 RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
12:33 Re: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Jiří Kavalík
23:06 Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements Tom Lane
23:14 Re: autovacuum: automatically propagate updated parameters Masahiko Sawada

7 October

00:24 Re: autovacuum: automatically propagate updated parameters Zsolt Parragi
00:27 Re: BUG #19748: tsvectorrecv accepts duplicate lexemes and position 0 that tsvectorin rejects Tom Lane
03:53 Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f shihao zhong
07:52 Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated Etsuro Fujita
08:00 Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated Etsuro Fujita
09:54 Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements Laurenz Albe
12:14 Re: BUG #19733: Row not visible to a new snapshot after its transactional logical decoding message has been streamed Rahul
12:58 Re: BUG #19735: `jsonb_object_agg_unique_strict` drops a JSONB `null` value as if it were SQL NULL Dmitry Dolgov
13:08 Re: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Zhijie Hou
18:44 Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements Tom Lane