Mailing lists [pgsql-bugs]

1 January

• 00:52   Re: BUG #18719: Bug Report for Patch (For inplace update durability, make heap_update() callers wait) Noah Misch
• 13:14   Re: BUG #18754: Logical replication cannot restart if client sent a copyDone vignesh C
• 22:01   BUG #18762: Update script produces distinct outputs before and after vacuum analyze operation PG Bug reporting form
• 23:12   Re: BUG #18762: Update script produces distinct outputs before and after vacuum analyze operation David G. Johnston

2 January

• 08:29   Re: Column changes such as an increase in varchar size, can cause extremely slow queries, and postgres should run analyze automatically. Noah Misch
• 09:43   BUG #18763: pg_get_viewdef returns an old def with new relation name PG Bug reporting form
• 12:33   AW: Commit 5a2fed911a broke parallel query Rank, Christian (LfL)
• 13:49   Re: Incorrect sort result caused by ROLLUP and WHERE operation Zhang Mingli
• 18:53   Re: AW: Commit 5a2fed911a broke parallel query Tom Lane
• 19:04   Re: Incorrect sort result caused by ROLLUP and WHERE operation Tom Lane

3 January

• 03:15   Re: BRIN index creation on geometry column causes crash David Rowley
• 04:12   回复：Re: Incorrect sort result caused by ROLLUP and WHERE operation 谭忠涛
• 04:17   回复：Re: Incorrect sort result caused by ROLLUP and WHERE operation 谭忠涛
• 10:36   BUG #18764: server closed the connection unexpectedly PG Bug reporting form
• 19:47   BUG #18765: Inconsistent behaviour and errors with LIKE PG Bug reporting form
• 19:56   Re: BUG #18764: server closed the connection unexpectedly Tom Lane
• 20:04   BUG #18766: not exists sometimes gives too few records PG Bug reporting form
• 20:21   Re: BUG #18765: Inconsistent behaviour and errors with LIKE David G. Johnston
• 20:58   Re: BUG #18764: server closed the connection unexpectedly Tom Lane
• 22:01   Re: BUG #18766: not exists sometimes gives too few records Tomas Vondra

4 January

• 10:14   Re: BUG #18763: pg_get_viewdef returns an old def with new relation name Kirill Reshke
• 14:43   Re: BUG #18766: not exists sometimes gives too few records Tomas Vondra
• 15:15   Re: BUG #18766: not exists sometimes gives too few records David Rowley

6 January

• 11:24   BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. PG Bug reporting form
• 11:24   Re: BUG #18766: not exists sometimes gives too few records Jan Kort
• 16:14   Re: BUG #18764: server closed the connection unexpectedly Richard Guo
• 19:24   Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. Pavel Stehule
• 22:25   Re: BUG #18765: Inconsistent behaviour and errors with LIKE David G. Johnston

7 January

• 06:13   Re: BUG #18763: pg_get_viewdef returns an old def with new relation name lyz
• 10:00   Re: BUG #18764: server closed the connection unexpectedly Richard Guo
• 13:32   Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. Philippe BEAUDOIN
• 14:27   Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. Pavel Stehule
• 15:39   Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres' Aleksander Alekseev
• 18:54   Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. Philippe BEAUDOIN
• 20:51   Incorrect result in certain expressions of anti-join Torbjörn Gannholm

8 January

• 00:57   Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows Thomas Munro
• 01:03   Re: Incorrect result in certain expressions of anti-join Pantelis Theodosiou
• 02:19   Re: Incorrect result in certain expressions of anti-join David G. Johnston
• 06:48   Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows Thomas Munro
• 17:45   Re: pg_rewind fails on Windows where tablespaces are used Andrew Dunstan
• 23:52   Re: BUG #18765: Inconsistent behaviour and errors with LIKE Peter Eisentraut

9 January

• 00:12   Re: BUG #18765: Inconsistent behaviour and errors with LIKE Tom Lane
• 06:30   Re: BUG #18764: server closed the connection unexpectedly David Rowley
• 06:38   Re: pg_rewind fails on Windows where tablespaces are used Thomas Munro
• 06:57   Re: BUG #18764: server closed the connection unexpectedly Tom Lane
• 07:14   Re: BUG #18764: server closed the connection unexpectedly Tom Lane
• 10:38   Re: BUG #18764: server closed the connection unexpectedly Richard Guo
• 12:45   BUG #18769: ldapscheme is not displayed in pg_hba_file_rules PG Bug reporting form
• 15:09   Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules Daniel Gustafsson
• 15:11   Re: BUG #18663: synchronous_standby_names vs synchronous_commit vs pg_stat_replication Fujii Masao

10 January

• 04:35   Re: BUG #18764: server closed the connection unexpectedly David Rowley
• 04:49   BUG #18770: The function 'packGraph ' causes a memory leak. PG Bug reporting form
• 05:41   Re: BUG #18764: server closed the connection unexpectedly dqetool
• 11:00   Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules Laurenz Albe
• 11:02   Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules Daniel Gustafsson
• 14:54   Re: BUG #18663: synchronous_standby_names vs synchronous_commit vs pg_stat_replication Asphator
• 17:48   Re: BUG #18770: The function 'packGraph ' causes a memory leak. Tom Lane

11 January

• 20:27   BUG #18771: ICU custom collations with rules ignore collator strength option. PG Bug reporting form

12 January

• 18:55   Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules Tom Lane
• 19:20   Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules Daniel Gustafsson

13 January

• 19:42   Re: BUG #18771: ICU custom collations with rules ignore collator strength option. Peter Eisentraut
• 21:47   Re: BUG #18771: ICU custom collations with rules ignore collator strength option. Ruben Ruiz

14 January

• 13:57   Re: There is a defect in the ReplicationSlotCreate() function where it iterates through ReplicationSlotCtl->replication_slots[max_replication_slots] to find a slot but does not break out of the loop when a slot is found. Daniel Gustafsson
• 17:14   Re: There is a defect in the ReplicationSlotCreate() function where it iterates through ReplicationSlotCtl->replication_slots[max_replication_slots] to find a slot but does not break out of the loop when a slot is found. Tom Lane
• 17:20   Re: There is a defect in the ReplicationSlotCreate() function where it iterates through ReplicationSlotCtl->replication_slots[max_replication_slots] to find a slot but does not break out of the loop when a slot is found. Daniel Gustafsson

15 January

• 00:12   Re: pg_rewind fails on Windows where tablespaces are used Andrew Dunstan
• 00:41   BUG #18772: Segfaul i Greek stemming PG Bug reporting form
• 03:33   Re: BUG #18772: Segfaul i Greek stemming Tom Lane
• 08:59   BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する PG Bug reporting form
• 16:32   Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する Daniel Gustafsson
• 19:53   reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する Fujii Masao
• 19:53   reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する Fujii Masao

16 January

• 12:29   BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB PG Bug reporting form
• 13:50   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Rajni Bobal
• 17:55   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Vik Fearing
• 18:58   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Tom Lane
• 19:02   Re: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB Tom Lane
• 20:02   Re: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB Ilya Knyazev
• 21:35   BUG #18777: Error running unnest function in a two phase commit transaction PG Bug reporting form
• 22:18   Re: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB Tom Lane
• 22:25   Re: BUG #18777: Error running unnest function in a two phase commit transaction Tom Lane
• 23:00   BUG #18778: Query planning fails in ExecInitExprRec with unrecognized node type PG Bug reporting form

17 January

• 02:35   Re: BUG #18778: Query planning fails in ExecInitExprRec with unrecognized node type Tom Lane
• 14:36   BUG #18779: Segmentation fault while trying to connect via psql PG Bug reporting form

18 January

• 17:37   Re: pg_rewind fails on Windows where tablespaces are used Andrew Dunstan
• 18:52   Re: BUG #18778: Query planning fails in ExecInitExprRec with unrecognized node type Zhang Mingli
• 19:51   Re: BUG #18778: Query planning fails in ExecInitExprRec with unrecognized node type Tom Lane

19 January

• 05:32   Re: BUG #18779: Segmentation fault while trying to connect via psql Jeff Janes

20 January

• 01:25   BUG #18780: Bindings types are lost for complex queries PG Bug reporting form
• 15:52   BUG #18781: pg group gy The number of returned data bars in a field is inconsistent PG Bug reporting form
• 18:18   Re: BUG #18780: Bindings types are lost for complex queries David G. Johnston
• 18:37   Re: BUG #18780: Bindings types are lost for complex queries Tom Lane
• 21:30   Re: BUG #18780: Bindings types are lost for complex queries Viktor Remennik
• 22:26   Re: BUG #18780: Bindings types are lost for complex queries Tom Lane

21 January

• 00:29   Re: BUG #18780: Bindings types are lost for complex queries Viktor Remennik
• 05:13   Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する 勇次 安藤
• 06:01   Re: Performance Issue when using gin index Tom Lane
• 09:25   回复：Re: Performance Issue when using gin index 谭忠涛
• 18:30   BUG #18782: Inconsistent behaviour with triggers and row level security - depends on prior number of inserts PG Bug reporting form
• 19:35   Combining array slicing and indexing causes incorrect/confusing results Jelte Fennema-Nio
• 20:04   Re: Combining array slicing and indexing causes incorrect/confusing results Tom Lane

22 January

• 13:00   Re: BUG #18594: CASE WHEN ELSE failing to return the expected output when the same colum is used in WHEN and ELSE Chris BSomething
• 19:43   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 David G. Johnston

23 January

• 07:00   BUG #18783: 2025-01-23 03:55:06.243 GMT [22929] LOG: postmaster became multithreaded 2025-01-23 03:55:06.243 GM PG Bug reporting form
• 11:57   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Rajni Bobal
• 12:11   ERROR: tuple to be updated was already modified by an operation triggered by the current command Richard Guo
• 17:24   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 David G. Johnston
• 17:54   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Rajni Bobal
• 18:02   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Greg Sabino Mullane
• 18:03   Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 David G. Johnston
• 21:09   Re: BUG #18783: 2025-01-23 03:55:06.243 GMT [22929] LOG: postmaster became multithreaded 2025-01-23 03:55:06.243 GM Tom Lane
• 22:09   Parent index on partitioned table could still be invalid even when children are not Dmytro Astapov

24 January

• 08:05   BUG #18784: Bugs and BugTracking PG Bug reporting form
• 21:25   Re: BUG #18784: Bugs and BugTracking Álvaro Herrera
• 22:35   Re: BUG #18784: Bugs and BugTracking Tom Lane

25 January

• 22:56   Re: BUG #18782: Inconsistent behaviour with triggers and row level security - depends on prior number of inserts Tom Lane

27 January

• 11:49   Superuser can't revoke role granted by non-superuser Alexander Kukushkin
• 12:20   Re: Superuser can't revoke role granted by non-superuser Kirill Reshke
• 12:22   Re: Superuser can't revoke role granted by non-superuser Alexander Kukushkin
• 12:37   Re: Superuser can't revoke role granted by non-superuser Kirill Reshke
• 12:45   Re: BUG #18782: Inconsistent behaviour with triggers and row level security - depends on prior number of inserts Julian Wreford
• 13:13   Re: Superuser can't revoke role granted by non-superuser Alexander Kukushkin
• 17:43   Re: Superuser can't revoke role granted by non-superuser Tom Lane
• 19:06   Re: PostgreSQL 17.2 servers crashing due to segmentation faults on query execution Laurenz Albe

28 January

• 08:47   Re: Evidence of Ownership Issues During Restoration of Extension Member Objects Christophe Pettus
• 08:56   Re: Evidence of Ownership Issues During Restoration of Extension Member Objects David G. Johnston
• 09:33   Re: Evidence of Ownership Issues During Restoration of Extension Member Objects Tom Lane
• 09:34   Re: BUG #18735: Specific multibyte character in psql file path command parameter for Windows Koichi Suzuki
• 09:46   Re: Evidence of Ownership Issues During Restoration of Extension Member Objects AKASH
• 10:00   Re: BUG #18735: Specific multibyte character in psql file path command parameter for Windows Tom Lane
• 10:28   Re: BUG #18735: Specific multibyte character in psql file path command parameter for Windows Koichi Suzuki
• 10:41   Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する 安藤勇次
• 16:58   BUG #18785: Pointer bmr.rel, dereferenced by passing as 1st parameter to function is checked for NULL later PG Bug reporting form
• 17:08   BUG #18786: Pointer bmr.rel, dereferenced by passing as 1st parameter to function is checked for NULL later PG Bug reporting form
• 17:32   BUG #18787: pointer te->defn not checked for NULL PG Bug reporting form
• 18:00   Re: BUG #18787: pointer te->defn not checked for NULL Tom Lane
• 22:55   Re: BUG #18785: Pointer bmr.rel, dereferenced by passing as 1st parameter to function is checked for NULL later Andres Freund
• 23:04   Re: BUG #18785: Pointer bmr.rel, dereferenced by passing as 1st parameter to function is checked for NULL later Tom Lane
• 23:12   Re: BUG #18785: Pointer bmr.rel, dereferenced by passing as 1st parameter to function is checked for NULL later Andres Freund

29 January

• 05:16   Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する Masahiko Sawada
• 15:24   BUG #18789: logical replication slots are deleted after failovers PG Bug reporting form
• 17:20   Trying to ugrade from version 16.2 to 17 Stanley Pagenel
• 19:29   Re: Trying to ugrade from version 16.2 to 17 Laurenz Albe
• 22:10   BUG #18790: Pg_stat_statements doesn't track schema. PG Bug reporting form
• 22:13   Re: BUG #18789: logical replication slots are deleted after failovers Masahiko Sawada
• 22:27   Re: BUG #18735: Specific multibyte character in psql file path command parameter for Windows Tom Lane

30 January

• 01:56   Bug in psql Chris BSomething
• 02:39   Re: BUG #18735: Specific multibyte character in psql file path command parameter for Windows Koichi Suzuki
• 10:54   Re: Bug in psql Laurenz Albe
• 13:46   RE: Trying to ugrade from version 16.2 to 17 Stanley Pagenel
• 14:48   RE: BUG #18789: logical replication slots are deleted after failovers Hayato Kuroda (Fujitsu)
• 19:29   Re: BUG #18790: Pg_stat_statements doesn't track schema. Raghvendra Mishra
• 21:01   Re: BUG #18790: Pg_stat_statements doesn't track schema. Greg Sabino Mullane

31 January

• 14:23   Re: BUG #18790: Pg_stat_statements doesn't track schema. Raghvendra Mishra
• 20:50   Re: BUG #18790: Pg_stat_statements doesn't track schema. Greg Sabino Mullane