Mailing lists [pgsql-bugs]

1 September 2023

• 04:08   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Michael Paquier
• 05:56   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Nathan Bossart
• 06:31   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Michael Paquier
• 13:34   Error on help in /src/bin/pg_basebackup/pg_basebackup.c Romain MAZIÈRE
• 13:50   Re: Error on help in /src/bin/pg_basebackup/pg_basebackup.c Michael Paquier
• 14:00   Re: Error on help in /src/bin/pg_basebackup/pg_basebackup.c Romain MAZIÈRE
• 15:02   Re: Error on help in /src/bin/pg_basebackup/pg_basebackup.c Alvaro Herrera
• 15:13   Re: Error on help in /src/bin/pg_basebackup/pg_basebackup.c Romain MAZIÈRE
• 15:25   Re: Error on help in /src/bin/pg_basebackup/pg_basebackup.c Alvaro Herrera
• 18:20   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Nathan Bossart
• 19:55   Re: Fwd: BUG #18016: REINDEX TABLE failure Nathan Bossart
• 23:41   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Tom Lane

2 September 2023

• 03:08   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Michael Paquier
• 04:29   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 14:51   Re: BUG #17928: Standby fails to decode WAL on termination of primary Sergei Kornilov
• 16:00   Re: BUG #17893: Assert failed in heap_update()/_delete() when FK modiified by RI trigger in non-read-committed xact Alexander Lakhin
• 18:21   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Nathan Bossart

3 September 2023

• 02:42   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 08:43   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 14:21   Re: BUG #17928: Standby fails to decode WAL on termination of primary Sergei Kornilov

4 September 2023

• 02:09   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Michael Paquier
• 04:55   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Will Mortensen
• 06:01   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Richard Guo
• 06:20   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 06:54   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 09:35   Re: BUG #17950: Incorrect memory access in gtsvector_picksplit() Michael Paquier
• 10:17   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 10:28   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 10:43   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 11:42   BUG #18080: to_tsvector fails for long text input PG Bug reporting form
• 12:12   BUG #18081: Spurious "function with OID ###### does not exist" error PG Bug reporting form
• 17:00   Re: BUG #17950: Incorrect memory access in gtsvector_picksplit() Alexander Lakhin
• 17:36   BUG #18082: coredump during initdb PG Bug reporting form
• 18:20   Re: BUG #18082: coredump during initdb Tom Lane
• 18:30   Re: BUG #18081: Spurious "function with OID ###### does not exist" error Tom Lane
• 18:55   UPDATE mentions the RETURNING * syntax but does not mention RETURNING * INTO ... James Stuart
• 20:04   BUG #18083: not compile PostgreSQL module in Qt with GCC 11.2 compiler PG Bug reporting form
• 20:55   BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions PG Bug reporting form

5 September 2023

• 00:00   Re: UPDATE mentions the RETURNING * syntax but does not mention RETURNING * INTO ... Tom Lane
• 00:12   Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions David Rowley
• 04:51   Re: BUG #18083: not compile PostgreSQL module in Qt with GCC 11.2 compiler Laurenz Albe
• 05:04   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Tom Lane
• 05:25   Re: BUG #18083: not compile PostgreSQL module in Qt with GCC 11.2 compiler Thomas Munro
• 05:37   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Richard Guo
• 06:19   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 06:58   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 07:13   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 07:58   Re: BUG #17950: Incorrect memory access in gtsvector_picksplit() Michael Paquier
• 08:31   EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery Lepikhov Andrei
• 10:33   Re: BUG #18082: coredump during initdb Duke Astar
• 11:57   Re: BUG #18083: not compile PostgreSQL module in Qt with GCC 11.2 compiler Thomas Munro
• 12:32   BUG #18085: Error in documentation PG Bug reporting form
• 12:45   Re: pg_dump assertion failure with "-n pg_catalog" Peter Eisentraut
• 12:52   Re: BUG #18083: not compile PostgreSQL module in Qt with GCC 11.2 compiler Navadvipa Chandra das
• 13:21   Re: BUG #18082: coredump during initdb John Naylor
• 13:59   BUG #18086: compilation failed due to epoll_create1 not present PG Bug reporting form
• 14:01   Re: BUG #18082: coredump during initdb Duke Astar
• 14:31   Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila
• 14:51   Re: BUG #18086: compilation failed due to epoll_create1 not present Daniel Gustafsson
• 14:57   Re: BUG #18081: Spurious "function with OID ###### does not exist" error Branko Radovanovic
• 15:55   Re: BUG #18083: not compile PostgreSQL module in Qt with GCC 11.2 compiler Daniel Gustafsson
• 16:08   BUG #18087: pg_visibility: false positives in pg_check_visible PG Bug reporting form
• 16:12   Re: BUG #18087: pg_visibility: false positives in pg_check_visible huyajun
• 16:14   Re: BUG #18085: Error in documentation Daniel Gustafsson
• 16:21   BUG #18088: Table Corruption Issues Arising from Abrupt Server Shutdown During PostgreSQL 10.20 to 14.7 Migratio PG Bug reporting form
• 16:22   BUG #18089: Orphaned Rows During PostgreSQL Data Migration PG Bug reporting form
• 16:26   Re: BUG #18086: compilation failed due to epoll_create1 not present Duke Astar
• 18:18   Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions Bruce Momjian
• 20:44   Re: BUG #18088: Table Corruption Issues Arising from Abrupt Server Shutdown During PostgreSQL 10.20 to 14.7 Migratio David G. Johnston
• 23:23   BUG #18090: Encountering Toast Table Corruption and Missing Chunk Number Error During PostgreSQL Data Migration PG Bug reporting form

6 September 2023

• 01:33   Re: pg_dump assertion failure with "-n pg_catalog" Jeff Davis
• 06:39   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Lepikhov Andrei
• 07:13   Re: BUG #18089: Orphaned Rows During PostgreSQL Data Migration David Rowley
• 09:55   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Richard Guo
• 10:14   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Lepikhov Andrei
• 11:08   Re: BUG #18090: Encountering Toast Table Corruption and Missing Chunk Number Error During PostgreSQL Data Migration Laurenz Albe
• 19:57   Re: BUG #18046: stats collection behaviour change is affecting the usability of information. Bruce Momjian
• 20:06   Re: BUG #18046: stats collection behaviour change is affecting the usability of information. Bruce Momjian
• 20:40   Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions Git Queries
• 20:41   Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions Git Queries
• 21:02   Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions Bruce Momjian

7 September 2023

• 03:26   Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions David Rowley
• 04:00   Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions Bruce Momjian
• 04:35   FW: query pg_stat_ssl hang 100%cpu  James Pang (chaolpan)
• 07:04   Re: FW: query pg_stat_ssl hang 100%cpu Michael Paquier
• 08:12   Re: BUG #18046: stats collection behaviour change is affecting the usability of information. Kyotaro Horiguchi
• 08:16   Re: BUG #18046: stats collection behaviour change is affecting the usability of information. Kyotaro Horiguchi
• 08:26   BUG #18091: Unexpected Result by enable_material PG Bug reporting form
• 08:52   BUG #18092: Unexpected Result by enable_seqscan PG Bug reporting form
• 10:30   Re: BUG #18091: Unexpected Result by enable_material Francisco Olarte
• 10:35   Re: BUG #18092: Unexpected Result by enable_seqscan Francisco Olarte
• 10:51   Re: BUG #18091: Unexpected Result by enable_material Richard Guo
• 11:25   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Lepikhov Andrei
• 11:46   RE: FW: query pg_stat_ssl hang 100%cpu James Pang (chaolpan)
• 11:54   RE: FW: query pg_stat_ssl hang 100%cpu James Pang (chaolpan)
• 12:31   Re: FW: query pg_stat_ssl hang 100%cpu Thomas Munro
• 12:38   RE: FW: query pg_stat_ssl hang 100%cpu James Pang (chaolpan)
• 12:46   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Michael Paquier
• 12:54   RE: FW: query pg_stat_ssl hang 100%cpu James Pang (chaolpan)
• 13:01   Re: FW: query pg_stat_ssl hang 100%cpu Thomas Munro
• 13:31   RE: FW: query pg_stat_ssl hang 100%cpu James Pang (chaolpan)
• 13:36   Re: FW: query pg_stat_ssl hang 100%cpu Thomas Munro
• 13:39   RE: FW: query pg_stat_ssl hang 100%cpu James Pang (chaolpan)
• 13:59   Re: FW: query pg_stat_ssl hang 100%cpu Thomas Munro
• 14:05   Re: BUG #18092: Unexpected Result by enable_seqscan David Rowley
• 15:10   RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Zhijie Hou (Fujitsu)
• 18:56   BUG #18094: max max_connections cannot be set PG Bug reporting form
• 19:07   Re: BUG #18094: max max_connections cannot be set David G. Johnston
• 19:25   Re: BUG #18094: max max_connections cannot be set Tom Lane
• 19:44   BUG #18095: Unintended non-SSL connection attempt by psql cli command after a failed password authentication PG Bug reporting form
• 20:17   Re: BUG #18095: Unintended non-SSL connection attempt by psql cli command after a failed password authentication Tom Lane
• 23:50   Re: BUG #18095: Unintended non-SSL connection attempt by psql cli command after a failed password authentication Laurenz Albe

8 September 2023

• 02:45   Re: FW: query pg_stat_ssl hang 100%cpu Thomas Munro
• 03:26   BUG #18096: In edge-triggered epoll and kqueue, PQconsumeInput/PQisBusy are insufficient for correct async ops. PG Bug reporting form
• 05:48   Re: FW: query pg_stat_ssl hang 100%cpu Michael Paquier
• 06:47   BUG #18097: Immutable expression not allowed in generated at PG Bug reporting form
• 07:25   Re: BUG #18094: max max_connections cannot be set Nikolay Samokhvalov
• 07:55   Re: BUG #18094: max max_connections cannot be set David G. Johnston
• 09:28   BUG #18098: Console code page issue Postgresql 14.7 PG Bug reporting form
• 09:32   Re: BUG #18098: Console code page issue Postgresql 14.7 Gokul Krishnan
• 09:36   BUG #18099: ERROR: could not access status of transaction 4007513275 PG Bug reporting form
• 09:47   Re: BUG #18098: Console code page issue Postgresql 14.7 Laurenz Albe
• 11:03   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Richard Guo
• 13:21   Re: BUG #18098: Console code page issue Postgresql 14.7 Gokul Krishnan
• 16:57   Re: BUG #18094: max max_connections cannot be set Tom Lane
• 17:04   Re: BUG #18094: max max_connections cannot be set Nikolay Samokhvalov
• 17:33   Re: BUG #18096: In edge-triggered epoll and kqueue, PQconsumeInput/PQisBusy are insufficient for correct async ops. Tom Lane
• 18:11   Re: BUG #18097: Immutable expression not allowed in generated at David G. Johnston
• 18:18   Re: BUG #18099: ERROR: could not access status of transaction 4007513275 Carlos Alves
• 18:22   Re: BUG #18097: Immutable expression not allowed in generated at James Keener
• 18:25   Re: BUG #18094: max max_connections cannot be set David G. Johnston
• 19:08   Re: BUG #18097: Immutable expression not allowed in generated at Tom Lane
• 20:45   Re: BUG #18099: ERROR: could not access status of transaction 4007513275 Laurenz Albe

9 September 2023

• 00:10   Re: About #13489, array dimensions and CREATE TABLE ... LIKE Bruce Momjian
• 05:29   BUG #18101: 'RAISE LOG ...' with omitted trailing ';' does not throw syntax error in certain situations PG Bug reporting form
• 11:00   Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize Alexander Lakhin
• 14:39   Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila
• 23:42   [16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op Jeff Davis
• 23:54   Re: BUG #18101: 'RAISE LOG ...' with omitted trailing ';' does not throw syntax error in certain situations Tom Lane

10 September 2023

• 15:57   BUG #18103: bugs of concurrent merge into when use different join plan PG Bug reporting form
• 18:45   [16+] subscription can end up in inconsistent state Jeff Davis

11 September 2023

• 01:37   Re: FW: query pg_stat_ssl hang 100%cpu Thomas Munro
• 01:47   Re: FW: query pg_stat_ssl hang 100%cpu Michael Paquier
• 06:15   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Lepikhov Andrei
• 06:26   RE: [16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op Zhijie Hou (Fujitsu)
• 06:29   Re: [16+] subscription can end up in inconsistent state Amit Kapila
• 09:28   Re: EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery Richard Guo
• 12:03   Re: EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery Lepikhov Andrei
• 14:49   Re: [16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op Amit Kapila
• 17:55   BUG #18105: ogr_fdw_15 incompatible with latest gdal36-libs PG Bug reporting form
• 19:27   Re: [16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op Alvaro Herrera
• 20:25   Re: BUG #18105: ogr_fdw_15 incompatible with latest gdal36-libs Laurenz Albe
• 22:00   Re: [16+] subscription can end up in inconsistent state Jeff Davis

12 September 2023

• 04:01   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 04:40   RE: [16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op Zhijie Hou (Fujitsu)
• 05:08   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 05:11   Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Andres Freund
• 05:12   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 12:06   Re: BUG #18098: Console code page issue Postgresql 14.7 Gokul Krishnan
• 13:09   Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila
• 13:43   Re: [16+] subscription can end up in inconsistent state Amit Kapila
• 19:59   "as name" is shadowed by name "value" when selecting with "left join jsonb_array_elements(d.items) as item on true" Aleksandr Vinokurov
• 20:55   Re: "as name" is shadowed by name "value" when selecting with "left join jsonb_array_elements(d.items) as item on true" Tom Lane
• 22:03   Re: "as name" is shadowed by name "value" when selecting with "left join jsonb_array_elements(d.items) as item on true" Aleksandr Vinokurov
• 23:33   Re: [16+] subscription can end up in inconsistent state Jeff Davis

13 September 2023

• 00:25   PostgreSQL 12.15 query performance problem Ринат Мухтаров
• 06:02   Re: BUG #18098: Console code page issue Postgresql 14.7 Kyotaro Horiguchi
• 06:11   Re: FW: query pg_stat_ssl hang 100%cpu Thomas Munro
• 07:20   Re: BUG #18046: stats collection behaviour change is affecting the usability of information. Andres Freund
• 07:51   Re: [16+] subscription can end up in inconsistent state Amit Kapila
• 10:24   the same time value return different values，is it a problem 姜梦洋
• 11:11   Re: the same time value return different values，is it a problem 姜梦洋
• 13:42   Re: [16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op Amit Kapila
• 16:24   Re: Memory leak on subquery as scalar operand Daniel Gustafsson
• 17:17   Re: the same time value return different values，is it a problem Tom Lane
• 20:06   Re: BUG #18098: Console code page issue Postgresql 14.7 Gokul Krishnan

14 September 2023

• 00:53   Segmentation Fault Robert Sanford
• 01:31   Re: Segmentation Fault Robert Sanford
• 02:58   Re: Segmentation Fault Tom Lane
• 05:52   Re: Segmentation Fault Laurenz Albe
• 06:30   Re: BUG #18046: stats collection behaviour change is affecting the usability of information. Andres Freund
• 07:58   Re: EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery Lepikhov Andrei
• 10:28   BUG #18107: "policy ... for table ... already exists" errors when restore postgres database from dump PG Bug reporting form
• 10:29   Re: BUG #18103: bugs of concurrent merge into when use different join plan David Rowley
• 11:19   BUG #18108: server process was terminated by signal 11: Segmentation fault PG Bug reporting form
• 11:43   BUG #18109: enable_partitionwise_aggregate does not apply when inserting or updating PG Bug reporting form
• 14:42   Re: BUG #18109: enable_partitionwise_aggregate does not apply when inserting or updating David Rowley
• 14:49   Re: BUG #18108: server process was terminated by signal 11: Segmentation fault David Rowley
• 16:27   Re: Segmentation Fault Robert Sanford
• 16:57   Re: BUG #18109: enable_partitionwise_aggregate does not apply when inserting or updating Stephen Flavin
• 17:14   Re: BUG #18109: enable_partitionwise_aggregate does not apply when inserting or updating David Rowley
• 22:29   Re: Segmentation Fault Robert Sanford
• 23:57   Re: Segmentation Fault Euler Taveira

15 September 2023

• 03:17   Re: Segmentation Fault Tom Lane
• 12:00   BUG #18111: Query hangs when trying to INSERT empty string into NOT NULL table PG Bug reporting form
• 13:00   Re: BUG #18111: Query hangs when trying to INSERT empty string into NOT NULL table David Rowley
• 13:11   Re: BUG #18108: server process was terminated by signal 11: Segmentation fault Jay
• 13:19   Re: BUG #18108: server process was terminated by signal 11: Segmentation fault David Rowley
• 13:47   BUG #18112: pgstattuple of sequence failed PG Bug reporting form
• 14:37   Re: BUG #18111: Query hangs when trying to INSERT empty string into NOT NULL table Julien Rouhaud
• 14:41   Re: BUG #18080: to_tsvector fails for long text input Alvaro Herrera
• 16:53   Re: BUG #18080: to_tsvector fails for long text input Tom Lane
• 19:23   Re: Segmentation Fault Robert Sanford
• 19:58   Re: the same time value return different values，is it a problem Dave Cramer
• 20:00   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Alexander Lakhin
• 21:38   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Tom Lane

16 September 2023

• 01:07   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 03:02   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 03:20   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 07:13   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 09:00   Re: BUG #17928: Standby fails to decode WAL on termination of primary Alexander Lakhin
• 11:27   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Michael Paquier
• 15:35   BUG #18114: FULL JOIN is replaced by LEFT JOIN in plan PG Bug reporting form
• 16:32   Re: BUG #18114: FULL JOIN is replaced by LEFT JOIN in plan Wèi Cōngruì
• 17:34   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Tom Lane
• 20:00   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Alexander Lakhin
• 20:06   Re: BUG #18114: FULL JOIN is replaced by LEFT JOIN in plan Ilya Anfimov

17 September 2023

• 02:50   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Michael Paquier
• 03:02   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Tom Lane
• 04:03   Re: BUG #18114: FULL JOIN is replaced by LEFT JOIN in plan Wèi Cōngruì
• 04:50   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Michael Paquier
• 04:58   Re: BUG #18108: server process was terminated by signal 11: Segmentation fault Michael Paquier
• 05:03   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Tom Lane
• 05:06   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Michael Paquier
• 07:00   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Alexander Lakhin
• 07:25   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Michael Paquier
• 14:33   Re: the same time value return different values，is it a problem Dave Cramer
• 23:46   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro

18 September 2023

• 02:36   Re: group by true now errors with non-integer constant in GROUP BY David Rowley
• 03:00   Re: group by true now errors with non-integer constant in GROUP BY Tom Lane
• 03:22   Re: group by true now errors with non-integer constant in GROUP BY David Rowley
• 05:23   Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause Richard Guo
• 09:44   Re: BUG #18103: bugs of concurrent merge into when use different join plan Richard Guo
• 12:00   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Alexander Lakhin
• 13:13   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Michael Paquier
• 13:14   BUG #18115: pg_restore of extensions does not respect dependencies PG Bug reporting form
• 14:46   BUG #18116: This is definitiv a BUG in INOUT parameter in stored procedures in Postgres 12.16 PG Bug reporting form
• 16:58   Re: BUG #18115: pg_restore of extensions does not respect dependencies Tom Lane
• 17:10   Re: BUG #18116: This is definitiv a BUG in INOUT parameter in stored procedures in Postgres 12.16 Tom Lane
• 17:16   Re: BUG #6052: ADD COLUMN - ERROR: tables can have at most 1600 columns Juris Kaminskis
• 18:22   Re: BUG #6052: ADD COLUMN - ERROR: tables can have at most 1600 columns David G. Johnston
• 19:36   Installing PostgreSQL 16 on FreeBSD 13.0 Philip Muturura

19 September 2023

• 00:32   Re: Installing PostgreSQL 16 on FreeBSD 13.0 Thomas Munro
• 03:16   Re: BUG #18115: pg_restore of extensions does not respect dependencies Michael Paquier
• 03:28   Re: BUG #18070: Assertion failed when processing error from plpy's iterator Michael Paquier
• 05:59   a plpgsql bug daidewei@highgo.com
• 06:38   Re: Installing PostgreSQL 16 on FreeBSD 13.0 Philip Muturura
• 07:49   Re: Installing PostgreSQL 16 on FreeBSD 13.0 Thomas Munro
• 07:57   Re: Installing PostgreSQL 16 on FreeBSD 13.0 Thomas Munro
• 10:26   Re: BUG #18057: unaccent removes intentional spaces Michael Paquier
• 11:15   Re: BUG #17695: Failed Assert in logical replication snapbuild. Alexander Pyhalov
• 11:36   Re: BUG #18046: stats collection behaviour change is affecting the usability of information. Jobin Augustine
• 12:25   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 12:53   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 13:09   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 16:00   Re: BUG #17928: Standby fails to decode WAL on termination of primary Alexander Lakhin
• 16:16   Re: BUG #18096: In edge-triggered epoll and kqueue, PQconsumeInput/PQisBusy are insufficient for correct async ops. mah0x211
• 16:58   Stackbuilder fails to download application list Thomas Schweikle
• 17:03   Re: [16+] subscription can end up in inconsistent state Robert Haas
• 18:24   Re: a plpgsql bug David G. Johnston
• 19:12   Re: a plpgsql bug Tom Lane
• 22:57   Re: BUG #6052: ADD COLUMN - ERROR: tables can have at most 1600 columns Andrew Dunstan

20 September 2023

• 01:51   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 03:51   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 09:00   Re: BUG #17928: Standby fails to decode WAL on termination of primary Alexander Lakhin
• 09:34   Re: Re: a plpgsql bug daidewei@highgo.com
• 11:26   Re: BUG #18112: pgstattuple of sequence failed Alvaro Herrera
• 12:08   BUG #18117: View definitions were changed in version 16 (missing column qualifiers) PG Bug reporting form
• 12:31   BUG #18118: bug report for COMMIT AND CHAIN feature PG Bug reporting form
• 16:12   BUG #18119: Failed assert while recoverying from pg_basebackup PG Bug reporting form
• 17:00   Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Alexander Lakhin
• 17:20   Re: BUG #18117: View definitions were changed in version 16 (missing column qualifiers) Tom Lane
• 17:25   Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Tom Lane

21 September 2023

• 01:34   Re: BUG #18119: Failed assert while recoverying from pg_basebackup Michael Paquier
• 02:24   Re: BUG #18057: unaccent removes intentional spaces Michael Paquier
• 04:22   Re: Re: a plpgsql bug daidewei@highgo.com
• 07:58   Re: group by true now errors with non-integer constant in GROUP BY Peter Geoghegan
• 09:31   BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data. PG Bug reporting form
• 09:39   BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" PG Bug reporting form
• 09:41   Re: BUG #18118: bug report for COMMIT AND CHAIN feature Laurenz Albe
• 10:06   Re: group by true now errors with non-integer constant in GROUP BY David Rowley
• 10:12   回复：Re: BUG #18118: bug report for COMMIT AND CHAIN feature 刘相(佑熙)
• 13:30   BUG #18125: Ordered set aggregate results (MD5 hashing) vary between postgres versions PG Bug reporting form
• 13:57   BUG #18126: Ordered set aggregate: result does not depend on sort order PG Bug reporting form
• 14:00   BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1 PG Bug reporting form
• 14:30   Re: BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data. Sergei Kornilov
• 14:49   Re: BUG #18103: bugs of concurrent merge into when use different join plan Dean Rasheed
• 18:01   Re: BUG #18126: Ordered set aggregate: result does not depend on sort order Tom Lane
• 19:16   Re: 回复：Re: BUG #18118: bug report for COMMIT AND CHAIN feature Tom Lane
• 20:56   Invalid dump file after drop of role that previously created extension containing a table. Aleš Zelený
• 22:30   Re: Invalid dump file after drop of role that previously created extension containing a table. Stephen Frost
• 22:47   Re: [16+] subscription can end up in inconsistent state vignesh C
• 23:13   BUG #18128: a Parallel Hash started with batches 64 but increased to 262144 and FreeableMemory tanked PG Bug reporting form
• 23:15   Re: [16+] subscription can end up in inconsistent state Robert Haas

22 September 2023

• 04:40   why are null bytes allowed in JSON columns? Wyatt Alt
• 04:47   Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" Bruce Momjian
• 04:53   Re: why are null bytes allowed in JSON columns? David G. Johnston
• 04:55   Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" Peter Geoghegan
• 04:57   Re: why are null bytes allowed in JSON columns? Wyatt Alt
• 05:06   Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" Bruce Momjian
• 05:07   Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" Peter Geoghegan
• 05:08   Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" Tom Lane
• 06:11   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 07:02   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 09:00   BUG #18129: GiST index produces incorrect query results PG Bug reporting form
• 12:32   Re: [16+] subscription can end up in inconsistent state vignesh C
• 14:39   BUG #18130: \copy fails with "could not read block" or "page should be empty but not" errors due to triggers PG Bug reporting form
• 15:00   Re: BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1 Alexander Lakhin
• 15:56   Re: Invalid dump file after drop of role that previously created extension containing a table. Aleš Zelený
• 16:43   Re: BUG #18129: GiST index produces incorrect query results Heikki Linnakangas
• 20:48   Re: BUG #18080: to_tsvector fails for long text input Tom Lane
• 21:55   Re: [16+] subscription can end up in inconsistent state vignesh C
• 22:22   BUG #18131: PL/pgSQL: regclass procedure parameter wrongly memoized(?) PG Bug reporting form
• 22:31   Re: BUG #18080: to_tsvector fails for long text input Tom Lane

23 September 2023

• 00:32   Re: BUG #18131: PL/pgSQL: regclass procedure parameter wrongly memoized(?) Christian Stork
• 00:37   Re: why are null bytes allowed in JSON columns? Andrew Dunstan
• 02:35   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 03:05   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 03:16   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 03:20   Re: BUG #17928: Standby fails to decode WAL on termination of primary Tom Lane
• 04:07   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 05:02   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 05:29   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 07:44   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 19:39   Re: BUG #18131: PL/pgSQL: regclass procedure parameter wrongly memoized(?) Tom Lane
• 23:43   BUG #18132: llvm-jit does not build with LLVM 17 PG Bug reporting form
• 23:48   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro

24 September 2023

• 01:06   Re: BUG #18129: GiST index produces incorrect query results Heikki Linnakangas
• 02:23   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 21:51   Re: [16+] subscription can end up in inconsistent state vignesh C
• 23:02   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 23:43   Re: BUG #18132: llvm-jit does not build with LLVM 17 Thomas Munro

25 September 2023

• 02:58   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 03:18   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 04:32   Re: BUG #17928: Standby fails to decode WAL on termination of primary Noah Misch
• 06:07   Re: BUG #17928: Standby fails to decode WAL on termination of primary Tom Lane
• 06:29   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 06:47   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 07:59   Re: BUG #17928: Standby fails to decode WAL on termination of primary Tom Lane
• 08:05   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 08:13   Re: BUG #17928: Standby fails to decode WAL on termination of primary Tom Lane
• 08:29   Re: BUG #17928: Standby fails to decode WAL on termination of primary Tom Lane
• 09:52   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 13:31   Re: BUG #18133: Canceling statement due to statement timeout SOzcn
• 18:49   Re: BUG #18133: Canceling statement due to statement timeout Greg Sabino Mullane
• 20:45   Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" Andres Freund
• 23:14   Re: BUG #18130: \copy fails with "could not read block" or "page should be empty but not" errors due to triggers Tom Lane

26 September 2023

• 00:24   Re: BUG #18129: GiST index produces incorrect query results Heikki Linnakangas
• 01:14   Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro
• 01:32   Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" Bruce Momjian
• 03:34   Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier
• 04:26   BUG #18134: ROW_COUNT do not set to 0 when psql's \gset command get no rows returned PG Bug reporting form
• 10:00   Re: BUG #17969: Assert failed in bloom_init() when false_positive_rate = 0.25 Alexander Lakhin
• 11:08   Re: BUG #18129: GiST index produces incorrect query results Alexander Lakhin
• 12:46   Re: BUG #18103: bugs of concurrent merge into when use different join plan Richard Guo
• 13:23   PostgreSQL's processes blocking each other are not detected as deadlock Sorin Mircioiu
• 16:42   Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower David Rowley
• 17:02   Re: PostgreSQL's processes blocking each other are not detected as deadlock Tom Lane
• 19:09   Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes" Bruce Momjian

27 September 2023

• 02:14   md5 password valid and invalid after upgrading Kyle MacMillan
• 10:29   Re: BUG #18103: bugs of concurrent merge into when use different join plan Dean Rasheed
• 11:04   Re: md5 password valid and invalid after upgrading Laurenz Albe
• 11:32   Re: PostgreSQL's processes blocking each other are not detected as deadlock Sorin Mircioiu
• 11:43   PG_DUMPALL not executable within docker container Patrick Frießnegg
• 12:06   Re: PG_DUMPALL not executable within docker container Daniel Gustafsson
• 12:06   Bug of psql meta-command \sf & \sv Jet Zhang
• 12:13   Re: Bug of psql meta-command \sf & \sv Daniel Gustafsson
• 12:25   RE: Bug of psql meta-command \sf & \sv Jet Zhang
• 12:27   pg_rewind: ERROR: could not fetch remote file "global/pg_control": ERROR: permission denied Zhaoxun Yan
• 12:47   Re: PG_DUMPALL not executable within docker container Patrick Frießnegg
• 13:00   BUG #18135: Incorrect memory access occurs when attaching a partition with an index PG Bug reporting form
• 13:00   Re: BUG #18134: ROW_COUNT do not set to 0 when psql's \gset command get no rows returned Japin Li
• 13:33   Re: Bug of psql meta-command \sf & \sv Japin Li
• 14:03   RE: Bug of psql meta-command \sf & \sv Jet Zhang
• 15:07   Re: Memory leak on subquery as scalar operand Daniel Gustafsson
• 15:35   Re: Bug of psql meta-command \sf & \sv 咸�9�5
• 17:16   Re: Bug of psql meta-command \sf & \sv Japin Li
• 18:04   BUG #18136: lc_messages is the empty string but should be 'C'? PG Bug reporting form
• 22:26   Re: md5 password valid and invalid after upgrading Kyle MacMillan
• 23:45   Re: Memory leak on subquery as scalar operand Andres Freund

28 September 2023

• 01:25   Re: md5 password valid and invalid after upgrading Tom Lane
• 04:00   Re: FW: Query execution failure Bruce Momjian
• 04:06   Re: FW: Query execution failure Tom Lane
• 05:09   回复： Bug of psql meta-command \sf & \sv 咸�9�5
• 05:27   Re: FW: Query execution failure Bruce Momjian
• 06:22   Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Richard Guo
• 06:30   Re: BUG #18135: Incorrect memory access occurs when attaching a partition with an index Michael Paquier
• 06:51   Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower David Rowley
• 08:00   Re: BUG #18135: Incorrect memory access occurs when attaching a partition with an index Alexander Lakhin
• 08:07   Missed TidRangePath in the print_path switch Andrey Lepikhov
• 09:32   Re: EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery Andrey Lepikhov
• 10:07   Re: BUG #18135: Incorrect memory access occurs when attaching a partition with an index Michael Paquier
• 10:16   Re: BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1 Michael Paquier
• 10:24   BUG #18137: PG16 release note doc bug in "Allow GRANT group_name TO user_name ..." PG Bug reporting form
• 11:00   Re: BUG #18135: Incorrect memory access occurs when attaching a partition with an index Alexander Lakhin
• 12:08   Broken type checking for empty subqueries Marek Malevič
• 13:33   Re: Missed TidRangePath in the print_path switch David Rowley
• 14:28   Re: Broken type checking for empty subqueries Vik Fearing
• 15:41   Re: Broken type checking for empty subqueries David Rowley
• 15:44   BUG #18138: Using limit on VALUES causes type conversion to fail. PG Bug reporting form
• 16:48   Re: FW: Query execution failure Bruce Momjian
• 17:47   Re: BUG #18138: Using limit on VALUES causes type conversion to fail. Pantelis Theodosiou
• 17:47   Re: Broken type checking for empty subqueries David Rowley
• 17:57   Re: Broken type checking for empty subqueries Tom Lane
• 18:04   Re: BUG #18138: Using limit on VALUES causes type conversion to fail. Akash Kava
• 18:57   Re: BUG #18138: Using limit on VALUES causes type conversion to fail. Tom Lane
• 19:25   Re: BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1 Andres Freund
• 19:31   Re: BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1 Andres Freund
• 20:02   BUG #18139: Causing FATAL error on database using function last() or first() PG Bug reporting form
• 20:31   Re: BUG #18135: Incorrect memory access occurs when attaching a partition with an index Tom Lane
• 21:50   Re: BUG #18139: Causing FATAL error on database using function last() or first() Tom Lane
• 22:36   Re: BUG #18139: Causing FATAL error on database using function last() or first() David G. Johnston

29 September 2023

• 00:10   Re: Broken type checking for empty subqueries David Rowley
• 00:49   Re: md5 password valid and invalid after upgrading Kyle MacMillan
• 00:53   Re: Broken type checking for empty subqueries Tom Lane
• 01:14   Re: md5 password valid and invalid after upgrading Tom Lane
• 02:32   Re: md5 password valid and invalid after upgrading Kyle MacMillan
• 09:50   Re: pg_rewind: ERROR: could not fetch remote file "global/pg_control": ERROR: permission denied Michael Paquier
• 10:52   Re: Broken type checking for empty subqueries David Rowley
• 17:31   BUG #18141: sorry, too many clients error occurring very frequently PG Bug reporting form
• 21:12   BUG #18141: sorry, too many clients error occurring very frequently Wetmore, Matthew (CTR)
• 21:12   Re: BUG #18141: sorry, too many clients error occurring very frequently Joe Conway
• 21:15   Re: BUG #18137: PG16 release note doc bug in "Allow GRANT group_name TO user_name ..." Bruce Momjian
• 21:17   Re: BUG #18137: PG16 release note doc bug in "Allow GRANT group_name TO user_name ..." Tom Lane
• 21:32   Re: BUG #18137: PG16 release note doc bug in "Allow GRANT group_name TO user_name ..." Bruce Momjian

30 September 2023

• 09:36   Re: BUG #18134: ROW_COUNT do not set to 0 when psql's \gset command get no rows returned Jov
• 13:33   Help pg_restore version Jorge Soro Domenech
• 21:04   Re: BUG #18141: sorry, too many clients error occurring very frequently Jeff Janes