Mailing lists [pgsql-bugs]

2 April

• 14:18   Re: BUG #19382: Server crash at __nss_database_lookup Andrey Borodin
• 16:04   BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) PG Bug reporting form
• 16:54   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Andres Freund
• 17:06   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Adrian Mönnich
• 17:27   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Andres Freund
• 17:49   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Adrian Mönnich
• 21:12   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Tomas Vondra
• 22:00   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Tomas Vondra

3 April

• 01:34   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Tomas Vondra
• 01:43   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Tom Lane
• 02:14   Re: BUG #19382: Server crash at __nss_database_lookup surya poondla
• 06:13   Re:Re: Re: FDW connection drops with "Connection timed out" during async append query due to TCP receive buffer filling up jiye
• 10:17   pg_plan_advice fails when NestLoop outer side is Sort over FunctionScan Andrei Lepikhov
• 10:24   RE: BUG #19360: Bug Report: Logical Replication initial sync fails with "conflict=update_origin_differs" PG12 toPG18 Zhijie Hou (Fujitsu)

4 April

• 15:42   Re: BUG #19382: Server crash at __nss_database_lookup Andrey Borodin
• 17:45   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Tomas Vondra
• 19:41   Re: array_agg(anyarray) silently produces corrupt results with parallel workers when inputs mix NULL and non-NULL array elements Tom Lane
• 21:52   Re: pg_plan_advice fails when NestLoop outer side is Sort over FunctionScan Lukas Fittl
• 23:56   Re: pg_plan_advice fails when NestLoop outer side is Sort over FunctionScan Andrei Lepikhov

5 April

• 14:39   BUG #19450: Where is checksum_block.inc.c after master install? PG Bug reporting form
• 15:41   Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table Tim McLaughlin

6 April

• 04:16   Re: BUG #19437: temp_tablespaces doesn't work inside a cursor? Dmitriy Kuzmin
• 05:43   Re: BUG #19450: Where is checksum_block.inc.c after master install? John Naylor
• 05:46   Re: BUG #19437: temp_tablespaces doesn't work inside a cursor? Tom Lane
• 05:50   Re: BUG #19450: Where is checksum_block.inc.c after master install? Tom Lane
• 05:57   Re: BUG #19450: Where is checksum_block.inc.c after master install? John Naylor
• 06:07   Re: BUG #19450: Where is checksum_block.inc.c after master install? Tom Lane
• 15:04   Re: array_agg(anyarray) silently produces corrupt results with parallel workers when inputs mix NULL and non-NULL array elements Dmytro Astapov
• 20:16   Re: array_agg(anyarray) silently produces corrupt results with parallel workers when inputs mix NULL and non-NULL array elements Tom Lane
• 20:26   BUG #19451: In postgreSQL v13 For 1000 tables how to update from rrn column to GUID. Each table more than 2crore PG Bug reporting form

7 April

• 11:13   RE: BUG #19360: Bug Report: Logical Replication initial sync fails with "conflict=update_origin_differs" PG12 toPG18 Zhijie Hou (Fujitsu)
• 11:53   Re: BUG #19416: Backend SIGSEGV in ExecShutdownHashJoin/ExecHashTableDetach/dsa_free Chris Hofstaedtler
• 11:56   Re: BUG #19450: Where is checksum_block.inc.c after master install? John Naylor
• 18:18   Re: BUG #19451: In postgreSQL v13 For 1000 tables how to update from rrn column to GUID. Each table more than 2crore Bruce Momjian

8 April

• 02:27   BUG #19452: heap-buffer-overflow in `pg_basebackup --format=tar --gzip` PG Bug reporting form
• 05:06   Re: BUG #19416: Backend SIGSEGV in ExecShutdownHashJoin/ExecHashTableDetach/dsa_free Michael Paquier
• 12:42   Re: BUG #19405: Assertion in eval_windowaggregates() fails due to integer overflow Richard Guo
• 21:59   Re: BUG #19452: heap-buffer-overflow in `pg_basebackup --format=tar --gzip` Tom Lane

9 April

• 07:24   Re: BUG #19382: Server crash at __nss_database_lookup surya poondla
• 18:27   BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Fredrik Widlert
• 21:13   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Matheus Alcantara

10 April

• 02:39   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Amit Langote
• 06:19   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Junwang Zhao
• 07:42   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Amit Langote
• 09:21   Re: BUG #19422: Malformed raius packet Michael Paquier
• 09:32   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Amit Langote
• 10:29   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Fredrik Widlert
• 11:05   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Amit Langote
• 12:13   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Amit Langote
• 12:24   Re: BUG #19405: Assertion in eval_windowaggregates() fails due to integer overflow Richard Guo
• 15:42   Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns Matheus Alcantara

11 April

• 04:55   Re: BUG #19006: Assert(BufferIsPinned) in BufferGetBlockNumber() is triggered for forwarded buffer Thomas Munro
• 05:22   Re: BUG #19006: Assert(BufferIsPinned) in BufferGetBlockNumber() is triggered for forwarded buffer Tom Lane

12 April

• 10:05   Re: Re: Re: FDW connection drops with "Connection timed out" during async append query due to TCP receive buffer filling up Etsuro Fujita
• 18:45   BUG #19454: PL/pgSQL mishandling jsonb attribute reference PG Bug reporting form

13 April

• 15:48   BUG #19455: ALTER TABLE RENAME will rename a sequence PG Bug reporting form
• 17:10   Re: BUG #19454: PL/pgSQL mishandling jsonb attribute reference David G. Johnston
• 17:12   Re: BUG #19454: PL/pgSQL mishandling jsonb attribute reference Tom Lane
• 17:22   Re: BUG #19455: ALTER TABLE RENAME will rename a sequence Tom Lane
• 17:23   Re: BUG #19455: ALTER TABLE RENAME will rename a sequence David G. Johnston
• 20:24   Re: BUG #19006: Assert(BufferIsPinned) in BufferGetBlockNumber() is triggered for forwarded buffer Michael Paquier

14 April

• 09:30   Re: BUG #19354: JOHAB rejects valid byte sequences Thomas Munro
• 11:50   Re: BUG #19354: JOHAB rejects valid byte sequences Heikki Linnakangas
• 13:47   Re: BUG #19354: JOHAB rejects valid byte sequences Henson Choi
• 14:53   Two bugs around ALTER TYPE Andrey Borodin

15 April

• 02:49   Re: BUG #19382: Server crash at __nss_database_lookup surya poondla
• 04:20   Re: BUG #19354: JOHAB rejects valid byte sequences Henson Choi
• 04:30   Re: BUG #19006: Assert(BufferIsPinned) in BufferGetBlockNumber() is triggered for forwarded buffer Xuneng Zhou
• 04:49   Re: BUG #19354: JOHAB rejects valid byte sequences Thomas Munro
• 05:06   Re: BUG #19354: JOHAB rejects valid byte sequences Tom Lane
• 07:25   Re: BUG #19354: JOHAB rejects valid byte sequences Henson Choi
• 08:57   Re: BUG #19354: JOHAB rejects valid byte sequences Henson Choi
• 09:59   Re: BUG #19354: JOHAB rejects valid byte sequences Thomas Munro
• 11:20   MergeJoin fails on incomplete btree opfamily definition Andrei Lepikhov
• 13:57   Bug in CREATE TABLE .. LIKE .. INCLUDING STATISTICS? Julien Tachoires
• 14:17   BUG #19456: # Unit-Labeling Issue: `pg_size_pretty()` Incorrectly Labels Binary Units as Decimal Units PG Bug reporting form
• 14:59   patroni-4.1.1-1PGDG.rhel9.7.noarch.rpm missing in https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-9-x86_64/ SIEBERT Florent
• 15:48   TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Andrei Lepikhov
• 18:19   Re: BUG #19456: # Unit-Labeling Issue: `pg_size_pretty()` Incorrectly Labels Binary Units as Decimal Units David G. Johnston
• 18:55   PostgreSQL 17: Bug in libpq when libpq is dlopened/closed multiple times Daniel Schreiber
• 21:56   BUG: PL/pgSQL FOREACH misparses variable named "slice" with SLICE clause Leendert Gravendeel
• 23:50   Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Masahiko Sawada

16 April

• 07:53   Re: BUG #19354: JOHAB rejects valid byte sequences Tatsuo Ishii
• 08:25   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Thomas Munro
• 09:04   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Richard Guo
• 10:13   Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Andrei Lepikhov
• 10:44   Re: Bug in CREATE TABLE .. LIKE .. INCLUDING STATISTICS? Srinath Reddy Sadipiralla
• 11:11   Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Masahiko Sawada
• 11:26   Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Andrei Lepikhov
• 15:00   Re: BUG #19382: Server crash at __nss_database_lookup Andrey Borodin
• 20:58   Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Masahiko Sawada
• 21:52   Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) Tomas Vondra

17 April

• 02:20   Re: BUG #19382: Server crash at __nss_database_lookup surya poondla
• 06:58   Re: Inconsistent increment of pg_stat_database.xact_rollback with logical replication Nikolay Samokhvalov
• 07:21   BUG #19457: RE: pgp_sym_encrypt silently accepts non-FIPS ciphers (bf, cast5, 3des) when OpenSSL is in FIPS mod PG Bug reporting form
• 09:57   Re: BUG #19382: Server crash at __nss_database_lookup Andrey Borodin
• 14:20   BUG #19458: OOM killer in jsonb_path_exists_opr (@?) with malformed JSONPath containing non-existent variables PG Bug reporting form
• 18:16   Re: BUG: PL/pgSQL FOREACH misparses variable named "slice" with SLICE clause Tom Lane
• 18:17   Re: BUG: PL/pgSQL FOREACH misparses variable named "slice" with SLICE clause David G. Johnston
• 22:14   Re: PostgreSQL 17: Bug in libpq when libpq is dlopened/closed multiple times Jacob Champion

18 April

• 00:26   Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Andrei Lepikhov

19 April

• 20:57   BUG #19460: FULL JOIN rewriting issue on empty queries PG Bug reporting form

20 April

• 00:10   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Tom Lane
• 04:12   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Richard Guo
• 04:26   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Tom Lane
• 05:17   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Richard Guo
• 05:32   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Tom Lane
• 05:51   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Richard Guo
• 11:29   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Amit Langote
• 12:05   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Amit Langote
• 12:29   BUG #19461: MERGE with EXISTS subquery referencing USING clause alias fails with "variable not found in subplan PG Bug reporting form
• 12:34   BUG #19462: MERGE on partitioned table with INSERT DEFAULT VALUES fails with "iso-8859-1 action in MERGE WHEN clau PG Bug reporting form
• 12:42   BUG #19463: Server crash (Assertion failure) when using MERGE statement in CTE PG Bug reporting form
• 12:45   BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments PG Bug reporting form
• 16:38   Re: BUG #19458: OOM killer in jsonb_path_exists_opr (@?) with malformed JSONPath containing non-existent variables Andrey Rachitskiy
• 17:56   Re: BUG #19461: MERGE with EXISTS subquery referencing USING clause alias fails with "variable not found in subplan Laurenz Albe
• 22:01   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Tom Lane
• 22:23   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Tom Lane

21 April

• 01:40   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Tom Lane
• 02:04   Re: BUG #19460: FULL JOIN rewriting issue on empty queries Richard Guo
• 03:57   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Richard Guo
• 04:12   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Richard Guo
• 05:30   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Tom Lane
• 06:20   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Richard Guo
• 06:57   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Amit Langote
• 08:45   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Richard Guo
• 10:40   Re: BUG #19460: FULL JOIN rewriting issue on empty queries François Jehl
• 15:20   RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments Hayato Kuroda (Fujitsu)
• 15:35   回复：RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments 飞鱼
• 16:00   RE: 回复：RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments Hayato Kuroda (Fujitsu)
• 16:11   回复：RE: 回复：RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments 飞鱼
• 17:04   Re: BUG #19457: RE: pgp_sym_encrypt silently accepts non-FIPS ciphers (bf, cast5, 3des) when OpenSSL is in FIPS mod Daniel Gustafsson
• 18:19   Re: Bug in CREATE TABLE .. LIKE .. INCLUDING STATISTICS? Andrew Dunstan
• 18:56   Re: Bug in CREATE TABLE .. LIKE .. INCLUDING STATISTICS? Srinath Reddy Sadipiralla
• 20:00   to_char() vs. long numeric formatting strings from locale Tom Lane
• 20:32   Potential buffer overrun in spell.c's CheckAffix() Tom Lane

22 April

• 01:35   Re: Potential buffer overrun in spell.c's CheckAffix() Tom Lane
• 14:57   Re: Potential buffer overrun in spell.c's CheckAffix() Andrey Borodin
• 14:58   Re: Bug in CREATE TABLE .. LIKE .. INCLUDING STATISTICS? Ayush Tiwari
• 16:44   Re: Potential buffer overrun in spell.c's CheckAffix() Tom Lane
• 17:18   to_date()/to_timestamp() silently accept month=0 and day=0 Ayush Tiwari
• 17:50   Re: Potential buffer overrun in spell.c's CheckAffix() Tom Lane
• 18:10   Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables Alexander Korotkov
• 19:51   Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Masahiko Sawada
• 20:23   Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c" Andrei Lepikhov

23 April

• 03:55   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Richard Guo
• 07:17   Re: BUG #19382: Server crash at __nss_database_lookup surya poondla
• 09:51   Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34  Michael Paquier
• 10:57   Re: to_date()/to_timestamp() silently accept month=0 and day=0 Michael Paquier
• 11:11   Re: to_date()/to_timestamp() silently accept month=0 and day=0 Daniel Gustafsson
• 11:26   Re: to_date()/to_timestamp() silently accept month=0 and day=0 Ayush Tiwari
• 11:26   Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables Tender Wang
• 12:58   Re: Potential buffer overrun in spell.c's CheckAffix() Andrey Borodin
• 16:01   Please subscribe fahar abbas
• 16:04   Re: Please subscribe David G. Johnston