pgsql-bugs - November 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)
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 20 21 23 24 25 26 27 28 29 30

Nov. 1, 2025

Thread Author Time
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 Michael Paquier 00:17
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 Xuneng Zhou 00:44
BUG #19100: Different column type between partitioned table and detached pending partition table make errors PG Bug reporting form 18:36

Nov. 2, 2025

Thread Author Time
BUG #19101: Ceil on BIGINT could lost precision in decil function PG Bug reporting form 15:16
Re: BUG #19101: Ceil on BIGINT could lost precision in decil function Laurenz Albe 16:31
Re: BUG #19101: Ceil on BIGINT could lost precision in decil function Tom Lane 16:35
Inconsistencies around Composite Row nullness Chris Hanks 16:52
Re: Inconsistencies around Composite Row nullness David G. Johnston 18:19
Re: Inconsistencies around Composite Row nullness Tom Lane 18:27
Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors Tom Lane 18:36

Nov. 3, 2025

Thread Author Time
Re:Re: BUG #19101: Ceil on BIGINT could lost precision in decil function dqetool 02:48
BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown PG Bug reporting form 05:51
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown 📎 Kuntal Ghosh 05:57
Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors Haiyang Li 09:16
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown Richard Guo 10:09
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown 📎 Richard Guo 13:09
CREATE TABLE ... LIKE INCLUDING ALL does not create new sequences for serial columns Kumaresan Balakrishnan 17:10
RE: CREATE TABLE ... LIKE INCLUDING ALL does not create new sequences for serial columns Sivadhas arumugam 19:47
Re: BUG #19042: Option --help not recognized at the end of command line in pg_restore Peter Eisentraut 20:57

Nov. 4, 2025

Thread Author Time
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 📎 Michael Paquier 04:52
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown 📎 Richard Guo 07:44
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 Xuneng Zhou 09:01
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 xingguo 09:31
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 Michael Paquier 09:48
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown Kuntal Ghosh 09:51
BUG #19103: Canceled INSERT statement can still influence the performance of subsequent SELECT statement PG Bug reporting form 12:08
Re: BUG #19103: Canceled INSERT statement can still influence the performance of subsequent SELECT statement David G. Johnston 13:26
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown Andrei Lepikhov 13:43
Re: BUG #19103: Canceled INSERT statement can still influence the performance of subsequent SELECT statement Tom Lane 14:55
ALTER TABLE ... ADD COLUMN ... DEFAULT with volatile function loses DML Jeff Davis 18:14
Re: ALTER TABLE ... ADD COLUMN ... DEFAULT with volatile function loses DML Tom Lane 18:22
Re: ALTER TABLE ... ADD COLUMN ... DEFAULT with volatile function loses DML Jeff Davis 19:20
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown 📎 Alexander Korotkov 23:41

Nov. 5, 2025

Thread Author Time
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown Richard Guo 01:36
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 Michael Paquier 01:46
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown Richard Guo 01:50
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown Kuntal Ghosh 06:04
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown Alexander Korotkov 08:30
Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown Richard Guo 10:19
BUG #19104: Does regexp_substr function support non-greedy matching? PG Bug reporting form 12:41
Re: CREATE TABLE ... LIKE INCLUDING ALL does not create new sequences for serial columns Peter Eisentraut 13:01
Re: BUG #19104: Does regexp_substr function support non-greedy matching? Tom Lane 14:49
Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors Haiyang Li 14:59

Nov. 6, 2025

Thread Author Time
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error Amit Langote 10:00

Nov. 7, 2025

Thread Author Time
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error Tender Wang 01:01
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error 📎 Amit Langote 06:02
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error Amit Langote 06:03
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error Tender Wang 06:35
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error Kirill Reshke 09:04
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error 📎 Amit Langote 09:23
Re: BUG #19103: Canceled INSERT statement can still influence the performance of subsequent SELECT statement Álvaro Herrera 15:51

Nov. 8, 2025

Thread Author Time
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error 📎 Amit Langote 05:19
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 Noah Misch 20:03
BUG #19105: Parallel Hash Join crash when work_mem is small PG Bug reporting form 22:01

Nov. 9, 2025

Thread Author Time
Re: BUG #19095: Test if function exit() is used fail when linked static Torsten Rupp 08:33
ecpg Fetch issue Tzuriel Kahlon 13:26
BUG #19106: Potential regression with CTE materialization planning in Postgres 18 PG Bug reporting form 13:52
Re: BUG #19105: Parallel Hash Join crash when work_mem is small Tom Lane 15:47
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Tom Lane 15:53
Re: BUG #19105: Parallel Hash Join crash when work_mem is small Tomas Vondra 17:49
Re: BUG #19105: Parallel Hash Join crash when work_mem is small Thomas Munro 22:35
Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 Michael Paquier 22:36
Re: BUG #19105: Parallel Hash Join crash when work_mem is small Tom Lane 23:40

Nov. 10, 2025

Thread Author Time
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Kamil Monicz 03:21
BUG #19107: The hold cursor is unexpectedly released during rollback PG Bug reporting form 10:46
Re:BUG #19107: The hold cursor is unexpectedly released during rollback 📎 zengman 10:50
BUG #19108: Stack overflow duting query parse PG Bug reporting form 11:13
Re: ecpg Fetch issue Heikki Linnakangas 11:43
clog segment truncation Smolkin Grigory 12:29
Re: BUG #19108: Stack overflow duting query parse Heikki Linnakangas 12:38
Re: clog segment truncation Matheus Alcantara 13:05
Re: BUG #19108: Stack overflow duting query parse Andrey Zhidenkov 13:23
Re: clog segment truncation Matheus Alcantara 13:43
Re: clog segment truncation Smolkin Grigory 14:35
BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump PG Bug reporting form 15:22
Re: BUG #19108: Stack overflow duting query parse Tom Lane 16:02
Re: BUG #19107: The hold cursor is unexpectedly released during rollback Tom Lane 16:04
Re: BUG #19108: Stack overflow duting query parse Andrey Zhidenkov 16:12
Re: BUG #19107: The hold cursor is unexpectedly released during rollback zengman 16:37
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Tom Lane 17:09
Re: BUG #19108: Stack overflow duting query parse Tom Lane 17:35
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 📎 Tom Lane 21:05

Nov. 11, 2025

Thread Author Time
Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump Xuneng Zhou 01:11
Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump Haiyang Li 01:42
Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump Michael Paquier 02:12
Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump Haiyang Li 02:46
Re: [EXTERNAL]Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results 📎 Thomas Munro 03:39
Functions used by index don't need to be immutable? hubert depesz lubaczewski 12:35
Re: Functions used by index don't need to be immutable? Heikki Linnakangas 12:43
Re: Functions used by index don't need to be immutable? hubert depesz lubaczewski 12:43
BUG #19110: the order of elements in a json object in database is different then the order of elements PG Bug reporting form 14:26
Re: BUG #19110: the order of elements in a json object in database is different then the order of elements Tom Lane 15:16
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Vik Fearing 15:16
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Tom Lane 15:24
RLS creates inaccurate limit and offset results mike 16:29
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Vik Fearing 16:53
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Tom Lane 19:35
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Tom Lane 20:27
Re: RLS creates inaccurate limit and offset results Christophe Pettus 22:10
Re: RLS creates inaccurate limit and offset results mike 22:46

Nov. 12, 2025

Thread Author Time
Re: BUG #19095: Test if function exit() is used fail when linked static 📎 BharatDB 05:53
Fwd: BUG #19095: Test if function exit() is used fail when linked static 📎 BharatDB 05:54
Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump Haiyang Li 06:35
Re: BUG #19095: Test if function exit() is used fail when linked static Tom Lane 06:38
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Richard Guo 07:04
Re: BUG #19095: Test if function exit() is used fail when linked static Daniel Gustafsson 08:13
Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier 08:15
Re: RLS creates inaccurate limit and offset results Christophe Pettus 18:20
Re: RLS creates inaccurate limit and offset results Tom Lane 18:27
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Tom Lane 19:32

Nov. 13, 2025

Thread Author Time
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Richard Guo 03:49
BUG #19111: Using EXPLAIN ANALYZE with MERGE causes failed assert PG Bug reporting form 10:04
Re: BUG #19111: Using EXPLAIN ANALYZE with MERGE causes failed assert 📎 Dean Rasheed 15:32
Re:   Re: Re: Revoke Connect Privilege from Database not working 📎 Nathan Bossart 16:47

Nov. 14, 2025

Thread Author Time
postgresql16-contrib-16.11-1PGDG.rhel9.x86_64 fails to install on Rocky9 due to OPENSSSL version mismatch (not available) Brodie, Kent 04:08
BUG #19112: Error comes up on login to the QueryTool after update to PgAdmin 9.10 PG Bug reporting form 09:02
Re: BUG #19112: Error comes up on login to the QueryTool after update to PgAdmin 9.10 📎 Thomas Konrad 09:05
Re: postgresql16-contrib-16.11-1PGDG.rhel9.x86_64 fails to install on Rocky9 due to OPENSSSL version mismatch (not available) Horimoto Yasuhiro 09:32
Re: BUG #19095: Test if function exit() is used fail when linked static 📎 Daniel Gustafsson 12:11
Re: BUG #19095: Test if function exit() is used fail when linked static Andres Freund 14:01
Re: BUG #19095: Test if function exit() is used fail when linked static Tom Lane 14:40
Re: BUG #19112: Error comes up on login to the QueryTool after update to PgAdmin 9.10 Greg Sabino Mullane 16:21
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 📎 Tom Lane 17:55

Nov. 15, 2025

Thread Author Time
BUG #19113: Missing updated libpq5 rpm in repo pgdg-common after minor release to 18.1 PG Bug reporting form 12:11

Nov. 16, 2025

Thread Author Time
Re: BUG #19111: Using EXPLAIN ANALYZE with MERGE causes failed assert 📎 Dilip Kumar 13:20
Re: BUG #19111: Using EXPLAIN ANALYZE with MERGE causes failed assert Dean Rasheed 22:41

Nov. 17, 2025

Thread Author Time
Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump ocean_li_996 01:34
BUG #19114: ORDER BY ASC is tampering result when calculating distance btw vectors PG Bug reporting form 06:08
Re: BUG #19114: ORDER BY ASC is tampering result when calculating distance btw vectors Thomas Munro 07:50
GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) 📎 Haowu Ge 08:02
BUG #19115: the package got zero size PG Bug reporting form 12:56
BUG #19116: Lost concurrent updates using ctid - as per doc guidance PG Bug reporting form 14:31

Nov. 18, 2025

Thread Author Time
Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Richard Guo 08:27
BUG #19117: postgresql15-contrib-15.15 for RHEL 9 has conflicting OpenSSL dependencies (3.0.0 and 3.4.0) PG Bug reporting form 12:33
Re: TLS verification to intermediate trust anchor with psql Miroslav Pankov 14:11
Re: BUG #19117: postgresql15-contrib-15.15 for RHEL 9 has conflicting OpenSSL dependencies (3.0.0 and 3.4.0) Jacob Champion 16:21
Re: BUG #19117: postgresql15-contrib-15.15 for RHEL 9 has conflicting OpenSSL dependencies (3.0.0 and 3.4.0) Devrim Gündüz 16:56
Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 Tom Lane 17:59
Re: BUG #19113: Missing updated libpq5 rpm in repo pgdg-common after minor release to 18.1 Devrim Gündüz 21:02
BUG #19119: Linux 6.14.0-1015-aws #15~24.04.1-Ubuntu SMP aarch64 aarch64 aarch64 GNU/Linux PG Bug reporting form 22:01

Nov. 19, 2025

Thread Author Time
Re: BUG #19109: catalog lookup with the wrong snapshot duringlogical decoding causes coredump 📎 cca5507 03:23
Re: BUG #19119: Linux 6.14.0-1015-aws #15~24.04.1-Ubuntu SMP aarch64 aarch64 aarch64 GNU/Linux Tom Lane 06:00
Re: BUG #19095: Test if function exit() is used fail when linked static 📎 BharatDB 09:08
pg_resetwal prints new OldestXID in wrong circumstances 📎 Heikki Linnakangas 09:52
Re: [EXTERNAL] Re: BUG #19114: ORDER BY ASC is tampering result when calculating distance btw vectors S, Naveen Krishna (Development Engineer 3) 09:54
Re: pg_resetwal prints new OldestXID in wrong circumstances Bertrand Drouvot 10:05
Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) 📎 Richard Guo 10:07
AW: BUG #19113: Missing updated libpq5 rpm in repo pgdg-common after minor release to 18.1 Hans Buschmann 11:44
Re: BUG #19095: Test if function exit() is used fail when linked static 📎 BharatDB 12:29
Re: BUG #19095: Test if function exit() is used fail when linked static 📎 Nazir Bilal Yavuz 13:17
Re: pg_resetwal prints new OldestXID in wrong circumstances Heikki Linnakangas 16:08
Re: [EXTERNAL] Re: BUG #19114: ORDER BY ASC is tampering result when calculating distance btw vectors Thomas Munro 20:22

Nov. 20, 2025

Thread Author Time
Re: BUG #19109: catalog lookup with the wrong snapshot duringlogical decoding causes coredump 📎 ocean_li_996 18:16

Nov. 21, 2025

Thread Author Time
Re: BUG #19109: catalog lookup with the wrong snapshotduringlogical decoding causes coredump cca5507 03:21
Re: BUG #19109: catalog lookup with the wrong snapshotduringlogical decoding causes coredump cca5507 08:37

Nov. 23, 2025

Thread Author Time
BUG #19332: Sudden 330x performance degradation of SELECT amid INSERTs PG Bug reporting form 08:32
Re: BUG #19332: Sudden 330x performance degradation of SELECT amid INSERTs Sergey Naumov 11:39
Re: BUG #19332: Sudden 330x performance degradation of SELECT amid INSERTs David Rowley 22:06

Nov. 24, 2025

Thread Author Time
Re: BUG #19095: Test if function exit() is used fail when linked static 📎 Nazir Bilal Yavuz 11:04
BUG #19333: 404s when accessing items from https://ftp.postgresql.org/pub/repos/yum/17/redhat/rhel-10-aarch64/ PG Bug reporting form 19:18
BUG #19334: Cannot download packages from the mirrors PG Bug reporting form 19:49
Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier 21:43

Nov. 25, 2025

Thread Author Time
Re: BUG #19095: Test if function exit() is used fail when linked static 📎 VASUKI M 09:11
Re: BUG #19095: Test if function exit() is used fail when linked static Nazir Bilal Yavuz 10:07
Re: BUG #19095: Test if function exit() is used fail when linked static Daniel Gustafsson 10:51

Nov. 26, 2025

Thread Author Time
Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier 03:43
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error 📎 Amit Langote 11:27

Nov. 27, 2025

Thread Author Time
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error Amit Langote 01:25
BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big PG Bug reporting form 08:55
BUG #19336: TRAP: failed Assert("!IsTransactionOrTransactionBlock()") PG Bug reporting form 10:18
Re: BUG #19336: TRAP: failed Assert("!IsTransactionOrTransactionBlock()") Álvaro Herrera 15:55
Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big Tom Lane 16:01
Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big Daniel Gustafsson 17:51

Nov. 28, 2025

Thread Author Time
Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big Daniel Gustafsson 09:26
Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big Daniel Gustafsson 09:56
Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big Daniel Gustafsson 11:07
Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big Tom Lane 18:29
Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big Daniel Gustafsson 18:36
BUG #19337: Errors during downloading metadata for repository pgdg-rhel9-extras PG Bug reporting form 21:07

Nov. 29, 2025

Thread Author Time
Segmentation fault in var_is_nonnullable when running query with COUNT() on 42473b3b Birler, Altan 09:12
Re: Segmentation fault in var_is_nonnullable when running query with COUNT() on 42473b3b 📎 David Rowley 19:43
Re: Segmentation fault in var_is_nonnullable when running query with COUNT() on 42473b3b David Rowley 23:56

Nov. 30, 2025

Thread Author Time
Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error 📎 Tender Wang 05:59
Re: BUG #19337: Errors during downloading metadata for repository pgdg-rhel9-extras Devrim Gündüz 20:50

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 20 21 23 24 25 26 27 28 29 30