pgsql-bugs - September 2022

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

Sept. 1, 2022

Thread Author Time
Re: BUG #17349: Function gen_random_uuid duplicates in pgcrypto and core Bruce Momjian 02:05
Re: fetching bytea (blob) data of 850 MB from psql client failed Noah Misch 04:39
Re: pg_rewind WAL segments deletion pitfall 📎 Polina Bungina 11:33
Re: pg_rewind WAL segments deletion pitfall Polina Bungina 11:58

Sept. 2, 2022

Thread Author Time
BUG #17603: Problem running the post-install step. Installation may not complete correctly. PG Bug reporting form 08:45
Re: BUG #17603: Problem running the post-install step. Installation may not complete correctly. 📎 Константин Малашин 08:46

Sept. 4, 2022

Thread Author Time
BUG #17604: Constraints creation dialog column names do not refresh after changing names in the table PG Bug reporting form 06:34

Sept. 5, 2022

Thread Author Time
BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK PG Bug reporting form 02:38
Re: BUG #17604: Constraints creation dialog column names do not refresh after changing names in the table Daniel Gustafsson 07:39
Re: BUG #15333: pg_dump error on large table -- "pg_dump: could not stat file...Unknown error" Chanderprabh Jain 09:46
Re: BUG #15333: pg_dump error on large table -- "pg_dump: could not stat file...Unknown error" Chanderprabh Jain 09:56
Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records 📎 Dmitriy Kuzmin 10:19
BUG #17607: Server process crashes when PLpgSQL function raises error in subtransaction PG Bug reporting form 11:09
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records David Rowley 12:13
Re: BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK Richard Guo 14:25
Re: BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK Richard Guo 14:48
Re: BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK Tom Lane 15:51
Re: BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK Tom Lane 16:18
Re: BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK Andre Lin 16:50
Re: BUG #17607: Server process crashes when PLpgSQL function raises error in subtransaction Tom Lane 17:16
Re: BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK Tom Lane 17:19

Sept. 6, 2022

Thread Author Time
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records Dmitriy Kuzmin 06:38
NULL returned when using RETURNING in main query in combination with a CTE containing FOR UPDATE. Wilco Kruijer 10:28
Re: NULL returned when using RETURNING in main query in combination with a CTE containing FOR UPDATE. Tom Lane 14:31
Re: BUG #17606: There is still some glitch in 3f7323cbb fixing failure of MULTIEXPR_SUBLINK 📎 Tom Lane 16:53

Sept. 7, 2022

Thread Author Time
Re: BUG #17603: Problem running the post-install step. Installation may not complete correctly. Sandeep Thakkar 02:24
using 14.5 pg_upgrade on version 10.18 clusters reports unexpected error occasionally 📎 Ken Yeung 08:43
Re: BUG #17603: Problem running the post-install step. Installation may not complete correctly. 📎 Sandeep Thakkar 09:54
Re: BUG #17603: Problem running the post-install step. Installation may not complete correctly. 📎 Константин Малашин 10:38
Re: PANIC in heap_delete during ALTER TABLE 📎 Jeff Davis 21:53
Re: PANIC in heap_delete during ALTER TABLE Peter Geoghegan 22:44

Sept. 8, 2022

Thread Author Time
Postgres offset and limit bug 📎 Ming 02:02
A problem about LEAKPROOF of postgresql qiumingcheng 05:04
A problem about LEAKPROOF of postgresql qiumingcheng 05:12
A problem about LEAKPROOF of postgresql David G. Johnston 06:04
huge memory of Postgresql backend process James Pang (chaolpan) 06:10
Re: Postgres offset and limit bug David Rowley 08:36
Re: Postgres offset and limit bug Ming 08:48
Re: Postgres offset and limit bug David Rowley 09:03
BUG #17610: Use of multiple composite types incompatible with record-typed function parameter PG Bug reporting form 10:19
Re: Postgres offset and limit bug Ming 10:45
BUG #17611: SJIS conversion rule about duplicated characters differ from Windows PG Bug reporting form 11:33
Re: huge memory of Postgresql backend process Tom Lane 13:47
RE: huge memory of Postgresql backend process James Pang (chaolpan) 14:08
Re: BUG #17610: Use of multiple composite types incompatible with record-typed function parameter Japin Li 15:21
Re: BUG #17610: Use of multiple composite types incompatible with record-typed function parameter 📎 Tom Lane 16:17
Re: PANIC in heap_delete during ALTER TABLE Jeff Davis 17:30
Re: BUG #17610: Use of multiple composite types incompatible with record-typed function parameter 📎 Tom Lane 18:36
Re: huge memory of Postgresql backend process David Rowley 21:35
Re: huge memory of Postgresql backend process David Rowley 21:42

Sept. 9, 2022

Thread Author Time
Re: BUG #17610: Use of multiple composite types incompatible with record-typed function parameter Japin Li 01:07
Re: BUG #17611: SJIS conversion rule about duplicated characters differ from Windows Kyotaro Horiguchi 02:42
Re: BUG #17611: SJIS conversion rule about duplicated characters differ from Windows Tom Lane 02:58
v15b4 shadowbuild fails when using src from symlink Frank van Vugt 06:21
Re: huge memory of Postgresql backend process Amit Langote 06:30
Re: BUG #17611: SJIS conversion rule about duplicated characters differ from Windows Kyotaro Horiguchi 07:09
RE: huge memory of Postgresql backend process James Pang (chaolpan) 08:19
Re: huge memory of Postgresql backend process Amit Langote 08:41
RE: BUG #17611: SJIS conversion rule about duplicated characters differ from Windows 📎 egashira.yusuke@fujitsu.com 12:22
Re: Excessive number of replication slots for 12->14 logical replication Masahiko Sawada 21:48

Sept. 10, 2022

Thread Author Time
RE: Excessive number of replication slots for 12->14 logical replication houzj.fnst@fujitsu.com 03:41
Re: Excessive number of replication slots for 12->14 logical replication Amit Kapila 05:36
Re: Excessive number of replication slots for 12->14 logical replication Amit Kapila 06:15
Bug in UPDATE statement Moisés Limón 06:44
Re: Excessive number of replication slots for 12->14 logical replication Amit Kapila 10:22
RE: Excessive number of replication slots for 12->14 logical replication 📎 houzj.fnst@fujitsu.com 10:34
RE: huge memory of Postgresql backend process James Pang (chaolpan) 10:50
Recall: huge memory of Postgresql backend process James Pang (chaolpan) 10:50
RE: huge memory of Postgresql backend process James Pang (chaolpan) 10:52
Re: Bug in UPDATE statement Jaime Casanova 12:21
Bug in UPDATE statement David G. Johnston 14:43

Sept. 11, 2022

Thread Author Time
RE: Excessive number of replication slots for 12->14 logical replication 📎 houzj.fnst@fujitsu.com 14:55

Sept. 12, 2022

Thread Author Time
Re: foreign join error "variable not found in subplan target list" 📎 Etsuro Fujita 04:20
Re: Excessive number of replication slots for 12->14 logical replication Masahiko Sawada 04:51
Re: Excessive number of replication slots for 12->14 logical replication 📎 Amit Kapila 06:15
RE: Excessive number of replication slots for 12->14 logical replication houzj.fnst@fujitsu.com 06:51
Re: Excessive number of replication slots for 12->14 logical replication Masahiko Sawada 06:55
BUG #17612: Error on your site PG Bug reporting form 07:01
BUG #17613: in the postgresql 15beta4,there are lack of many extensions PG Bug reporting form 09:28
Re: Excessive number of replication slots for 12->14 logical replication Amit Kapila 10:37
Re: BUG #17613: in the postgresql 15beta4,there are lack of many extensions Tom Lane 14:17
Re:Re: BUG #17613: in the postgresql 15beta4,there are lack of many extensions yanliang lei 15:17

Sept. 13, 2022

Thread Author Time
Re: foreign join error "variable not found in subplan target list" Richard Guo 02:28
Re: BUG #17611: SJIS conversion rule about duplicated characters differ from Windows Kyotaro Horiguchi 03:47
RE: huge memory of Postgresql backend process James Pang (chaolpan) 08:50
Re: BUG #17612: Error on your site Daniel Gustafsson 08:58
Re: BUG #17612: Error on your site Daniel Gustafsson 09:13

Sept. 14, 2022

Thread Author Time
Re: foreign join error "variable not found in subplan target list" Etsuro Fujita 10:01
CVE-2022-2625 misha1966 misha1966 13:09
Re: BUG #17613: in the postgresql 15beta4,there are lack of many extensions Jonathan S. Katz 13:18
Re: CVE-2022-2625 David G. Johnston 13:44

Sept. 15, 2022

Thread Author Time
BUG #17614: "variable not found in subplan target lists" on grouping query PG Bug reporting form 12:35
unexpected results when attempting to define and use column with data type SERIAL Michael Rosinger 14:43
Re: unexpected results when attempting to define and use column with data type SERIAL Tom Lane 15:49
Re: Regression in pipeline mode in libpq 14.5 Alvaro Herrera 16:20
BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae PG Bug reporting form 16:24
Re: BUG #17614: "variable not found in subplan target lists" on grouping query Tom Lane 19:23
Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae Tom Lane 19:33
Re: huge memory of Postgresql backend process David Rowley 21:29
Re: huge memory of Postgresql backend process David Rowley 21:38
Re: huge memory of Postgresql backend process David Rowley 21:45
Re: PANIC in heap_delete during ALTER TABLE Jeff Davis 22:25
Re: PANIC in heap_delete during ALTER TABLE Peter Geoghegan 22:39

Sept. 16, 2022

Thread Author Time
Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae Souvik Chatterjee 02:17
Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae Tom Lane 03:09
Re: BUG #15660: pg_dump memory leaks when dumping LOBs Michael Banck 08:59
BUG #17616: Silently skipping to update data to the database with owner privileges using flyway scripts PG Bug reporting form 10:00
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 12:51
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Tom Lane 14:29
Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae Francisco Olarte 14:33
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 14:36
Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae Souvik Chatterjee 15:48
Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae Tom Lane 16:06
Re: BUG #17610: Use of multiple composite types incompatible with record-typed function parameter Tom Lane 17:28

Sept. 17, 2022

Thread Author Time
error: #error PostgreSQL does not have native spinlock support on this platform. error: unknown type name ‘slock_t’ 大坏蛋! 06:38
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 06:41
Bug in pg_upgrade live check right after starting the old server on Windows 📎 Marina Polyakova 12:12
Re: error: #error PostgreSQL does not have native spinlock support on this platform. error: unknown type name ‘slock_t’ Japin Li 12:44
Re: error: #error PostgreSQL does not have native spinlock support on this platform. error: unknown type name ‘slock_t’ Tom Lane 14:51

Sept. 19, 2022

Thread Author Time
BUG #17618: unnecessary filter column <> text even after adding index PG Bug reporting form 14:28
Re: BUG #17618: unnecessary filter column <> text even after adding index Tom Lane 15:24
Re: BUG #17618: unnecessary filter column <> text even after adding index Sindy Senorita 15:45
Re: BUG #17618: unnecessary filter column <> text even after adding index David G. Johnston 15:53
apparent loss of database access permissions 📎 eponymous alias 19:18
Re: apparent loss of database access permissions Tom Lane 20:11
Re: apparent loss of database access permissions eponymous alias 23:56

Sept. 20, 2022

Thread Author Time
Re: BUG #17618: unnecessary filter column <> text even after adding index Jeff Janes 17:12
Re: PANIC in heap_delete during ALTER TABLE Jeff Davis 18:32
Re: BUG #17618: unnecessary filter column <> text even after adding index Tom Lane 19:14
Re: BUG #17618: unnecessary filter column <> text even after adding index Tom Lane 23:55

Sept. 21, 2022

Thread Author Time
Re: PANIC in heap_delete during ALTER TABLE Michael Paquier 05:46
The keyword in the procedure's error message is "function", which should be "procedure" qtds_126 09:05
Re: PANIC in heap_delete during ALTER TABLE Robins Tharakan 11:18
Re: The keyword in the procedure's error message is "function", which should be "procedure" Junwang Zhao 11:46
Re: The keyword in the procedure's error message is "function", which should be "procedure" Junwang Zhao 15:05
BUG #17619: AllocSizeIsValid violation in parallel hash join PG Bug reporting form 15:57

Sept. 22, 2022

Thread Author Time
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end 📎 Masahiko Sawada 02:03
Re: The keyword in the procedure's error message is "function", which should be "procedure" qtds_126 06:53
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Thomas Munro 08:44
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Dmitry Astapov 12:51
BUG #17620: JIT-Compiler causes Segmentation Fault PG Bug reporting form 15:52
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Dmitry Astapov 16:11
BUG #17621: PostgreSQL 15 Windows installer still downloads Beta 3 PG Bug reporting form 16:34
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Dmitry Astapov 16:38
Re: Regression in pipeline mode in libpq 14.5 📎 Alvaro Herrera 17:31
Re: PANIC in heap_delete during ALTER TABLE Jeff Davis 18:47
Re: PANIC in heap_delete during ALTER TABLE Peter Geoghegan 19:02
Re: BUG #17621: PostgreSQL 15 Windows installer still downloads Beta 3 Fahar Abbas 19:33

Sept. 23, 2022

Thread Author Time
Re: BUG #17620: JIT-Compiler causes Segmentation Fault Andres Freund 00:12
AW: [EXT] Re: BUG #17620: JIT-Compiler causes Segmentation Fault 📎 Marcel Spitz 08:10
Re: BUG #17618: unnecessary filter column <> text even after adding index 📎 Richard Guo 13:29
Re: BUG #17618: unnecessary filter column <> text even after adding index Tom Lane 14:10
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join 📎 Thomas Munro 23:00
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Tom Lane 23:19
Re: BUG #17618: unnecessary filter column <> text even after adding index Richard Guo 23:54

Sept. 24, 2022

Thread Author Time
Re: BUG #17618: unnecessary filter column <> text even after adding index Tom Lane 00:04
Re: BUG #17618: unnecessary filter column <> text even after adding index Richard Guo 00:06
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Thomas Munro 00:10
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Peter Geoghegan 00:12
Re: BUG #17618: unnecessary filter column <> text even after adding index Richard Guo 00:41
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Peter Geoghegan 01:31
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end 📎 Tom Lane 20:57

Sept. 25, 2022

Thread Author Time
Re: BUG #17607: Server process crashes when PLpgSQL function raises error in subtransaction 📎 Tom Lane 18:24
Re: BUG #17607: Server process crashes when PLpgSQL function raises error in subtransaction 📎 Tom Lane 19:01
Re: BUG #17607: Server process crashes when PLpgSQL function raises error in subtransaction 📎 Tom Lane 20:34

Sept. 26, 2022

Thread Author Time
BUG #17622: a potential bug of NPD PG Bug reporting form 03:00
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Michael Paquier 03:40
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 04:07
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 04:16
Re: pg_rewind WAL segments deletion pitfall Alexander Kukushkin 07:08
Read Replica Inconsistencies Giuliano Sofi 09:06
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Michael Paquier 09:54
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 10:59
Re: BUG #17618: unnecessary filter column <> text even after adding index 📎 Richard Guo 11:42

Sept. 27, 2022

Thread Author Time
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end 📎 Masahiko Sawada 01:26
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Michael Paquier 03:39
Re: pg_rewind WAL segments deletion pitfall Kyotaro Horiguchi 07:50
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 13:56
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 15:51
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Peter Geoghegan 16:13
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Tom Lane 16:24
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Peter Geoghegan 16:40
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Tom Lane 16:44
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Peter Geoghegan 16:55
Function modification visibility in parallel connection 📎 Семёнов Михаил 17:01
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Peter Geoghegan 17:58
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join 📎 Peter Geoghegan 18:32
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Thomas Munro 19:15
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join Peter Geoghegan 21:16
Re: Function modification visibility in parallel connection Tom Lane 23:24

Sept. 28, 2022

Thread Author Time
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Masahiko Sawada 02:23
Re: pg_rewind WAL segments deletion pitfall Polina Bungina 08:09
Re: pg_rewind WAL segments deletion pitfall Kyotaro Horiguchi 09:17
BUG #17623: WHERE should be evaluated after FROM clause when operators may throw PG Bug reporting form 12:22
Re: [BUG] Crash of logical replica with trigger. 📎 Masahiko Sawada 13:33
Re: BUG #17623: WHERE should be evaluated after FROM clause when operators may throw David G. Johnston 13:56
Re: BUG #17623: WHERE should be evaluated after FROM clause when operators may throw Tom Lane 14:37
Re: BUG #17623: WHERE should be evaluated after FROM clause when operators may throw Stamatis Zampetakis 15:44
Possible bug with SKIP LOCKED behaviour Glen Mailer 16:28

Sept. 29, 2022

Thread Author Time
Re: Possible bug with SKIP LOCKED behaviour Zhang Mingli 02:41

Browse Archives

Prev | Next