pgsql-bugs since 2023-05-19 00:00

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

May 19, 2023

Thread Author Time
Re: BUG #17884: gist_page_items() crashes for a non-leaf page of an index with non-key columns Michael Paquier 05:41
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) Richard Guo 07:34
Server crash with parallel workers with Postgres 14.7 José Lorenzo Urdaneta Rodriguez 09:14
initdb faild to initialize full text search dictionaries Les 10:29
Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN sulfinu 12:46
Re: Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN sulfinu 13:21
Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar 13:25
Re: Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN Tom Lane 14:14
Re: Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN David G. Johnston 14:36
Re: Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN Tom Lane 15:12
Re: Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN David G. Johnston 15:46
Re: Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN sulfinu 16:59
Re: Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN sulfinu 17:03
Re: BUG #17919: "client hello" message / SNI / Openshift Routes Magnus Hagander 17:18
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) Tom Lane 18:50
Re: initdb faild to initialize full text search dictionaries Tom Lane 19:55
Re: Aggregation results with json(b)_agg and array_agg in a SELECT with OUTER JOIN David G. Johnston 20:14

May 20, 2023

Thread Author Time
ERROR: CREATE DATABASE cannot be executed within a pipeline 396934406 02:06
Re: ERROR: CREATE DATABASE cannot be executed within a pipeline Tom Lane 02:17

May 21, 2023

Thread Author Time
How to restore database without re-write database and tables owner by using postgres Cidy Long 00:24
Re: BUG #17934: Cannot run pgAdmin after upgrading from 15.2 to 15.3 Sandeep Thakkar 03:38

May 22, 2023

Thread Author Time
Re: BUG #17695: Failed Assert in logical replication snapbuild. Masahiko Sawada 00:56
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) Andrey Lepikhov 06:07
AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs Hans Buschmann 07:11
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) Tom Lane 13:40
Re: How to restore database without re-write database and tables owner by using postgres David G. Johnston 13:42
Re: BUG #17698: On SIGTERM, psql terminates, but leaves the statement running Tristan Partin 17:04
BUG #17938: could not open shared memory segment "/PostgreSQL.615216676": No such file or directory PG Bug reporting form 18:10
Re: BUG #17938: could not open shared memory segment "/PostgreSQL.615216676": No such file or directory Michael Paquier 22:43

May 23, 2023

Thread Author Time
RE: Logical Replica ReorderBuffer Size Accounting Issues 📎 Wei Wang (Fujitsu) 04:11
BUG #17939: CREATE EXTENSION pltcl; looks in the wrong folder PG Bug reporting form 06:47
Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN Alexey Kachalin 07:00
Re: BUG #17939: CREATE EXTENSION pltcl; looks in the wrong folder Julien Rouhaud 07:04
Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera 08:48
Re: Need Support to Upgrade from 13.6 to 15.3 📎 Dippu Kumar 09:20
RE: BUG #17919: "client hello" message / SNI / Openshift Routes Ronald Van de Kuil 09:22
Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera 09:28
Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar 09:31
RE: BUG #17919: "client hello" message / SNI / Openshift Routes Ronald Van de Kuil 09:42
Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera 09:45
Re: BUG #17695: Failed Assert in logical replication snapbuild. Alexander Lakhin 11:00
Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar 11:20
Re: Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN Tom Lane 14:07
Re: AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs Peter Eisentraut 16:18
BUG #17940: PostgreSQL Installer For Windows Cannot Initialize Cluster When BeyondTrust Installed PG Bug reporting form 20:50
Re: BUG #17940: PostgreSQL Installer For Windows Cannot Initialize Cluster When BeyondTrust Installed David G. Johnston 21:46
RE: BUG #17940: PostgreSQL Installer For Windows Cannot Initialize Cluster When BeyondTrust Installed Joel Rabinovitch 22:00

May 24, 2023

Thread Author Time
Re: BUG #17938: could not open shared memory segment "/PostgreSQL.615216676": No such file or directory Kyotaro Horiguchi 00:57
Re: BUG #17938: could not open shared memory segment "/PostgreSQL.615216676": No such file or directory Kyotaro Horiguchi 01:09
Re: Logical Replica ReorderBuffer Size Accounting Issues Masahiko Sawada 01:27
BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables PG Bug reporting form 06:41
RE: Logical Replica ReorderBuffer Size Accounting Issues Wei Wang (Fujitsu) 10:13
Re: Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN Alexey Kachalin 11:40
Re: Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN Pavel Borisov 13:02
Re: Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN Julien Rouhaud 13:15
Re: Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN David G. Johnston 13:22
BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore PG Bug reporting form 13:28
Re: Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN Alexey Kachalin 16:46
Re: Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN David G. Johnston 16:58

May 25, 2023

Thread Author Time
Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore Thomas Munro 03:20
Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables Kyotaro Horiguchi 04:07
AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore Hans Buschmann 07:12
AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore Hans Buschmann 07:30
Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables Michael Paquier 07:45
BUG #17944: Partial index on boolean field is not picked when using = while the index is created with is PG Bug reporting form 14:04
BUG #17945: Different order of definition of a constraint causes constraint violation PG Bug reporting form 14:39
BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG PG Bug reporting form 15:21
Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore Devrim Gündüz 17:21
Re: llvmjit.so: undefined symbol: LLVMBuildGEP Fedora 38 Devrim Gündüz 17:24
Re: BUG #17944: Partial index on boolean field is not picked when using = while the index is created with is Tom Lane 19:20
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tom Lane 19:33

May 26, 2023

Thread Author Time
Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables Kyotaro Horiguchi 00:15
Comparing date strings with jsonpath expression Tim Field 01:36
Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables Michael Paquier 05:48
Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables Kyotaro Horiguchi 07:49
Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables Kyotaro Horiguchi 09:02
BUG #17947: Combination of replslots pgstat issues causes error/assertion failure PG Bug reporting form 11:00
Re: Comparing date strings with jsonpath expression Tom Lane 13:51
BUG #17948: libpq seems to misbehave in a pipelining corner case PG Bug reporting form 17:27

May 28, 2023

Thread Author Time
BUG #17949: Adding an index introduces serialisation anomalies. PG Bug reporting form 12:26

May 29, 2023

Thread Author Time
Re: Comparing date strings with jsonpath expression jian he 00:00
Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables Michael Paquier 05:23
Re: Server crash with parallel workers with Postgres 14.7 José Lorenzo Urdaneta Rodriguez 13:22
Re: BUG #17938: could not open shared memory segment "/PostgreSQL.615216676": No such file or directory 📎 Onkobu 14:56
Error pg_dump 📎 Federico Martella 15:11
BUG #17950: Incorrect memory access in gtsvector_picksplit() PG Bug reporting form 20:00

May 30, 2023

Thread Author Time
Re: BUG #17940: PostgreSQL Installer For Windows Cannot Initialize Cluster When BeyondTrust Installed Magnus Hagander 00:08
Re: BUG #17919: "client hello" message / SNI / Openshift Routes Magnus Hagander 00:11
Re: BUG #17949: Adding an index introduces serialisation anomalies. Thomas Munro 01:29
Suspicious Estimated Number of Returned Rows Ba Jinsheng 03:19
Re: Server crash with parallel workers with Postgres 14.7 Jaime Casanova 04:56
BUG #17951: hashtext('input') returning non-integer value for certain inputs PG Bug reporting form 07:07
Re: BUG #17951: hashtext('input') returning non-integer value for certain inputs Ilkka Kaakkola 07:55
Re: BUG #17938: could not open shared memory segment "/PostgreSQL.615216676": No such file or directory Michael Paquier 11:56

May 31, 2023

Thread Author Time
Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements 📎 Alexander Lakhin 06:00
Order of operations in postgreSQL. Ken McClaren 17:49
RE: Order of operations in postgreSQL. Wetmore, Matthew (CTR) 20:41
Re: BUG #17947: Combination of replslots pgstat issues causes error/assertion failure 📎 Kyotaro Horiguchi 23:42

June 1, 2023

Thread Author Time
Re: Order of operations in postgreSQL. Ken McClaren 00:21
Re: BUG #17940: PostgreSQL Installer For Windows Cannot Initialize Cluster When BeyondTrust Installed Sandeep Thakkar 06:42
BUG #17952: rhel-8-aarch64 yum repository for Postgres 14 is missing repodata PG Bug reporting form 08:19
BUG #17953: Libpq can stall indefinitely with non-tls localhost (127.0.0.1) connection PG Bug reporting form 11:27
BUG #17954: Postgres startup fails with `could not locate a valid checkpoint record` PG Bug reporting form 13:11
Re: Order of operations in postgreSQL. Tom Lane 13:51
Re: Order of operations in postgreSQL. Ken McClaren 14:40
Re: Order of operations in postgreSQL. Josh Innis 14:46
BUG #17956: proj90-debuginfo (proj90-debuginfo-9.0.1) CRC does not match proj90.so (proj90-9.0.1) CRC PG Bug reporting form 16:04
BUG #17957: psql-16beta1 \df+ does not show the function body PG Bug reporting form 17:57
BUG #17958: There was a error message while installing postgreSQL15 or 14 . PG Bug reporting form 19:11
Re: BUG #17957: psql-16beta1 \df+ does not show the function body Bruce Momjian 19:23
Re: BUG #17957: psql-16beta1 \df+ does not show the function body Tom Lane 22:18

June 2, 2023

Thread Author Time
Re: BUG #17957: psql-16beta1 \df+ does not show the function body 📎 Bruce Momjian 00:00
Re: BUG #17947: Combination of replslots pgstat issues causes error/assertion failure 📎 Kyotaro Horiguchi 21:34

June 3, 2023

Thread Author Time
Re: BUG #17945: Different order of definition of a constraint causes constraint violation Jeff Davis 16:23
BUG #17959: amcheck fails to find a matching index tuple for an invisible heap tuple PG Bug reporting form 19:00

June 4, 2023

Thread Author Time
Re: BUG #17953: Libpq can stall indefinitely with non-tls localhost (127.0.0.1) connection Heikki Linnakangas 00:36
BUG #17960: pg_dump does not backup generated columns correctly. PG Bug reporting form 12:20
BUG #17961: Incorrect aggregation MIN, AVG, MAX PG Bug reporting form 22:04
Array parsing incorrectly accepts ragged multidimensional arrays Nikhil Benesch 22:39
Re: Array parsing incorrectly accepts ragged multidimensional arrays Tom Lane 22:53

June 5, 2023

Thread Author Time
Re: Array parsing incorrectly accepts ragged multidimensional arrays Nikhil Benesch 01:02
Re: BUG #17961: Incorrect aggregation MIN, AVG, MAX Julien Rouhaud 07:40
Re: BUG #17961: Incorrect aggregation MIN, AVG, MAX Maxim Zakharov 07:46
Re: BUG #17959: amcheck fails to find a matching index tuple for an invisible heap tuple 📎 Alexander Lakhin 09:00
Re: BUG #16739: Temporary files not deleting from data folder on disk Adrien Nayrat 09:54
Re: BUG #16739: Temporary files not deleting from data folder on disk Adrien Nayrat 09:59
Re: BUG #16739: Temporary files not deleting from data folder on disk Dilip Kumar 10:14
Re: BUG #16739: Temporary files not deleting from data folder on disk Adrien Nayrat 10:40
Re: BUG #16739: Temporary files not deleting from data folder on disk Dilip Kumar 10:48
BUG #17962: postgresql 11 hangs on poly_contain with specific data PG Bug reporting form 11:34
Re: BUG #17960: pg_dump does not backup generated columns correctly. Tom Lane 12:53
Re: BUG #17956: proj90-debuginfo (proj90-debuginfo-9.0.1) CRC does not match proj90.so (proj90-9.0.1) CRC Devrim Gündüz 14:29
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Heikki Linnakangas 16:00
Re: BUG #17959: amcheck fails to find a matching index tuple for an invisible heap tuple Peter Geoghegan 16:20
Re: BUG #17959: amcheck fails to find a matching index tuple for an invisible heap tuple Peter Geoghegan 16:27

June 6, 2023

Thread Author Time
Re: BUG #17959: amcheck fails to find a matching index tuple for an invisible heap tuple Alexander Lakhin 03:00
Re: BUG #17962: postgresql 11 hangs on poly_contain with specific data 📎 Kyotaro Horiguchi 05:07
Re: BUG #17962: postgresql 11 hangs on poly_contain with specific data 📎 Kyotaro Horiguchi 05:17
BUG #17963: Recursive table cannot be referenced when using LEFT JOIN instead of LATERAL in recursive term PG Bug reporting form 08:32
Re: BUG #17962: postgresql 11 hangs on poly_contain with specific data Nikolay Shaplov 10:39
BUG #17964: Missed query planner optimization PG Bug reporting form 11:16
Re: BUG #17963: Recursive table cannot be referenced when using LEFT JOIN instead of LATERAL in recursive term Tom Lane 13:07
Re: BUG #17964: Missed query planner optimization David Rowley 21:32

June 7, 2023

Thread Author Time
BUG #17965: SIGSEGV from LLVM13 JIT when executing SQL. PG Bug reporting form 07:46
BUG #17967: [msvc-x86] Failed to build with error LNK2019: unresolved external symbol __BitScanReverse64 referen PG Bug reporting form 09:57
Re: BUG #17964: Missed query planner optimization Mathias Kunter 11:47
Re: BUG #17964: Missed query planner optimization David Rowley 12:36
Re: BUG #17967: [msvc-x86] Failed to build with error LNK2019: unresolved external symbol __BitScanReverse64 referen 📎 David Rowley 13:00
Re: BUG #17964: Missed query planner optimization Mathias Kunter 16:53
pg_dump assertion failure with "-n pg_catalog" 📎 Jeff Davis 17:36
Re: BUG #17967: [msvc-x86] Failed to build with error LNK2019: unresolved external symbol __BitScanReverse64 referen David Rowley 22:18

June 8, 2023

Thread Author Time
Re: BUG #17967: [msvc-x86] Failed to build with error LNK2019: unresolved external symbol __BitScanReverse64 referen Mo Youmiu 07:56

June 9, 2023

Thread Author Time
Re: BUG #17934: Cannot run pgAdmin after upgrading from 15.2 to 15.3 Manika Singhal 05:44
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 15:31
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 19:05

June 10, 2023

Thread Author Time
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 02:10
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Joe Conway 16:12
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tom Lane 18:42
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 19:07
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Joe Conway 19:28
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tom Lane 19:32

June 11, 2023

Thread Author Time
BUG #17968: installation PG Bug reporting form 08:28
BUG #17969: Assert failed in bloom_init() when false_positive_rate = 0.25 PG Bug reporting form 15:00
Re: BUG #17969: Assert failed in bloom_init() when false_positive_rate = 0.25 Tom Lane 17:03
Re: Comparing date strings with jsonpath expression 📎 Tom Lane 21:03

June 12, 2023

Thread Author Time
Re: BUG #17953: Libpq can stall indefinitely with non-tls localhost (127.0.0.1) connection Michael Paquier 01:28
Re: BUG #17954: Postgres startup fails with `could not locate a valid checkpoint record` Michael Paquier 04:56
Re: Server crash with parallel workers with Postgres 14.7 Michael Paquier 05:04
Re: BUG #17962: postgresql 11 hangs on poly_contain with specific data Michael Paquier 05:25
Re: pg_dump assertion failure with "-n pg_catalog" Michael Paquier 06:52
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Heikki Linnakangas 09:13
Re: BUG #17968: installation Manika Singhal 10:02
Re: BUG #17967: [msvc-x86] Failed to build with error LNK2019: unresolved external symbol __BitScanReverse64 referen Alvaro Herrera 10:54
Re: BUG #17962: postgresql 11 hangs on poly_contain with specific data Tom Lane 13:14
Re: BUG #17962: postgresql 11 hangs on poly_contain with specific data Nikolay Shaplov 14:06
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 14:44
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 21:28

June 13, 2023

Thread Author Time
Re: BUG #17949: Adding an index introduces serialisation anomalies. Artem Anisimov 08:00
BUG #17970: FEATURE REQUEST-allow re-adding GENERATED ALWAYS AS constraint to existing columns after removing it PG Bug reporting form 13:45
Re: BUG #17970: FEATURE REQUEST-allow re-adding GENERATED ALWAYS AS constraint to existing columns after removing it David G. Johnston 14:45
Re: BUG #17970: FEATURE REQUEST-allow re-adding GENERATED ALWAYS AS constraint to existing columns after removing it Tom Lane 15:12
BUG #17972: Assert failed in pull_varattnos_walker() for view with subquery and security qual PG Bug reporting form 16:00
Re: BUG #17972: Assert failed in pull_varattnos_walker() for view with subquery and security qual Tom Lane 20:06
BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon PG Bug reporting form 23:49

June 14, 2023

Thread Author Time
BUG #17974: Walsenders memory usage suddenly spike to 80G+ causing OOM and server reboot PG Bug reporting form 00:05
Re: BUG #17974: Walsenders memory usage suddenly spike to 80G+ causing OOM and server reboot Michael Paquier 01:23
Re: BUG #17888: Incorrect memory access in gist__int_ops for an input array with many elements Michael Paquier 04:21
BUG #17975: Nested Loop Index Scan returning wrong result PG Bug reporting form 15:17
BUG #17976: Inconsistent results of SELECT using CASE WHEN clause PG Bug reporting form 15:59
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Tristan Partin 16:42
Re: BUG #17975: Nested Loop Index Scan returning wrong result Andres Freund 20:36
Re: BUG #17975: Nested Loop Index Scan returning wrong result Peter Geoghegan 21:10
Re: BUG #17975: Nested Loop Index Scan returning wrong result Andres Freund 21:12
Re: BUG #17975: Nested Loop Index Scan returning wrong result Andres Freund 21:21
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Andres Freund 21:37
Re: BUG #17975: Nested Loop Index Scan returning wrong result Peter Geoghegan 21:38
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Andres Freund 21:57
Re: BUG #17974: Walsenders memory usage suddenly spike to 80G+ causing OOM and server reboot Andres Freund 22:15
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon 📎 Andres Freund 22:30
Re: BUG #17975: Nested Loop Index Scan returning wrong result Andres Freund 22:49

Browse Archives

Prev | Next