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

March 1, 2022

Thread Author Time
BUG #17422: Memory leak PG Bug reporting form 17:06
Re: BUG #17422: Memory leak Andres Freund 20:21

March 2, 2022

Thread Author Time
BUG #17424: Build failed on disabled GNUC in Clang environment CFLAGS= -O2 -fgnuc-version=0 PG Bug reporting form 10:50
RE: Reconnect a single connection used by multiple threads in embedded SQL in C application causes error. 📎 egashira.yusuke@fujitsu.com 12:43
Re: BUG #17424: Build failed on disabled GNUC in Clang environment CFLAGS= -O2 -fgnuc-version=0 Tom Lane 14:50

March 3, 2022

Thread Author Time
Re: Reconnect a single connection used by multiple threads in embedded SQL in C application causes error. Kyotaro Horiguchi 01:12
Cannot refresh materialized view concurrently if you have a column name called "mv" Rupert Agnew 14:53
Re: Cannot refresh materialized view concurrently if you have a column name called "mv" Bruce Momjian 17:51

March 4, 2022

Thread Author Time
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum 📎 Peter Geoghegan 00:22
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum 📎 Peter Geoghegan 03:31
AW: BUG #17393: Delete database after recovery with point-in-time is still missing datafiles Lorenz, Christopher 07:09
BUG #17425: Postgres service does not start if path to data folder ends with backslash. PG Bug reporting form 10:14
RE: Reconnect a single connection used by multiple threads in embedded SQL in C application causes error. 📎 egashira.yusuke@fujitsu.com 11:49

March 5, 2022

Thread Author Time
RE: BUG #17421: Core dump in ECPGdo() when calling PostgreSQL API from 32-bit client for RHEL8 hirose.masay-01@fujitsu.com 06:45
Re: BUG #17421: Core dump in ECPGdo() when calling PostgreSQL API from 32-bit client for RHEL8 Michael Paquier 10:29
Re: BUG #17421: Core dump in ECPGdo() when calling PostgreSQL API from 32-bit client for RHEL8 Tom Lane 15:19

March 6, 2022

Thread Author Time
BUG #17427: ERROR: cannot cast type bytea to bigint PG Bug reporting form 06:29
Re: BUG #17393: Delete database after recovery with point-in-time is still missing datafiles Julien Rouhaud 07:41
Re: BUG #17427: ERROR: cannot cast type bytea to bigint David G. Johnston 23:35

March 7, 2022

Thread Author Time
BUG #17428: last_value incorrect for uninitialized sequence PG Bug reporting form 00:31
Pg 15 devel crashes when fetching data from table using cursor hubert depesz lubaczewski 09:44
Re: BUG #17428: last_value incorrect for uninitialized sequence David G. Johnston 13:35
Re: BUG #17428: last_value incorrect for uninitialized sequence Tom Lane 14:48
Re: BUG #17428: last_value incorrect for uninitialized sequence Glen Edmonds 15:14
Re: BUG #17428: last_value incorrect for uninitialized sequence Tom Lane 15:23
Re: BUG #17428: last_value incorrect for uninitialized sequence David G. Johnston 15:40

March 8, 2022

Thread Author Time
Re: BUG #17401: REINDEX TABLE CONCURRENTLY creates a race condition on a streaming replica Andrey Borodin 15:44
Re: Bug plperl.c Mark Murawski 19:59
Re: Bug plperl.c Tom Lane 21:19

March 9, 2022

Thread Author Time
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Masahiko Sawada 02:26
2000 times performance drop after pg14 upgrade when JIT = 1 📎 Sergey Mirvoda 12:20
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 15:11
BUG #17431: How to change postgres path to recognize pearl installation PG Bug reporting form 17:47
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Masahiko Sawada 23:36

March 10, 2022

Thread Author Time
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund 00:25
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund 00:46
possible bug in xpath function 📎 Andrey Kapliev 14:07
BUG #17432: libraries are missing when installing postGIS in SLES15 SP3, some are part of SLES15 SP4 some not PG Bug reporting form 14:19
Re: [External] Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key Holly Roberts 14:35

March 11, 2022

Thread Author Time
Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key 📎 Tom Lane 00:37
Re: Pg 15 devel crashes when fetching data from table using cursor Andres Freund 00:50
Re: Pg 15 devel crashes when fetching data from table using cursor Peter Geoghegan 01:38
Re: Pg 15 devel crashes when fetching data from table using cursor Andres Freund 01:50
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum 📎 Peter Geoghegan 02:03
Re: Pg 15 devel crashes when fetching data from table using cursor Tom Lane 02:05
Re: Pg 15 devel crashes when fetching data from table using cursor Andres Freund 02:10
Re: Pg 15 devel crashes when fetching data from table using cursor Tom Lane 02:21
Re: Pg 15 devel crashes when fetching data from table using cursor Andres Freund 02:36
Re: Pg 15 devel crashes when fetching data from table using cursor Tom Lane 02:40
Re: Pg 15 devel crashes when fetching data from table using cursor Andres Freund 03:07
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund 03:13
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Peter Geoghegan 03:40
Re: Pg 15 devel crashes when fetching data from table using cursor Andres Freund 03:44
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund 03:46
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Peter Geoghegan 03:52
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund 04:08
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Peter Geoghegan 04:55
BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands PG Bug reporting form 11:11
Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key 📎 Japin Li 13:18
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end 📎 Masahiko Sawada 15:39
Re: possible bug in xpath function Tom Lane 15:53
Re: possible bug in xpath function Andrey Kapliev 16:09
Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key Tom Lane 17:23
Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key Tom Lane 17:37
Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key 📎 Tom Lane 18:29
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum 📎 Peter Geoghegan 18:42
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 19:53
BUG #17435: "add column if not exists" always adds new FK on the column PG Bug reporting form 23:43

March 12, 2022

Thread Author Time
Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key Japin Li 00:31
Re: BUG #17435: "add column if not exists" always adds new FK on the column Japin Li 13:50
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund 21:49
BUG #17436: Initializing and starting with Dockerfile fails PG Bug reporting form 23:40

March 13, 2022

Thread Author Time
Re: BUG #17436: Initializing and starting with Dockerfile fails Julien Rouhaud 02:04
Re: BUG #17436: Initializing and starting with Dockerfile fails David G. Johnston 02:24
Re: BUG #17436: Initializing and starting with Dockerfile fails Julien Rouhaud 02:53
BUG #17437: time spent in JIT is also attributed to function scan PG Bug reporting form 18:10

March 14, 2022

Thread Author Time
Docs for psql regarding default database name are incorrect David G. Johnston 00:15
Re: Reconnect a single connection used by multiple threads in embedded SQL in C application causes error. Noah Misch 07:08
Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key Michael Paquier 07:51
Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key Michael Paquier 08:08
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end 📎 Masahiko Sawada 08:12
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Kyotaro Horiguchi 08:30
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 13:45
BUG #17438: Logical replication hangs on master after huge DB load PG Bug reporting form 17:30
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Tom Lane 18:59
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Peter Geoghegan 19:05

March 15, 2022

Thread Author Time
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Kyotaro Horiguchi 02:33
BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE PG Bug reporting form 15:11
BUG #17440: not expected result from jsonb_path_query PG Bug reporting form 16:58
Re: BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE Tom Lane 18:33
Re: BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE Tom Lane 20:06
Re: BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE Tom Lane 21:18

March 16, 2022

Thread Author Time
Re: BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE Kevin Humphreys 01:46
Re: BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE Tom Lane 02:23
Re: BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE David G. Johnston 02:28
VACUUM can set pages all-frozen without also setting them all-visible 📎 Peter Geoghegan 07:24
Re: VACUUM can set pages all-frozen without also setting them all-visible Peter Geoghegan 08:22
Re: BUG #17438: Logical replication hangs on master after huge DB load Amit Kapila 11:45
Re: BUG #17438: Logical replication hangs on master after huge DB load Sergey Belyashov 12:09
Re: BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE 📎 Tom Lane 17:27
Re: BUG #17439: DROP FUNCTION functionName(); drops associated generated column without using CASCADE Peter Eisentraut 19:05

March 17, 2022

Thread Author Time
Logical replication stops dropping used initial-sync replication slots hubert depesz lubaczewski 14:24
Detaching a partition with a FK on itself is not possible Christophe Courtois 17:31
Re: Detaching a partition with a FK on itself is not possible Arne Roland 17:58

March 18, 2022

Thread Author Time
Re: Logical replication stops dropping used initial-sync replication slots hubert depesz lubaczewski 12:27
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund 14:53
Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum 📎 Peter Geoghegan 17:06

March 20, 2022

Thread Author Time
Re: snapshot recovery conflict despite hot_standby_feedback set to on Peter Geoghegan 06:21
BUG #17441: shm_mq receive less data than the sender sends PG Bug reporting form 08:39
BUG #17442: Wrong partition pruning when using prepared statement and huge RAM consumption PG Bug reporting form 21:27

March 21, 2022

Thread Author Time
BUG #17443: Select command does not use brin index when enable_seqscan = on PG Bug reporting form 02:44
Re: BUG #17443: Select command does not use brin index when enable_seqscan = on Julien Rouhaud 09:21
Re: Detaching a partition with a FK on itself is not possible Jehan-Guillaume de Rorthais 10:36
Re: Detaching a partition with a FK on itself is not possible Arne Roland 10:50
Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join 📎 Prajna Shetty 11:45
BUG #17444: ERROR: found xmin 215633 from before relfrozenxid 1280585 PG Bug reporting form 13:08
Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Tom Lane 13:59
Re: Logical replication stops dropping used initial-sync replication slots vignesh C 14:18
Re: Logical replication stops dropping used initial-sync replication slots hubert depesz lubaczewski 14:43
BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded PG Bug reporting form 20:37
Re: BUG #17088: FailedAssertion in prepagg.c 📎 Tom Lane 21:09
Re: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded David G. Johnston 22:23
Re: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded Tom Lane 22:23
Re: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded David G. Johnston 22:50
Re: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded Peter Geoghegan 22:53
Re: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded Tom Lane 23:03
Re: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded Peter Geoghegan 23:14
Re: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded Tom Lane 23:27
Re: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded Peter Geoghegan 23:49

March 22, 2022

Thread Author Time
Re: Logical replication stops dropping used initial-sync replication slots vignesh C 03:07
Re: Logical replication stops dropping used initial-sync replication slots hubert depesz lubaczewski 03:48
Re: Logical replication stops dropping used initial-sync replication slots vignesh C 07:02
Re: Logical replication stops dropping used initial-sync replication slots hubert depesz lubaczewski 11:26
Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join 📎 Prajna Shetty 12:57
BUG #17446: Suggest updating the section title "Building Indexes Concurrently" PG Bug reporting form 21:58

March 23, 2022

Thread Author Time
Re: BUG #17441: shm_mq receive less data than the sender sends Masahiko Sawada 02:59
Re: BUG #17446: Suggest updating the section title "Building Indexes Concurrently" Michael Paquier 04:39
Re: BUG #17441: shm_mq receive less data than the sender sends Michael Paquier 04:41
Re: BUG #17446: Suggest updating the section title "Building Indexes Concurrently" David G. Johnston 05:05
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Masahiko Sawada 08:48

March 24, 2022

Thread Author Time
Re: BUG #17444: ERROR: found xmin 215633 from before relfrozenxid 1280585 Andrey Borodin 09:05
Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Tomas Vondra 11:55
Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Justin Pryzby 12:24
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end 📎 Masahiko Sawada 14:23
BUG #17447: uninstaller fails PG Bug reporting form 19:09
Re: BUG #17440: not expected result from jsonb_path_query Alexander Korotkov 22:40

March 25, 2022

Thread Author Time
BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. PG Bug reporting form 07:52
Re: Logical replication stops dropping used initial-sync replication slots hubert depesz lubaczewski 08:38
RE: Reconnect a single connection used by multiple threads in embedded SQL in C application causes error. 📎 egashira.yusuke@fujitsu.com 13:34
BUG #17449: Disk space not released PG Bug reporting form 15:01

March 26, 2022

Thread Author Time
Re: BUG #17449: Disk space not released Bharath Rupireddy 04:02
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 05:46
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 08:24
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 09:03
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. 📎 Thomas Munro 11:07
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 11:33
OpenSSL v1.1.1n in postgres Vibhu Chauhan (iDEAS-ER&D) 17:32
Re: OpenSSL v1.1.1n in postgres Daniel Gustafsson 20:32
Re: OpenSSL v1.1.1n in postgres Tom Lane 20:38
Re: OpenSSL v1.1.1n in postgres David G. Johnston 20:45
Re: OpenSSL v1.1.1n in postgres Tom Lane 21:17

March 27, 2022

Thread Author Time
Re: OpenSSL v1.1.1n in postgres Sandeep Thakkar 02:11

March 28, 2022

Thread Author Time
Re: BUG #17447: uninstaller fails Semab Tariq 07:20
BUG #17450: SUBSTRING function extracting lesser characters than specified PG Bug reporting form 10:30
Re: BUG #17450: SUBSTRING function extracting lesser characters than specified hubert depesz lubaczewski 11:01
Re: BUG #17450: SUBSTRING function extracting lesser characters than specified 📎 Pavel Borisov 12:35
Re: BUG #17450: SUBSTRING function extracting lesser characters than specified Tom Lane 13:55
Re: BUG #17450: SUBSTRING function extracting lesser characters than specified Japin Li 14:00
Re: BUG #17450: SUBSTRING function extracting lesser characters than specified Pavel Borisov 14:00
Re: BUG #17450: SUBSTRING function extracting lesser characters than specified David G. Johnston 14:09

March 29, 2022

Thread Author Time
Re: Logical replication stops dropping used initial-sync replication slots Amit Kapila 11:27
Re: Logical replication stops dropping used initial-sync replication slots hubert depesz lubaczewski 12:01
Re: BUG #17438: Logical replication hangs on master after huge DB load Amit Kapila 12:03
Re: Logical replication stops dropping used initial-sync replication slots Amit Kapila 12:07

March 30, 2022

Thread Author Time
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. 📎 Michael Paquier 07:54
AW: BUG #17393: Delete database after recovery with point-in-time is still missing datafiles 📎 Lorenz, Christopher 11:49
Re: BUG #17393: Delete database after recovery with point-in-time is still missing datafiles Pierre Forstmann 19:07

March 31, 2022

Thread Author Time
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 04:59
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 07:42
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 08:00
Re: BUG #17393: Delete database after recovery with point-in-time is still missing datafiles Kyotaro Horiguchi 08:26
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 10:46
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 11:03
Re: BUG #17438: Logical replication hangs on master after huge DB load 📎 Sergey Belyashov 12:53
BUG #17452: IN caluse behaves differently when there is one item comapred to when multiple PG Bug reporting form 13:42
Re: BUG #17393: Delete database after recovery with point-in-time is still missing datafiles Pierre Forstmann 16:04
Re: BUG #17452: IN caluse behaves differently when there is one item comapred to when multiple David G. Johnston 16:06
Postgres Bug - Aggregate with order by Andrew D 20:04
Re: Postgres Bug - Aggregate with order by Tom Lane 20:34

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