pgsql-bugs - April 2024

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

Search the Archives

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 22 23 24 25 26 27 28 29 30

April 1, 2024

Thread Author Time
RE: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows あ 00:22
回复：BUG #18398: Simplified SQL Query for Problem Diagnosis 1724647576 08:14

April 2, 2024

Thread Author Time
Re: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows Laurenz Albe 08:04
Re: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows ケーブル 10:56
Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences Tom Lane 19:04

April 3, 2024

Thread Author Time
Re: Building with musl in CI and the build farm Thomas Munro 00:00
Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences Michael Zhilin 05:08
BUG #18419: Auto Vacuum In PostgreSQL 10.21 PG Bug reporting form 12:32

April 4, 2024

Thread Author Time
Re: BUG #18419: Auto Vacuum In PostgreSQL 10.21 David Rowley 01:13
Re: BUG #18386: Slow connection access after 'vacuum full pg_attribute' Noah Misch 05:28
BUG #18420: Unexpected values appeared in select query statements that should logically imply each other PG Bug reporting form 06:14
回复：BUG #18420: Unexpected values appeared in select query statements that should logically imply each other 王子涵4620 07:03
Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences Akshat Jaimini 09:51
Re: BUG #18420: Unexpected values appeared in select query statements that should logically imply each other David Rowley 10:35
Re: Building with musl in CI and the build farm Peter Eisentraut 13:56
Re: Building with musl in CI and the build farm Wolfgang Walther 14:11
Re: Building with musl in CI and the build farm Tom Lane 14:36
Re: Building with musl in CI and the build farm Wolfgang Walther 15:01
Re: Building with musl in CI and the build farm Tom Lane 15:19
Re: Building with musl in CI and the build farm Wolfgang Walther 19:09

April 5, 2024

Thread Author Time
Sequence name with capital letters issue Thibaut BOULDOIRE 09:35
BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF PG Bug reporting form 10:00
Re: Sequence name with capital letters issue Magnus Hagander 10:50
Re: Sequence name with capital letters issue hubert depesz lubaczewski 11:10
Re: Sequence name with capital letters issue Thibaut BOULDOIRE 12:13
Detach Partition produces a --> SQL-Fehler [XX000]: ERROR: could not find ON INSERT check triggers of foreign key constraint 76908 Baehler Thomas SBB CFF FFS 13:40
Re: Sequence name with capital letters issue David G. Johnston 13:58
Re: Sequence name with capital letters issue Daniel Verite 17:34
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Robert Haas 20:20

April 6, 2024

Thread Author Time
BUG #18423: suboptimal query plan is used when ordering by an indexed field with limit PG Bug reporting form 19:14
Re: FSM Corruption (was: Could not read block at end of the relation) 📎 Noah Misch 22:30
Re: BUG #18423: suboptimal query plan is used when ordering by an indexed field with limit Jeff Janes 23:25

April 7, 2024

Thread Author Time
Re: BUG #18404: Select from pg_stat_activity in a plpgsql block can lead to a global locking issue Noah Misch 01:01
Re: BUG #18423: suboptimal query plan is used when ordering by an indexed field with limit Mao Jiayin 03:32
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF 📎 Tender Wang 09:41
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() 📎 Alexander Lakhin 10:00
Re: Detach Partition produces a --> SQL-Fehler [XX000]: ERROR: could not find ON INSERT check triggers of foreign key constraint 76908 Tender Wang 10:10
BUG #18424: Build failure when static linking with openldap PG Bug reporting form 13:21
Re: BUG #18424: Build failure when static linking with openldap Tom Lane 15:35

April 8, 2024

Thread Author Time
Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943 Alvaro Herrera 17:57

April 9, 2024

Thread Author Time
Re: BUG #17821: Assertion failed in heap_update() due to heap pruning Alexander Lakhin 12:00
Re: BUG #17821: Assertion failed in heap_update() due to heap pruning Melanie Plageman 17:41
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Robert Haas 18:59
Re: BUG #17821: Assertion failed in heap_update() due to heap pruning 📎 Alexander Lakhin 19:00
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF 📎 Tom Lane 19:34
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Alexander Lakhin 20:00

April 10, 2024

Thread Author Time
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF Richard Guo 03:25
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF Tom Lane 03:32
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF Richard Guo 07:58
BUG #18425: KB5036892 Microsoft Update Package Issue PG Bug reporting form 10:06
BUG #18426: Canceling vacuum while truncating a relation leads to standby PANIC PG Bug reporting form 11:00
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF Tom Lane 14:16
Re: BUG #18425: KB5036892 Microsoft Update Package Issue Laurenz Albe 14:30
Re: BUG #18426: Canceling vacuum while truncating a relation leads to standby PANIC 📎 Alexander Lakhin 18:00

April 11, 2024

Thread Author Time
BUG #18427: RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm not signed PG Bug reporting form 07:31
Re: FSM Corruption (was: Could not read block at end of the relation) Ronan Dunklau 07:36
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF Richard Guo 07:41
Re: BUG #18427: RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm not signed Devrim Gündüz 10:10
Re: BUG #18427: RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm not signed Rainer Jung 10:20
Re: BUG #18427: RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm not signed Devrim Gündüz 11:32
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF Tom Lane 14:13
Re: FSM Corruption (was: Could not read block at end of the relation) Noah Misch 15:38
Re: FSM Corruption (was: Could not read block at end of the relation) Peter Geoghegan 16:01
Facing issue while installing postgres14 on rhel 9.2 machine 📎 Sohan Wadalkar 17:15

April 12, 2024

Thread Author Time
Re: FSM Corruption (was: Could not read block at end of the relation) Noah Misch 02:27
Re: FSM Corruption (was: Could not read block at end of the relation) Thomas Munro 03:07
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF Richard Guo 03:25
Re: BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF Tom Lane 03:46
Re: BUG #18426: Canceling vacuum while truncating a relation leads to standby PANIC Thomas Munro 06:41
Re: BUG #18426: Canceling vacuum while truncating a relation leads to standby PANIC Thomas Munro 06:43
BUG #18428: Connection broken but DB service still alive. PG Bug reporting form 08:14
Re: Facing issue while installing postgres14 on rhel 9.2 machine Devrim Gündüz 08:29
Re: BUG #18426: Canceling vacuum while truncating a relation leads to standby PANIC Thomas Munro 11:14
BUG #18429: Inconsistent results on similar queries with join lateral PG Bug reporting form 11:25
Re: BUG #18428: Connection broken but DB service still alive. Tom Lane 13:38
Re: BUG #18429: Inconsistent results on similar queries with join lateral David G. Johnston 13:52
Re: BUG #18429: Inconsistent results on similar queries with join lateral Benoit Ryder 14:43
Re: BUG #18429: Inconsistent results on similar queries with join lateral Tom Lane 14:50
Re: BUG #18429: Inconsistent results on similar queries with join lateral Benoit Ryder 15:33
Re: BUG #18429: Inconsistent results on similar queries with join lateral Tom Lane 15:50
Re: BUG #18429: Inconsistent results on similar queries with join lateral David G. Johnston 15:57
BUG #18430: syntax error when using aggregate function in where clause of subquery PG Bug reporting form 17:14
Re: BUG #18430: syntax error when using aggregate function in where clause of subquery Laurenz Albe 17:44
Re: BUG #18430: syntax error when using aggregate function in where clause of subquery Eric Atkin 18:35
Re: BUG #18430: syntax error when using aggregate function in where clause of subquery David G. Johnston 18:59
Re: BUG #18429: Inconsistent results on similar queries with join lateral Tom Lane 19:01
Re: BUG #18430: syntax error when using aggregate function in where clause of subquery Tom Lane 19:14
Re: BUG #18430: syntax error when using aggregate function in where clause of subquery Eric Atkin 23:22

April 13, 2024

Thread Author Time
Re: FSM Corruption (was: Could not read block at end of the relation) Noah Misch 17:15
Re: BUG #18429: Inconsistent results on similar queries with join lateral 📎 Tom Lane 22:58

April 14, 2024

Thread Author Time
BUG #18432: Polymorphic, table-returning PL/pgSQL function fails with an erroneous "schema mismatch" error PG Bug reporting form 01:29
Re: BUG #18429: Inconsistent results on similar queries with join lateral Richard Guo 08:59
Re: BUG #18429: Inconsistent results on similar queries with join lateral Richard Guo 09:15
BUG #18433: Logical replication timeout PG Bug reporting form 16:08
Re: BUG #18429: Inconsistent results on similar queries with join lateral 📎 Tom Lane 16:44

April 15, 2024

Thread Author Time
Re: Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries David Rowley 03:42
Re: FSM Corruption (was: Could not read block at end of the relation) Ronan Dunklau 05:33
BUG #18425: KB5036892 Microsoft Update Package Issue MUSTAFA TANSEL TEKİN 06:45
Re: BUG #18425: KB5036892 Microsoft Update Package Issue Laurenz Albe 08:35
Re: BUG #18429: Inconsistent results on similar queries with join lateral Richard Guo 09:09
BUG #18437: The index scan result is more than the full scan result, and the primary key index has duplicate val PG Bug reporting form 13:25
Re: BUG #18437: The index scan result is more than the full scan result, and the primary key index has duplicate val Laurenz Albe 14:18
Re: BUG #18429: Inconsistent results on similar queries with join lateral Tom Lane 14:20
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Robert Haas 16:17
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Robert Haas 16:35
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Andres Freund 17:39
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Andres Freund 18:04
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Andres Freund 18:52
BUG #18438: regex isnt working for "^" , ".*" PG Bug reporting form 19:49
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Noah Misch 20:52
Re: BUG #18438: regex isnt working for "^" , ".*" David G. Johnston 21:00
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Andres Freund 21:10
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Michael Paquier 23:08

April 16, 2024

Thread Author Time
Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore David G. Johnston 03:15
Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada 03:56
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Noah Misch 03:58
BUG #18439: No way to see national language error messages when running UTF8 scripts with psql.exe on Windows PG Bug reporting form 13:13
BUG #18440: Query does not prune partitions correctly or use index when prepared statements are used PG Bug reporting form 14:08
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Andres Freund 18:01
Re: BUG #18440: Query does not prune partitions correctly or use index when prepared statements are used David G. Johnston 19:20
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Noah Misch 19:34

April 17, 2024

Thread Author Time
Re: BUG #18433: Logical replication timeout Shlok Kyal 10:48
Re: BUG #18411: Unable to create database with owner on AWS RDS Myka Dresser 14:42
BUG #18411: Unable to create database with owner on AWS RDS David G. Johnston 14:49

April 18, 2024

Thread Author Time
Re: BUG #18428: Connection broken but DB service still alive. 盧致均 (Harry) 01:23
Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943 Tender Wang 12:13
Re: BUG #18433: Logical replication timeout Костянтин Томах 13:57
CVE-2024-28849 Mathews, Rob 15:27
Re: CVE-2024-28849 Jonathan S. Katz 17:25
Re: CVE-2024-28849 Jerry Sievert 17:37

April 19, 2024

Thread Author Time
BUG #18442: Unnecessary Sort operator in indexScan Plan PG Bug reporting form 03:10
Re: BUG #18433: Logical replication timeout Shlok Kyal 11:51
Re: BUG #18351: VACUUM FULL fails with error: missing chunk number 0 for toast value XXX Peter Petrov 13:22
Re: BUG #18442: Unnecessary Sort operator in indexScan Plan Tom Lane 14:03
BUG #18443: jsonb_agg issue. Again. PG Bug reporting form 14:09
Re: BUG #18443: jsonb_agg issue. Again. David G. Johnston 15:34
Re: BUG #18443: jsonb_agg issue. Again. Ц 17:21
Re: BUG #18443: jsonb_agg issue. Again. Ц 17:31
Re: BUG #18443: jsonb_agg issue. Again. Tom Lane 17:52

April 22, 2024

Thread Author Time
Re: BUG #18442: Unnecessary Sort operator in indexScan Plan David Rowley 01:53
Re: BUG #18442: Unnecessary Sort operator in indexScan Plan Tom Lane 02:25
Re: BUG #18442: Unnecessary Sort operator in indexScan Plan Richard Guo 06:16
Re: BUG #15954: Unable to alter partitioned table to set logged David G. Johnston 19:36
Re: BUG #18442: Unnecessary Sort operator in indexScan Plan David Rowley 22:56

April 23, 2024

Thread Author Time
Re: BUG #15954: Unable to alter partitioned table to set logged Michael Paquier 05:37
Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows 📎 Thomas Munro 07:48
Fwd: BUG #18433: Logical replication timeout Kostiantyn Tomakh 09:58
BUG #18445: date_part / extract range for hours do not match documentation PG Bug reporting form 10:10
Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943 Tender Wang 11:14
Re: BUG #15954: Unable to alter partitioned table to set logged David G. Johnston 12:33
Re: BUG #18445: date_part / extract range for hours do not match documentation Tom Lane 14:39
Error during installation on a 64 bit Windows 10 Korean environment using postgresql-15.6-1-windows-x64.exe Carl 15:02
回复： BUG #18437: The index scan result is more than the full scan result, and the primary key index has duplicate val 1165125080 15:44
Re: BUG #18426: Canceling vacuum while truncating a relation leads to standby PANIC Thomas Munro 20:26
BUG #18446: Postgres.exe crash observed while installing the application PG Bug reporting form 20:41

April 24, 2024

Thread Author Time
Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries 📎 David Rowley 02:05
Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize 📎 David Rowley 02:25
Re: BUG #18433: Logical replication timeout Kostiantyn Tomakh 06:03
Re: BUG #15954: Unable to alter partitioned table to set logged Michael Paquier 07:24
Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize Alexander Lakhin 13:00

April 25, 2024

Thread Author Time
Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries Tom Lane 15:39
Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize Tom Lane 15:50
Re: BUG #17690: Nonresponsive client on replica can halt replication indefinitely Heikki Linnakangas 22:18
Re: BUG #17690: Nonresponsive client on replica can halt replication indefinitely Jacob Baskin 23:58

April 26, 2024

Thread Author Time
Re: BUG #18445: date_part / extract range for hours do not match documentation Marek Läll 10:23
Re: BUG #18445: date_part / extract range for hours do not match documentation David G. Johnston 13:06
DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1 Kumar, Devesh 19:06
Re: BUG #18445: date_part / extract range for hours do not match documentation Marek Läll 19:27
Re: BUG #18445: date_part / extract range for hours do not match documentation David G. Johnston 19:36
Re: BUG #18445: date_part / extract range for hours do not match documentation Tom Lane 20:19
Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Melanie Plageman 20:46
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Melanie Plageman 20:46
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 21:28
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Melanie Plageman 21:56
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 22:20

April 27, 2024

Thread Author Time
BUG #18449: Altering column type fails when an SQL routine depends on the column PG Bug reporting form 04:00
BUG #18450: The memory usage of the postgresql12.6 walsender process is abnormally high. PG Bug reporting form 06:02
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Melanie Plageman 14:37
Re: BUG #18450: The memory usage of the postgresql12.6 walsender process is abnormally high. David G. Johnston 21:45

April 28, 2024

Thread Author Time
edb installation failed for pgadmin when username is Chinese under c;\user #7432 周志勤 01:03
Re: BUG #18449: Altering column type fails when an SQL routine depends on the column Tom Lane 01:48

April 29, 2024

Thread Author Time
Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize 📎 David Rowley 00:54
Unable to connect to server Javali, Pramod 04:33
回复：Re: BUG #18450: The memory usage of the postgresql12.6 walsender process is abnormally high. Melody 06:42
Re: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1 Laurenz Albe 10:07
Re: BUG #18433: Logical replication timeout Shlok Kyal 10:14
Re: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1 Kumar, Devesh 10:25
Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize Alexander Lakhin 14:00
Re: Unable to connect to server Kashif Zeeshan 14:23
Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize Tom Lane 14:28
Re: Unable to connect to server Jeff Janes 15:26
Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432 Laurenz Albe 17:32
Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries 📎 David Rowley 21:39
Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432 Thomas Munro 22:03

April 30, 2024

Thread Author Time
Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize 📎 David Rowley 00:48
BUG #18451: NULL fails to coerce to string when performing string comparison PG Bug reporting form 01:16
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432 Thomas Munro 02:14
RE: Unable to connect to server Javali, Pramod 02:20
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432 Sandeep Thakkar 05:41
Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize Tom Lane 14:54

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 22 23 24 25 26 27 28 29 30