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

Jan. 1, 2024

Thread Author Time
Re: Segmentation fault caused by Postgrest - reateplan.c:6178 - prepare_sort_from_pathkeys Michael B. Williams 13:04
Re: Segmentation fault caused by Postgrest - reateplan.c:6178 - prepare_sort_from_pathkeys Magnus Hagander 15:14

Jan. 2, 2024

Thread Author Time
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Richard Guo 01:43
Re: Segmentation fault caused by Postgrest - reateplan.c:6178 - prepare_sort_from_pathkeys John Naylor 03:18
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries 📎 Alexander Korotkov 08:02
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Alexander Korotkov 08:08
BUG #18265: jsonb comparison order is inconsistent PG Bug reporting form 09:09
Re: BUG #18252: Assert in CheckOpSlotCompatibility() fails when recursive union filters tuples in non-recursive term Peter Eisentraut 09:22
lost status 'STATUS_EOF' for authentication when using 'MD5' or 'scram-sha-256' liulang 10:31
BUG #18266: Restore process request way too many archive log files via pgbackrest PG Bug reporting form 13:38
Postgres 16.1 - Bug: cache entry already complete Amadeo Gallardo 15:36
Re: Out of the box, full text search feature suggestion for postgresql Artur Zakirov 17:20
Re: Postgres 16.1 - Bug: cache entry already complete Tom Lane 17:31
Re: Out of the box, full text search feature suggestion for postgresql aa 17:56
Re: Postgres 16.1 - Bug: cache entry already complete Amadeo Gallardo 19:51
Re: lost status 'STATUS_EOF' for authentication when using 'MD5' or 'scram-sha-256' Tom Lane 20:28
Re: Postgres 16.1 - Bug: cache entry already complete 📎 Amadeo Gallardo 23:48
Re: Postgres 16.1 - Bug: cache entry already complete David Rowley 23:59

Jan. 3, 2024

Thread Author Time
Re: Postgres 16.1 - Bug: cache entry already complete Tom Lane 00:05
Re: Postgres 16.1 - Bug: cache entry already complete David Rowley 00:40
Re: Postgres 16.1 - Bug: cache entry already complete 📎 David Rowley 01:47
Re: Postgres 16.1 - Bug: cache entry already complete Richard Guo 02:36
Re: Postgres 16.1 - Bug: cache entry already complete Tom Lane 03:05
Re: [16+] subscription can end up in inconsistent state Jeff Davis 03:51
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Andrei Lepikhov 05:56
Re: BUG #18259: Assertion in ExtendBufferedRelLocal() fails after no-space-left condition tender wang 06:46
Re: Postgres 16.1 - Bug: cache entry already complete 📎 Richard Guo 11:01
BUG #18267: Logical replication bug: data is not synchronized after Alter Publication. PG Bug reporting form 12:06
Bugreport: incorrect result in 16.1 in query with string_agg(distinct+json_build_object Oscar van Baten 16:15
BUG #18268: Failed to validate GPG signature for pgdg-redhat-repo-42.0-38PGDG.noarch PG Bug reporting form 16:55
Re: Bugreport: incorrect result in 16.1 in query with string_agg(distinct+json_build_object Tom Lane 16:56
Re: Bugreport: incorrect result in 16.1 in query with string_agg(distinct+json_build_object Oscar van Baten 18:01
Re: Bugreport: incorrect result in 16.1 in query with string_agg(distinct+json_build_object Oscar van Baten 18:19
Re: Bugreport: incorrect result in 16.1 in query with string_agg(distinct+json_build_object Tom Lane 18:20
BUG #18269: RPM key descrepency PG Bug reporting form 19:46
Re: BUG #18269: RPM key descrepency Dale Wellman 21:11
Re: BUG #18269: RPM key descrepency Devrim Gündüz 21:34
Re: BUG #18268: Failed to validate GPG signature for pgdg-redhat-repo-42.0-38PGDG.noarch Devrim Gündüz 21:53

Jan. 4, 2024

Thread Author Time
Re: BUG #18259: Assertion in ExtendBufferedRelLocal() fails after no-space-left condition Michael Paquier 00:40
Re: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication. Amit Kapila 06:27
Re: BUG #18264: Table has type text, but query expects integer.attribute 1 of type record has wrong type David Rowley 07:43
Re: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication. Dilip Kumar 10:13
Re: Postgres 16.1 - Bug: cache entry already complete David Rowley 12:04
BUG #18270: RPM signing GPG key URL changed 2024-01-03 PG Bug reporting form 13:20
Re: BUG #18270: RPM signing GPG key URL changed 2024-01-03 Devrim Gündüz 14:46
Re: BUG #18259: Assertion in ExtendBufferedRelLocal() fails after no-space-left condition Andres Freund 18:56
Postgres policy exists bug AC4G 21:17
Re: BUG #18259: Assertion in ExtendBufferedRelLocal() fails after no-space-left condition Michael Paquier 23:45

Jan. 5, 2024

Thread Author Time
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries 📎 Andrei Lepikhov 03:32
RE: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication. 📎 Hayato Kuroda (Fujitsu) 03:54
Fwd: BUG #18259: Assertion in ExtendBufferedRelLocal() fails after no-space-left condition tender wang 03:55
Re: BUG #18259: Assertion in ExtendBufferedRelLocal() fails after no-space-left condition Michael Paquier 11:28
BUG #18271: Re: Postgres policy exists bug PG Bug reporting form 14:05
Re: BUG #18271: Re: Postgres policy exists bug Tom Lane 15:14
Re: BUG #18271: Re: Postgres policy exists bug 📎 Wladimir 15:52
Re: BUG #18264: Table has type text, but query expects integer.attribute 1 of type record has wrong type Vojtěch Beneš 17:39
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Robert Haas 17:56
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 18:19
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Robert Haas 21:18
BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4 PG Bug reporting form 21:45

Jan. 6, 2024

Thread Author Time
Re: BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4 Tom Lane 02:09
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Alexander Korotkov 12:44
Ynt: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language Murat Topcu 15:43
BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language Koray Yavuz 16:18
BUG #18273: Incorrect memory access occurs when gist__int index is building on data containing 2^31-1 PG Bug reporting form 19:00
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Noah Misch 20:24
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 21:30
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 21:41
BUG #18274: Error 'invalid XML content' PG Bug reporting form 22:20
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Noah Misch 22:44

Jan. 7, 2024

Thread Author Time
Re: BUG #16925: ERROR: invalid DSA memory alloc request size 1073741824 CONTEXT: parallel worker Alexander Korotkov 07:31
BUG #18276: Heap-buffer-overflow triggered in src/backend/utils/adt/datum.c:163 PG Bug reporting form 17:50
Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum 📎 Andrey M. Borodin 18:04
Re: BUG #18274: Error 'invalid XML content' Tom Lane 18:18
Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum Andrey M. Borodin 18:33
Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum Alexander Lakhin 19:00
Re: BUG #18276: Heap-buffer-overflow triggered in src/backend/utils/adt/datum.c:163 Andrey M. Borodin 19:00
Re: BUG #18276: Heap-buffer-overflow triggered in src/backend/utils/adt/datum.c:163 Zu-Ming Jiang 19:08
Re: BUG #18276: Heap-buffer-overflow triggered in src/backend/utils/adt/datum.c:163 Tom Lane 19:16
Re: BUG #18276: Heap-buffer-overflow triggered in src/backend/utils/adt/datum.c:163 Zu-Ming Jiang 19:28
Re: BUG #18273: Incorrect memory access occurs when gist__int index is building on data containing 2^31-1 Tom Lane 19:42
Re: BUG #18276: Heap-buffer-overflow triggered in src/backend/utils/adt/datum.c:163 Tom Lane 19:47
Re: BUG #18276: Heap-buffer-overflow triggered in src/backend/utils/adt/datum.c:163 Zu-Ming Jiang 20:15

Jan. 8, 2024

Thread Author Time
Re: BUG #18259: Assertion in ExtendBufferedRelLocal() fails after no-space-left condition tender wang 02:33
Re: "unexpected duplicate for tablespace" problem in logical replication vignesh C 05:02
Re: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication. Dilip Kumar 05:13
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger 📎 Alexander Lakhin 08:00
centos7 setup - repomd.xml signature could not be verified for pgdg-common Kieren Diment 08:40
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Richard Guo 11:50
Re: centos7 setup - repomd.xml signature could not be verified for pgdg-common Devrim Gündüz 12:29
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Alexander Korotkov 12:49
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Alexander Korotkov 13:10
Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum Andrey M. Borodin 14:34
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Alexander Korotkov 15:40
Wrong datatype in docs for wal_summary_keep_time hubert depesz lubaczewski 16:37
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 17:02
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Noah Misch 18:21
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 18:36
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Robert Haas 19:46
BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func PG Bug reporting form 21:09
Re: BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func Tom Lane 22:59
Re: Wrong datatype in docs for wal_summary_keep_time Nathan Bossart 23:23

Jan. 9, 2024

Thread Author Time
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries Andrei Lepikhov 00:27
Re: Wrong datatype in docs for wal_summary_keep_time 📎 Nathan Bossart 03:47
RE: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication. Hayato Kuroda (Fujitsu) 04:15
Re: BUG #18259: Assertion in ExtendBufferedRelLocal() fails after no-space-left condition Andres Freund 04:21
Re: BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func 📎 Richard Guo 07:35
Re: Wrong datatype in docs for wal_summary_keep_time Nathan Bossart 17:38
Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum 📎 Michael Zhilin 17:59
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 20:59
Re: BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func Tom Lane 21:34
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Noah Misch 21:44
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 23:16

Jan. 10, 2024

Thread Author Time
Re: BUG #18252: Assert in CheckOpSlotCompatibility() fails when recursive union filters tuples in non-recursive term Richard Guo 07:44
Re: BUG #18252: Assert in CheckOpSlotCompatibility() fails when recursive union filters tuples in non-recursive term Richard Guo 07:46
BUG #18279: Duplicate key violation and Deadlock when using ON CONFLICT/DO UPDATE with multiple unique indexes PG Bug reporting form 09:12
BUG #18280: logical decoding build wrong snapshot for subtransactions PG Bug reporting form 12:51
BUG #18281: Superuser can rename the schema with the prefix "pg_" (Applies to all versions of postgresql) PG Bug reporting form 13:41
Re:BUG #18280: logical decoding build wrong snapshot for subtransactions 📎 feichanghong 13:56
Re: BUG #18281: Superuser can rename the schema with the prefix "pg_" (Applies to all versions of postgresql) David G. Johnston 13:59
Re: BUG #18279: Duplicate key violation and Deadlock when using ON CONFLICT/DO UPDATE with multiple unique indexes Peter Geoghegan 15:11
Re: BUG #18281: Superuser can rename the schema with the prefix "pg_" (Applies to all versions of postgresql) Tom Lane 16:45
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger 📎 Alexander Lakhin 18:00
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 19:06
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Noah Misch 19:38
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Peter Geoghegan 19:57
BUG #18282: repomd.xml signature could not be verified for pgdg-common PG Bug reporting form 20:01
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Robert Haas 20:04
Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() Noah Misch 21:15

Jan. 11, 2024

Thread Author Time
Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends 📎 Michael Paquier 01:12
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Alexander Lakhin 03:00
Re: Postgres 16.1 - Bug: cache entry already complete Richard Guo 03:26
BUG #18283: vacuum full use a large amount of memory (may cause OOM) PG Bug reporting form 06:47
Re: BUG #18279: Duplicate key violation and Deadlock when using ON CONFLICT/DO UPDATE with multiple unique indexes 노영은 08:24
Re: BUG #18260: Unexpected error: "negative bitmapset member not allowed" triggered by multiple JOIN 📎 Richard Guo 09:08
Re: BUG #18282: repomd.xml signature could not be verified for pgdg-common Devrim Gündüz 09:52
BUG #18284: Filter in left lateral join not respected PG Bug reporting form 14:34
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Robert Haas 14:34
Re: BUG #18284: Filter in left lateral join not respected Tom Lane 16:01
Re: BUG #18284: Filter in left lateral join not respected 📎 Tom Lane 17:30
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Tom Lane 21:43
BUG #18285: pgdg.list doesn't work PG Bug reporting form 22:44

Jan. 12, 2024

Thread Author Time
Re: BUG #18280: logical decoding build wrong snapshot for subtransactions Andy Fan 02:00
Re: BUG #18284: Filter in left lateral join not respected Richard Guo 06:50
BUG #18286: "ERROR: could not open relation with OID 16391" error was encountered when reindexing PG Bug reporting form 08:37
Re: "unexpected duplicate for tablespace" problem in logical replication 📎 Kyotaro Horiguchi 08:37
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Alexander Lakhin 13:00
BUG #18287: pg_restore with -C and -c options does not do what is said in the documentation PG Bug reporting form 14:35
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Robert Haas 14:56
Re: BUG #18284: Filter in left lateral join not respected Tom Lane 14:59
Re: BUG #18287: pg_restore with -C and -c options does not do what is said in the documentation David G. Johnston 15:31
Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends Jonathan S. Katz 16:19
Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends Tom Lane 16:33
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Alexander Lakhin 17:00
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Tom Lane 17:28
BUG #18289: postgresql14-devel-14.10-2PGDG.rhel8.x86_64.rpm Contains invalid cLang option in Makefile.global PG Bug reporting form 17:57
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Robert Haas 20:26
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Tom Lane 20:52
Re: [16+] subscription can end up in inconsistent state Jeff Davis 21:55

Jan. 13, 2024

Thread Author Time
Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends Jonathan S. Katz 03:50
Re: BUG #18289: postgresql14-devel-14.10-2PGDG.rhel8.x86_64.rpm Contains invalid cLang option in Makefile.global Thomas Munro 04:33
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger 📎 Tom Lane 23:29

Jan. 14, 2024

Thread Author Time
Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends Michael Paquier 00:55
BUG #18290: \di+ can not show the same name indexes PG Bug reporting form 06:57
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Alexander Lakhin 12:00
Re: BUG #18290: \di+ can not show the same name indexes Tom Lane 15:57
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Tom Lane 17:39
Re: BUG #18274: Error 'invalid XML content' 📎 Dmitry Koval 18:28
BUG #18292: Unexpected error: "relation "hobbies_r" does not exist" caused by user-defined functions PG Bug reporting form 18:48
Re: BUG #18274: Error 'invalid XML content' Tom Lane 19:17
Re: BUG #18274: Error 'invalid XML content' Dmitry Koval 20:58
Re: BUG #18274: Error 'invalid XML content' Michael Paquier 23:34

Jan. 15, 2024

Thread Author Time
Re: BUG #18260: Unexpected error: "negative bitmapset member not allowed" triggered by multiple JOIN Andrei Lepikhov 00:20
Re: BUG #18260: Unexpected error: "negative bitmapset member not allowed" triggered by multiple JOIN Alexander Korotkov 00:34
Re: BUG #18290: \di+ can not show the same name indexes jian he 01:08
Re: BUG #18292: Unexpected error: "relation "hobbies_r" does not exist" caused by user-defined functions Tom Lane 02:57
Re: BUG #18274: Error 'invalid XML content' Tom Lane 03:16
Re: BUG #18274: Error 'invalid XML content' Michael Paquier 04:18
Re: BUG #18292: Unexpected error: "relation "hobbies_r" does not exist" caused by user-defined functions Zu-Ming Jiang 07:48
Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends Michael Paquier 07:54
BUG #18293: Rocky 8 postgres install failing as nothing provides libarmadillo.so.10()(64bit) PG Bug reporting form 10:19
BUG #18294: Manual savepoints do not work with JDBC param cleanupSavepoints=true PG Bug reporting form 10:30
BUG #18295: In PostgreSQL a unique index on targeted columns is sufficient to support a foreign key PG Bug reporting form 11:37
Re: BUG #18293: Rocky 8 postgres install failing as nothing provides libarmadillo.so.10()(64bit) Devrim Gündüz 12:06
RE: Re:Re: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication. 📎 Hayato Kuroda (Fujitsu) 12:58
Re: BUG #18289: postgresql14-devel-14.10-2PGDG.rhel8.x86_64.rpm Contains invalid cLang option in Makefile.global Devrim Gündüz 15:23
Re: BUG #18274: Error 'invalid XML content' Dmitry Koval 15:47
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Robert Haas 16:08
Re: [16+] subscription can end up in inconsistent state vignesh C 16:17
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger Tom Lane 16:29
Re: "unexpected duplicate for tablespace" problem in logical replication Robert Haas 21:32

Jan. 16, 2024

Thread Author Time
Re: "unexpected duplicate for tablespace" problem in logical replication 📎 Kyotaro Horiguchi 01:58
BUG #18296: ARM PG Bug reporting form 02:21
BUG #18297: Error when adding a column to a parent table with complex inheritance PG Bug reporting form 04:00
Re: BUG #18274: Error 'invalid XML content' Michael Paquier 09:14
BUG #18298: some possible issues in postgres10.23 that caused the crash PG Bug reporting form 09:23
bug in polish translation Realizacja Casa Dinero 10:58
Re: BUG #18298: some possible issues in postgres10.23 that caused the crash David G. Johnston 13:12
Fwd: bug in polish translation Daniel Gustafsson 13:38
Re: BUG #18274: Error 'invalid XML content' 📎 Dmitry Koval 13:55

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