pgsql-bugs - January 2023

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, 2023

Thread Author Time
PostgreSQL 15 on Fedora 37 Does not start after reboot Tom Dryden 22:55
Re: PostgreSQL 15 on Fedora 37 Does not start after reboot Tom Lane 23:14

Jan. 2, 2023

Thread Author Time
Re: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl Sandeep Thakkar 04:46
Re: PostgreSQL 15 on Fedora 37 Does not start after reboot Tom Dryden 17:47
Re: PostgreSQL 15 on Fedora 37 Does not start after reboot Devrim Gündüz 17:56
Re: PostgreSQL 15 on Fedora 37 Does not start after reboot Tom Lane 18:08
BUG #17735: Uninstall of one version wipes out logs for all versions PG Bug reporting form 20:32

Jan. 3, 2023

Thread Author Time
Re: BUG #17735: Uninstall of one version wipes out logs for all versions Sam Bortman 00:03
Re: BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG Amit Kapila 03:55
Re: Segfault while creating logical replication slots on active DB 14.6-1 + 15.1-1 Alex Richman 12:56

Jan. 4, 2023

Thread Author Time
BUG #17736: when psql -c is used, the $ sign is escaped PG Bug reporting form 02:48
Re: BUG #17736: when psql -c is used, the $ sign is escaped John Naylor 13:34

Jan. 5, 2023

Thread Author Time
Re: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl Sandeep Thakkar 02:04
Logical Replica ReorderBuffer Size Accounting Issues Alex Richman 11:56
BUG #17737: An assert failed in execExprInterp.c PG Bug reporting form 16:53
Re: BUG #17737: An assert failed in execExprInterp.c Tom Lane 20:50
Re: BUG #17737: An assert failed in execExprInterp.c Tom Lane 21:33
Re: BUG #17737: An assert failed in execExprInterp.c Andres Freund 21:41

Jan. 6, 2023

Thread Author Time
Re: BUG #17737: An assert failed in execExprInterp.c Andres Freund 00:01
Re: Logical Replica ReorderBuffer Size Accounting Issues Amit Kapila 04:03
Re: Segfault while creating logical replication slots on active DB 14.6-1 + 15.1-1 📎 Masahiko Sawada 07:11
Issue with SQL query causing unintended consequences in database prevot morvan 12:56
Re: Issue with SQL query causing unintended consequences in database Pantelis Theodosiou 14:37
Re: Segfault while creating logical replication slots on active DB 14.6-1 + 15.1-1 Alex Richman 15:19
Re: Logical Replica ReorderBuffer Size Accounting Issues Alex Richman 16:35
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 17:53
BUG #17738: There is a typo on your website PG Bug reporting form 18:29

Jan. 7, 2023

Thread Author Time
Re: Segfault while creating logical replication slots on active DB 14.6-1 + 15.1-1 Masahiko Sawada 07:35
Re: BUG #17738: There is a typo on your website Magnus Hagander 13:56
Confusion about the range types Dino Maric 15:17
Re: Confusion about the range types Tom Lane 16:13

Jan. 8, 2023

Thread Author Time
Re: Confusion about the range types Dino Maric 10:13
Re: Bug in jsonb_path_exists (maybe _match) one-element scalar/variable jsonpath handling 📎 Alexander Korotkov 11:19
BUG #17739: postgres ts_headline function is not returning matches it should during full text search PG Bug reporting form 16:28

Jan. 9, 2023

Thread Author Time
BUG #17740: Connecting postgresql 13 with different psql versions PG Bug reporting form 08:25
BUG #17741: vacuum process hangs after pg_surgery manipulations PG Bug reporting form 08:37
BUG #17742: Postgres not generating the minidump after crash in Windows. PG Bug reporting form 10:41
RE: Logical Replica ReorderBuffer Size Accounting Issues wangw.fnst@fujitsu.com 12:29
BUG #17743: Bad RIP VALUE PG Bug reporting form 12:55
Re: BUG #17743: Bad RIP VALUE Tom Lane 15:13
Re: BUG #17740: Connecting postgresql 13 with different psql versions Tom Lane 15:19
Re: BUG #17739: postgres ts_headline function is not returning matches it should during full text search Tom Lane 15:40
Re: Logical Replica ReorderBuffer Size Accounting Issues Alex Richman 16:00
Re: BUG #17740: Connecting postgresql 13 with different psql versions Anbazhagan M 16:44
Re: BUG #17740: Connecting postgresql 13 with different psql versions Tom Lane 16:50
Re: BUG #17740: Connecting postgresql 13 with different psql versions Anbazhagan M 17:30
Postgres connection growing memory usage over time! This right after the connections in the pool are closed and opened again. Ron Wilson 22:50

Jan. 10, 2023

Thread Author Time
BUG #17744: Fail Assert while recoverying from pg_basebackup PG Bug reporting form 07:45
set_config with is_local parameter true escapes transaction boundaries Ruslan Talpa 08:20
RE: Logical Replica ReorderBuffer Size Accounting Issues wangw.fnst@fujitsu.com 11:21
pg_logical_slot_peek_changes with slots created with pglogical_output missed DML records, James Pang (chaolpan) 13:41
Re: BUG #17740: Connecting postgresql 13 with different psql versions Anbazhagan M 14:02
[OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Jeffrey Walton 14:42
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Magnus Hagander 14:46
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Jeffrey Walton 14:54
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Pavel Borisov 14:59
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Magnus Hagander 15:07
Re: BUG #17740: Connecting postgresql 13 with different psql versions Tom Lane 15:09
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Pavel Borisov 15:19
Re: BUG #17740: Connecting postgresql 13 with different psql versions Anbazhagan M 15:23
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Jeffrey Walton 15:38
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Magnus Hagander 15:47
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Jeffrey Walton 15:58
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Pavel Borisov 16:20
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Dean Rasheed 17:17
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Jeffrey Walton 18:06
Re: BUG #17740: Connecting postgresql 13 with different psql versions Anbazhagan M 20:35
Re: Postgres connection growing memory usage over time! This right after the connections in the pool are closed and opened again. Andres Freund 20:47
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Tom Lane 22:21

Jan. 11, 2023

Thread Author Time
Re: set_config with is_local parameter true escapes transaction boundaries Tom Lane 00:39
Re: pg_logical_slot_peek_changes with slots created with pglogical_output missed DML records, Amit Kapila 06:03
pg_identify_object return missing 'domain' keyword for domain constraints 📎 Adam Thomas 06:04
RE: pg_logical_slot_peek_changes with slots created with pglogical_output missed DML records, James Pang (chaolpan) 06:17
Re: set_config with is_local parameter true escapes transaction boundaries Ruslan Talpa 06:54
Re: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl Frank Reppin 08:32
TR: Issue: --exclude-schema flag not working with pgrestore ROCHER Julien 09:07
Re: TR: Issue: --exclude-schema flag not working with pgrestore Julien Rouhaud 09:40
BUG #17745: RETURNING after INSERT does not return the same structure of response PG Bug reporting form 11:22
Re: BUG #17745: RETURNING after INSERT does not return the same structure of response David G. Johnston 13:22
BUG #17746: Partitioning by hash of a text depends on icu version when text collation is not deterministic PG Bug reporting form 15:09
Re: Logical Replica ReorderBuffer Size Accounting Issues Alex Richman 15:41
Re: BUG #17746: Partitioning by hash of a text depends on icu version when text collation is not deterministic Tom Lane 17:39
BUG #17747: Registry entry "Base Directory" is not populated if you only install Command-line tools PG Bug reporting form 23:37
RE: BUG #17747: Registry entry "Base Directory" is not populated if you only install Command-line tools Jeff Laing 23:42

Jan. 12, 2023

Thread Author Time
Re: set_config with is_local parameter true escapes transaction boundaries Jobin Augustine 05:24
Re: set_config with is_local parameter true escapes transaction boundaries David G. Johnston 05:58
Re: BUG #17747: Registry entry "Base Directory" is not populated if you only install Command-line tools Julien Rouhaud 08:14
RE: Logical Replica ReorderBuffer Size Accounting Issues wangw.fnst@fujitsu.com 10:44
Re: Logical Replica ReorderBuffer Size Accounting Issues Alex Richman 13:01
BUG #17748: postres_raster extension missing in postgis packages for SLES PG Bug reporting form 13:50
BUG #17749: do repodata in online repos vor sles12 available PG Bug reporting form 14:54
Re: Bug in jsonb_path_exists (maybe _match) one-element scalar/variable jsonpath handling Alexander Korotkov 15:31
BUG #17750: Plugin_debugger not work when have pg_hint_plan on shared_preload_libraries PG Bug reporting form 15:31
Re: Bug in jsonb_path_exists (maybe _match) one-element scalar/variable jsonpath handling David G. Johnston 15:33
Facing issue while installing postgresql 📎 niharaj g 16:18
Re: BUG #17750: Plugin_debugger not work when have pg_hint_plan on shared_preload_libraries Pavel Stehule 16:19

Jan. 13, 2023

Thread Author Time
Re: Facing issue while installing postgresql John Naylor 01:59
Re: BUG #17744: Fail Assert while recoverying from pg_basebackup Kyotaro Horiguchi 09:36
Re: Crash during backend start when low on memory 📎 Mats Kindahl 10:05
RE: Logical Replica ReorderBuffer Size Accounting Issues 📎 wangw.fnst@fujitsu.com 11:17
Re: Crash during backend start when low on memory Alvaro Herrera 11:53
Re: Logical Replica ReorderBuffer Size Accounting Issues Alex Richman 12:15
Re: Crash during backend start when low on memory Tom Lane 15:01
DROP DATABASE deadlocks with logical replication worker in PG 15.1 📎 Lakshmi Narayanan Sreethar 15:23

Jan. 14, 2023

Thread Author Time
Re: BUG #17739: postgres ts_headline function is not returning matches it should during full text search Sam S 02:23
BUG #17751: DDL CREATE statement accepts invalid default values for FOREIGN KEY constraint. PG Bug reporting form 08:32
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Andres Freund 16:02
Re: BUG #17751: DDL CREATE statement accepts invalid default values for FOREIGN KEY constraint. Tom Lane 16:05
Re: BUG #17739: postgres ts_headline function is not returning matches it should during full text search Tom Lane 16:09
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Andres Freund 17:20

Jan. 16, 2023

Thread Author Time
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Amit Kapila 09:32
Re: Crash during backend start when low on memory Mats Kindahl 10:09
Re: BUG #17698: On SIGTERM, psql terminates, but leaves the statement running Alvaro Herrera 15:14
Re: BUG #17741: vacuum process hangs after pg_surgery manipulations Alvaro Herrera 15:31
Re: BUG #17698: On SIGTERM, psql terminates, but leaves the statement running Dmitry Astapov 19:44
Re: BUG #17698: On SIGTERM, psql terminates, but leaves the statement running Pavel Stehule 20:34
Re: Crash during backend start when low on memory Mats Kindahl 20:52
Re: Crash during backend start when low on memory Tom Lane 20:58
Re: Crash during backend start when low on memory Mats Kindahl 21:10
Re: Crash during backend start when low on memory Tom Lane 21:49

Jan. 17, 2023

Thread Author Time
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Amit Kapila 00:53
Possible wrong result with some "in" subquery with non-existing columns Xiong He 08:00
Re: Possible wrong result with some "in" subquery with non-existing columns Tom Lane 08:04
Re: Possible wrong result with some "in" subquery with non-existing columns Xiong He 09:06
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Amit Kapila 10:56
Re: Possible wrong result with some "in" subquery with non-existing columns David G. Johnston 15:07
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Andres Freund 20:04

Jan. 18, 2023

Thread Author Time
Re: BUG #17741: vacuum process hangs after pg_surgery manipulations Masahiko Sawada 01:40
index not used for bigint without explicit cast Sam.Mesh 01:43
Re: index not used for bigint without explicit cast Peter Geoghegan 01:55
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Amit Kapila 04:32
IN clause behaving badly with missing comma and line break Roman Cervenak 07:51
Re: IN clause behaving badly with missing comma and line break David Rowley 08:06
Re: Logical Replica ReorderBuffer Size Accounting Issues Amit Kapila 10:10
Re: Logical Replica ReorderBuffer Size Accounting Issues 📎 Alex Richman 11:16
Re: IN clause behaving badly with missing comma and line break Philip Semanchuk 15:20
Re: IN clause behaving badly with missing comma and line break Francisco Olarte 16:06
Re: IN clause behaving badly with missing comma and line break Philip Semanchuk 16:09
Re: index not used for bigint without explicit cast Sam.Mesh 21:43
BUG #17753: pg_dump --if-exists bug PG Bug reporting form 22:33

Jan. 19, 2023

Thread Author Time
Re: index not used for bigint without explicit cast Noah Misch 05:30
Re: index not used for bigint without explicit cast Tom Lane 05:51
RE: DROP DATABASE deadlocks with logical replication worker in PG 15.1 📎 houzj.fnst@fujitsu.com 07:14
Re: BUG #17753: pg_dump --if-exists bug David Rowley 09:50
RE: DROP DATABASE deadlocks with logical replication worker in PG 15.1 houzj.fnst@fujitsu.com 10:16
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Amit Kapila 11:07
Re: BUG #17753: pg_dump --if-exists bug Tom Lane 15:38
BUG #17754: Subquery IN clause returns row matches where subquery is invalid PG Bug reporting form 18:02
Re: BUG #17754: Subquery IN clause returns row matches where subquery is invalid Tom Lane 19:42
Re: BUG #17753: pg_dump --if-exists bug 📎 Tom Lane 22:22

Jan. 20, 2023

Thread Author Time
Re: BUG #17753: pg_dump --if-exists bug Tom Lane 00:09
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 vignesh C 05:24
BUG #17755: database queries get stuck for certain IDs PG Bug reporting form 10:26
Re: BUG #17755: database queries get stuck for certain IDs Pavol Sekeres 10:42
BUG #17756: Invalid replica indentity set order in a dump PG Bug reporting form 13:41
ST_Union(rast, uniontype) treat bands with different classes as the same as first band Liang Shen 13:56
Re: ST_Union(rast, uniontype) treat bands with different classes as the same as first band hubert depesz lubaczewski 14:42
Re: BUG #17756: Invalid replica indentity set order in a dump Tom Lane 15:42
Re: BUG #17755: database queries get stuck for certain IDs Tom Lane 17:19
Re: BUG #17756: Invalid replica indentity set order in a dump Sergey Belyashov 17:45
Re: BUG #17756: Invalid replica indentity set order in a dump Tom Lane 18:14
Re: BUG #17756: Invalid replica indentity set order in a dump 📎 Tom Lane 19:54
BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes PG Bug reporting form 22:48

Jan. 21, 2023

Thread Author Time
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Amit Kapila 11:36
Re: BUG #17753: pg_dump --if-exists bug Noah Misch 16:00
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Tomas Vondra 23:10
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Andres Freund 23:29
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Tom Lane 23:30
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Tom Lane 23:33
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Andres Freund 23:45

Jan. 22, 2023

Thread Author Time
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Tom Lane 00:08
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Andres Freund 00:27
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Tomas Vondra 00:55
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Tom Lane 01:01
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Andres Freund 02:08

Jan. 23, 2023

Thread Author Time
Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay Alvaro Herrera 17:23
RE: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Sisson, David 19:26
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Christophe Pettus 19:38
RE: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Sisson, David 19:51
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Andres Freund 19:55
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Tom Lane 19:55
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes David G. Johnston 20:00
RE: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Sisson, David 20:12
RE: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Sisson, David 20:35
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Andres Freund 21:10
RE: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Sisson, David 21:41
Re: index not used for bigint without explicit cast Sam.Mesh 22:46
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes 📎 Tom Lane 22:51

Jan. 24, 2023

Thread Author Time
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Andres Freund 00:37
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Tom Lane 00:45
Re: BUG #17757: Not honoring huge_pages setting during initdb causes DB crash in Kubernetes Andres Freund 01:00
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Amit Kapila 05:35
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Andres Freund 05:40
Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL Stephen Frost 20:57

Jan. 25, 2023

Thread Author Time
Minor difference in behavior between +/- Ryan Murphy 05:34
BUG #17759: MERGE UPDATE statements do not cause generated columns to update PG Bug reporting form 05:37
BUG #17760: SCRAM authentication fails with "modern" (rsassaPss signature) server certificate PG Bug reporting form 11:32
Re: Unique constraint error instead of serialization_failure Peter Bex 12:29
Re: Minor difference in behavior between +/- David G. Johnston 14:12
Re: BUG #17759: MERGE UPDATE statements do not cause generated columns to update Dean Rasheed 16:41

Browse Archives

Prev | Next