pgsql-bugs since 2023-05-16 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 16, 2023

Thread Author Time
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) 📎 Tom Lane 00:03
Re: BUG #17932: Cannot select big bytea values(>500MB) John Naylor 01:58
Re: BUG #17931: Faild to stop PostgresSQL Service Manika Singhal 06:22
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) Richard Guo 06:22
BUG #17934: Cannot run pgAdmin after upgrading from 15.2 to 15.3 PG Bug reporting form 08:55
Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar 08:58
XML element with special characters can be created, serialized, but not deserialized Sergiu Ignat 10:02
Re: BUG #17911: Database or JDBC Driver Provides Incorrect Type Dave Cramer 11:43
BUG #17935: Incorrect memory access in fuzzystrmatch/difference() PG Bug reporting form 13:00
BUG #17936: Memory Leak when OPERATOR FAMILY use LANGUAGE SQL function PG Bug reporting form 13:16
Re: Memory leak on subquery as scalar operand 📎 Daniel Gustafsson 13:31
Re: BUG #17936: Memory Leak when OPERATOR FAMILY use LANGUAGE SQL function Tom Lane 13:52
Re: BUG #17935: Incorrect memory access in fuzzystrmatch/difference() Tom Lane 14:23
Re: XML element with special characters can be created, serialized, but not deserialized Tom Lane 15:21
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) Tom Lane 19:23
RE: BUG #17911: Database or JDBC Driver Provides Incorrect Type 📎 PostgreSQL 20:09
Re: BUG #17911: Database or JDBC Driver Provides Incorrect Type Dave Cramer 22:28

May 17, 2023

Thread Author Time
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) 📎 Tom Lane 03:10
Re: BUG #17884: gist_page_items() crashes for a non-leaf page of an index with non-key columns 📎 Michael Paquier 05:23
Re: BUG #17695: Failed Assert in logical replication snapbuild. 📎 Masahiko Sawada 05:34
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) 📎 Richard Guo 08:29
BUG #17937: Corrupt Indexes after reusing DRBD Device on new VM PG Bug reporting form 09:42
Re: AW: BUG #17923: Excessive warnings of collation version mismatch in logs Peter Eisentraut 12:41
Re: BUG #17937: Corrupt Indexes after reusing DRBD Device on new VM Joe Conway 13:27
Re: BUG #17884: gist_page_items() crashes for a non-leaf page of an index with non-key columns 📎 Alexander Lakhin 14:00
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) Tom Lane 15:28
Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes 23:43
Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane 23:50

May 18, 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 01:50
Re: BUG #17884: gist_page_items() crashes for a non-leaf page of an index with non-key columns Michael Paquier 04:01
Re: BUG #17884: gist_page_items() crashes for a non-leaf page of an index with non-key columns Alexander Lakhin 06:00
Re: BUG #17884: gist_page_items() crashes for a non-leaf page of an index with non-key columns Michael Paquier 07:16
Re: BUG #17932: Cannot select big bytea values(>500MB) duc hiep ha 07:23
Error logged starting postgresql in Fedora 38 Kieran McCusker 08:43
llvmjit.so: undefined symbol: LLVMBuildGEP Fedora 38 Kieran McCusker 08:46
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) 📎 Richard Guo 08:58
Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) Tom Lane 13:28
Re: BUG #17695: Failed Assert in logical replication snapbuild. Alexander Lakhin 14:00
Re: llvmjit.so: undefined symbol: LLVMBuildGEP Fedora 38 Thomas Munro 22:15

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

Browse Archives

Prev | Next