pgsql-bugs - January 2025

If you find a bug, please use the bug reporting form.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Jan. 1, 2025

Thread Author Time
Re: BUG #18754: Logical replication cannot restart if client sent a copyDone vignesh C 10:14
BUG #18762: Update script produces distinct outputs before and after vacuum analyze operation PG Bug reporting form 19:01
Re: BUG #18762: Update script produces distinct outputs before and after vacuum analyze operation David G. Johnston 20:12

Jan. 2, 2025

Thread Author Time
Re: Column changes such as an increase in varchar size, can cause extremely slow queries, and postgres should run analyze automatically. Noah Misch 05:29
BUG #18763: pg_get_viewdef returns an old def with new relation name PG Bug reporting form 06:43
Incorrect sort result caused by ROLLUP and WHERE operation 谭忠涛 07:28
AW: Commit 5a2fed911a broke parallel query Rank, Christian (LfL) 09:33
Re: Incorrect sort result caused by ROLLUP and WHERE operation Zhang Mingli 10:49
Re: AW: Commit 5a2fed911a broke parallel query Tom Lane 15:53
Re: Incorrect sort result caused by ROLLUP and WHERE operation Tom Lane 16:04
BRIN index creation on geometry column causes crash 📎 Tobias Wendorff 22:02

Jan. 3, 2025

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

Jan. 4, 2025

Thread Author Time
Re: BUG #18763: pg_get_viewdef returns an old def with new relation name Kirill Reshke 07:14
Re: BUG #18766: not exists sometimes gives too few records Tomas Vondra 11:43
Re: BUG #18766: not exists sometimes gives too few records David Rowley 12:15

Jan. 6, 2025

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

Jan. 7, 2025

Thread Author Time
Re: BUG #18763: pg_get_viewdef returns an old def with new relation name lyz 03:13
Re: BUG #18764: server closed the connection unexpectedly Richard Guo 07:00
Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. Philippe BEAUDOIN 10:32
Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. Pavel Stehule 11:27
Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres' Aleksander Alekseev 12:39
Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. Philippe BEAUDOIN 15:54
Incorrect result in certain expressions of anti-join Torbjörn Gannholm 17:51
Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows Thomas Munro 21:57
Re: Incorrect result in certain expressions of anti-join Pantelis Theodosiou 22:03
Re: Incorrect result in certain expressions of anti-join David G. Johnston 23:19
Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows Michael Paquier 23:50

Jan. 8, 2025

Thread Author Time
Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows Michael Paquier 03:22
Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows Thomas Munro 03:48
Re: pg_rewind fails on Windows where tablespaces are used Andrew Dunstan 14:45
Re: BUG #18765: Inconsistent behaviour and errors with LIKE Peter Eisentraut 20:52
Re: BUG #18765: Inconsistent behaviour and errors with LIKE Tom Lane 21:12

Jan. 9, 2025

Thread Author Time
Re: BUG #18663: synchronous_standby_names vs synchronous_commit vs pg_stat_replication 📎 Fujii Masao 00:35
Re: BUG #18764: server closed the connection unexpectedly David Rowley 03:30
Re: pg_rewind fails on Windows where tablespaces are used Thomas Munro 03:38
Re: BUG #18764: server closed the connection unexpectedly 📎 David Rowley 03:44
Re: BUG #18764: server closed the connection unexpectedly Tom Lane 03:57
Re: BUG #18764: server closed the connection unexpectedly Tom Lane 04:14
Re: BUG #18764: server closed the connection unexpectedly Richard Guo 07:38
BUG #18769: ldapscheme is not displayed in pg_hba_file_rules PG Bug reporting form 09:45
Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules 📎 Laurenz Albe 09:54
Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules 📎 Laurenz Albe 10:00
Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules Daniel Gustafsson 12:09
Re: BUG #18663: synchronous_standby_names vs synchronous_commit vs pg_stat_replication Fujii Masao 12:11

Jan. 10, 2025

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

Jan. 11, 2025

Thread Author Time
Re:Re: Re:Re:Re: backup server core when redo btree_xlog_insert that type is XLOG_BTREE_INSERT_POST yuansong 09:40
BUG #18771: ICU custom collations with rules ignore collator strength option. PG Bug reporting form 17:27
Re: BUG #17821: Assertion failed in heap_update() due to heap pruning 📎 Noah Misch 21:44

Jan. 12, 2025

Thread Author Time
Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules Tom Lane 15:55
Re: BUG #18769: ldapscheme is not displayed in pg_hba_file_rules Daniel Gustafsson 16:20
Re: Re: Re:Re:Re: backup server core when redo btree_xlog_insert that type is XLOG_BTREE_INSERT_POST Peter Geoghegan 22:43

Jan. 13, 2025

Thread Author Time
Re: BUG #18771: ICU custom collations with rules ignore collator strength option. Peter Eisentraut 16:42
Re: BUG #18771: ICU custom collations with rules ignore collator strength option. Ruben Ruiz 18:47

Jan. 14, 2025

Thread Author Time
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. 📎 lxiaogang5 04:24
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 10: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. Tom Lane 14: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. Daniel Gustafsson 14:20
Re: pg_rewind fails on Windows where tablespaces are used Andrew Dunstan 21:12
BUG #18772: Segfaul i Greek stemming PG Bug reporting form 21:41

Jan. 15, 2025

Thread Author Time
Re: BUG #18772: Segfaul i Greek stemming Tom Lane 00:33
Re: There is a defect in the ReplicationSlotCreate() function whereit iterates throughReplicationSlotCtl->replication_slots[max_replication_slots] to find a slotbut does not break out of the loop when a slot is found. 📎 lxiaogang5 02:03
BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する PG Bug reporting form 05:59
Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する Daniel Gustafsson 13:32
reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する Fujii Masao 16:53

Jan. 16, 2025

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

Jan. 17, 2025

Thread Author Time
BUG #18779: Segmentation fault while trying to connect via psql PG Bug reporting form 11:36

Jan. 18, 2025

Thread Author Time
Re: pg_rewind fails on Windows where tablespaces are used Andrew Dunstan 14:37
Re: BUG #18778: Query planning fails in ExecInitExprRec with unrecognized node type Zhang Mingli 15:52
Re: BUG #18778: Query planning fails in ExecInitExprRec with unrecognized node type Tom Lane 16:51

Jan. 19, 2025

Thread Author Time
Re: pg_rewind fails on Windows where tablespaces are used Michael Paquier 01:12
Re: BUG #18779: Segmentation fault while trying to connect via psql Jeff Janes 02:32
BUG #18780: Bindings types are lost for complex queries PG Bug reporting form 22:25

Jan. 20, 2025

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

Jan. 21, 2025

Thread Author Time
Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する 勇次 安藤 02:13
Performance Issue when using gin index 谭忠涛 02:30
Re: Performance Issue when using gin index Tom Lane 03:01
回复:Re: Performance Issue when using gin index 谭忠涛 06:25
Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する Michael Paquier 07:45
BUG #18782: Inconsistent behaviour with triggers and row level security - depends on prior number of inserts PG Bug reporting form 15:30
Combining array slicing and indexing causes incorrect/confusing results Jelte Fennema-Nio 16:35
Re: Combining array slicing and indexing causes incorrect/confusing results Tom Lane 17:04

Jan. 22, 2025

Thread Author Time
Re: BUG #18779: Segmentation fault while trying to connect via psql 📎 Даниил Элишаков 08:28
Re: BUG #18594: CASE WHEN ELSE failing to return the expected output when the same colum is used in WHEN and ELSE Chris BSomething 10:00
Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 📎 Rajni Bobal 15:54
Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 David G. Johnston 16:43

Jan. 23, 2025

Thread Author Time
Re: BUG #17821: Assertion failed in heap_update() due to heap pruning 📎 Noah Misch 02:13
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 04:00
Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Rajni Bobal 08:57
ERROR: tuple to be updated was already modified by an operation triggered by the current command Richard Guo 09:11
Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 David G. Johnston 14:24
Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Rajni Bobal 14:54
Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 Greg Sabino Mullane 15:02
Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 David G. Johnston 15:03
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 18:09
Parent index on partitioned table could still be invalid even when children are not Dmytro Astapov 19:09

Jan. 24, 2025

Thread Author Time
BUG #18784: Bugs and BugTracking PG Bug reporting form 05:05
Re: Parent index on partitioned table could still be invalid even when children are not 📎 Dmytro Astapov 12:57
Re: BUG #18784: Bugs and BugTracking Álvaro Herrera 18:25
Re: BUG #18784: Bugs and BugTracking Tom Lane 19:35

Jan. 25, 2025

Thread Author Time
Re: BUG #18782: Inconsistent behaviour with triggers and row level security - depends on prior number of inserts Tom Lane 19:56

Jan. 27, 2025

Thread Author Time
Superuser can't revoke role granted by non-superuser Alexander Kukushkin 08:49
Re: Superuser can't revoke role granted by non-superuser Kirill Reshke 09:20
Re: Superuser can't revoke role granted by non-superuser Alexander Kukushkin 09:22
Re: Superuser can't revoke role granted by non-superuser Kirill Reshke 09:37
Re: BUG #18782: Inconsistent behaviour with triggers and row level security - depends on prior number of inserts Julian Wreford 09:45
Re: Superuser can't revoke role granted by non-superuser Alexander Kukushkin 10:13
Re: Superuser can't revoke role granted by non-superuser Tom Lane 14:43
PostgreSQL 17.2 servers crashing due to segmentation faults on query execution 📎 Victor Castro Amigo 14:55
Re: PostgreSQL 17.2 servers crashing due to segmentation faults on query execution Laurenz Albe 16:06

Jan. 28, 2025

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

Jan. 29, 2025

Thread Author Time
Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する Masahiko Sawada 02:16
BUG #18789: logical replication slots are deleted after failovers PG Bug reporting form 12:24
Re: Inconsistency of timezones in postgresql 📎 Laurenz Albe 13:09
Trying to ugrade from version 16.2 to 17 Stanley Pagenel 14:20
Re: Trying to ugrade from version 16.2 to 17 Laurenz Albe 16:29
BUG #18790: Pg_stat_statements doesn't track schema. PG Bug reporting form 19:10
Re: BUG #18789: logical replication slots are deleted after failovers Masahiko Sawada 19:13
Re: BUG #18735: Specific multibyte character in psql file path command parameter for Windows Tom Lane 19:27
Bug in psql Chris BSomething 22:56
Re: BUG #18735: Specific multibyte character in psql file path command parameter for Windows Koichi Suzuki 23:39

Jan. 30, 2025

Thread Author Time
Fwd: BUG #18784: Bugs and BugTracking 📎 VASUKI M 03:59
Re: BUG #18790: Pg_stat_statements doesn't track schema. Michael Paquier 06:40
Re: Bug in psql Laurenz Albe 07:54
RE: Trying to ugrade from version 16.2 to 17 Stanley Pagenel 10:46
RE: BUG #18789: logical replication slots are deleted after failovers Hayato Kuroda (Fujitsu) 11:48
Re: BUG #18790: Pg_stat_statements doesn't track schema. Raghvendra Mishra 16:29
Re: BUG #18790: Pg_stat_statements doesn't track schema. Greg Sabino Mullane 18:01

Jan. 31, 2025

Thread Author Time
Re: BUG #18790: Pg_stat_statements doesn't track schema. Raghvendra Mishra 11:23
Re: BUG #18790: Pg_stat_statements doesn't track schema. Greg Sabino Mullane 17:50

Browse Archives

Prev | Next