pgsql-bugs - July 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

July 1, 2022

Thread Author Time
pg15 beta2 bug:cause by logcial replation 396934406@qq.com 03:35
RE: pg15 beta2 bug:cause by logcial replation houzj.fnst@fujitsu.com 04:09
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Masahiko Sawada 05:11
Re: pg15 beta2 bug:cause by logcial replation Tom Lane 05:16
Re: RE: pg15 beta2 bug:cause by logcial replation 396934406@qq.com 06:36
Re: Re: pg15 beta2 bug:cause by logcial replation 396934406@qq.com 06:43
RE: RE: pg15 beta2 bug:cause by logcial replation houzj.fnst@fujitsu.com 07:26
Re: RE: pg15 beta2 bug:cause by logcial replation 396934406@qq.com 08:10
Re: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3? Marco Boeringa 09:49
PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 ROSESOFT S. Hoffmann 13:07
BUG #17535: postgresql-14-orafce 3.22.0-1.pgdg110+1 fails; 3.21.1-1.pgdg110+1 works. PG Bug reporting form 14:21
BUG #17536: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 PG Bug reporting form 14:36
Re: BUG #17536: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 Tom Lane 14:48
Re: BUG #17535: postgresql-14-orafce 3.22.0-1.pgdg110+1 fails; 3.21.1-1.pgdg110+1 works. Pavel Stehule 16:05

July 2, 2022

Thread Author Time
Re: RE: pg15 beta2 bug:cause by logcial replation 396934406@qq.com 00:29
Re: Auto-vacuum timing out and preventing connections Andres Freund 03:11
Re: Auto-vacuum timing out and preventing connections David Johansen 04:34
[No subject] Hung Nguyen 12:15
Re: Tom Lane 13:45
Re: your mail Julien Rouhaud 13:49

July 3, 2022

Thread Author Time
BUG #17537: Dynamically updating statement_timeout not affect the insert query right now. PG Bug reporting form 05:24
BUG #17538: Dynamically updating log_hostname not affect the disconnection log PG Bug reporting form 11:14
Re: BUG #17537: Dynamically updating statement_timeout not affect the insert query right now. Tom Lane 15:01
Re: BUG #17537: Dynamically updating statement_timeout not affect the insert query right now. David G. Johnston 15:09

July 4, 2022

Thread Author Time
Re: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 Kyotaro Horiguchi 00:34
Re: Auto-vacuum timing out and preventing connections Xiong He 04:29
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Kyotaro Horiguchi 08:27
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Alvaro Herrera 08:49
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages 📎 Alvaro Herrera 09:32
AW: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 ROSESOFT S. Hoffmann 11:53
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Christoph Berg 14:38
Re: BUG #17538: Dynamically updating log_hostname not affect the disconnection log Tom Lane 17:23

July 5, 2022

Thread Author Time
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier 00:12
Re: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 Thomas Munro 07:22
Re: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 Thomas Munro 08:18
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Alvaro Herrera 12:39
AW: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 ROSESOFT S. Hoffmann 13:29
Re: pg_upgrade (12->14) fails on aggregate Tom Lane 17:07
Re: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 Thomas Munro 19:25
BUG #17539: Assert after CREATE OPERATOR CLASS command PG Bug reporting form 20:08
Re: BUG #17539: Assert after CREATE OPERATOR CLASS command 📎 Dmitry Koval 20:36
BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower PG Bug reporting form 22:13
Re: BUG #17539: Assert after CREATE OPERATOR CLASS command Tom Lane 22:32

July 6, 2022

Thread Author Time
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Kyotaro Horiguchi 01:05
Re: pg_upgrade (12->14) fails on aggregate Michael Paquier 01:50
Re: pg_upgrade (12->14) fails on aggregate Tom Lane 03:29
Re: BUG #17539: Assert after CREATE OPERATOR CLASS command Michael Paquier 03:41
Re: BUG #17539: Assert after CREATE OPERATOR CLASS command Tom Lane 03:56
Re: 📎 Ronan Dunklau 08:53
Re: index cost estimation Tom Lane 14:41
Re: index cost estimation Ronan Dunklau 14:52
Re: index cost estimation 📎 Ronan Dunklau 15:42
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower David G. Johnston 22:07

July 7, 2022

Thread Author Time
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower David Rowley 00:23
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower David Rowley 00:46
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Andres Freund 00:46
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower David Rowley 01:54
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Tom Lane 03:06
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Tom Lane 03:13
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower 📎 David Rowley 03:31
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Tom Lane 03:50
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Andres Freund 04:36
Re: pg_upgrade (12->14) fails on aggregate Michael Paquier 05:04
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Tom Lane 18:02
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. 📎 Michael Paquier 22:38

July 9, 2022

Thread Author Time
BUG #17542: tsquery returns incorrect results with nested, conjuncted followed-by operators PG Bug reporting form 01:35
BUG #17543: CSVLOG malformed from disk space error PG Bug reporting form 16:08

July 10, 2022

Thread Author Time
BUG #17544: Join order for INNER JOIN ... USING with GROUP BY on join column affects selected query plan PG Bug reporting form 04:52

July 11, 2022

Thread Author Time
RE: server closed the connection unexpectedly - bug report Jiří Ledvinka 08:05
Re: BUG #17543: CSVLOG malformed from disk space error David G. Johnston 12:31
Re: BUG #17542: tsquery returns incorrect results with nested, conjuncted followed-by operators Pavel Borisov 12:34
Re: BUG #17542: tsquery returns incorrect results with nested, conjuncted followed-by operators Jordan Lewis 13:18
BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs PG Bug reporting form 14:18
BUG #17546: power() function - value is distorted via automatic type cast PG Bug reporting form 15:20
Re: BUG #17546: power() function - value is distorted via automatic type cast Tom Lane 15:49
Re: BUG #17546: power() function - value is distorted via automatic type cast 📎 Антон Потапов 16:04
Re: BUG #17546: power() function - value is distorted via automatic type cast Tom Lane 18:56

July 12, 2022

Thread Author Time
Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs Richard Guo 04:35
Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs Tom Lane 04:41
Reducing chunk header sizes on all memory context types 📎 David Rowley 04:57
Re: Reducing chunk header sizes on all memory context types David Rowley 05:00
Re: BUG #17544: Join order for INNER JOIN ... USING with GROUP BY on join column affects selected query plan Andrey Lepikhov 06:34
Re: can't drop table due to reference from orphaned temp function Yura Sokolov 14:13
BUG #17548: Aggregate queries on partitioned tables can cause OOM. PG Bug reporting form 16:25
Re: BUG #17544: Join order for INNER JOIN ... USING with GROUP BY on join column affects selected query plan Tom Lane 17:52
Re: can't drop table due to reference from orphaned temp function Andres Freund 19:24
Re: BUG #17548: Aggregate queries on partitioned tables can cause OOM. Tom Lane 22:15

July 13, 2022

Thread Author Time
Re: BUG #17543: CSVLOG malformed from disk space error Michael Paquier 00:26
Re: BUG #17543: CSVLOG malformed from disk space error Andres Freund 00:48
Re: BUG #17543: CSVLOG malformed from disk space error Kyotaro Horiguchi 04:09
Re: can't drop table due to reference from orphaned temp function Yura Sokolov 09:16
pg_ctl cannot find postgresql.conf Дмитрий Карасёв 09:45
BUG #17549: wrong index scan plan with RLS PG Bug reporting form 11:45
Re: pg_ctl cannot find postgresql.conf David G. Johnston 12:28
Re: pg_ctl cannot find postgresql.conf Juan José Santamaría Flecha 13:08
Re: BUG #17549: wrong index scan plan with RLS Tom Lane 14:27

July 14, 2022

Thread Author Time
Excessive number of replication slots for 12->14 logical replication hubert depesz lubaczewski 11:51
BUG #17550: inet type doesn't accept alternate notations of ipv4 addresses PG Bug reporting form 14:49
Re: Auto-vacuum timing out and preventing connections David Johansen 16:51
Re: BUG #17550: inet type doesn't accept alternate notations of ipv4 addresses Francisco Olarte 16:51
Re: BUG #17550: inet type doesn't accept alternate notations of ipv4 addresses David G. Johnston 18:02
Re: BUG #17550: inet type doesn't accept alternate notations of ipv4 addresses Tom Lane 18:24
Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes Bruce Momjian 21:57
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Bruce Momjian 23:49

July 15, 2022

Thread Author Time
[15] Custom WAL resource managers, single user mode, and recovery 📎 Jeff Davis 00:22
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane 00:36
Re: [15] Custom WAL resource managers, single user mode, and recovery Tom Lane 00:48
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands David G. Johnston 02:14
Re: [15] Custom WAL resource managers, single user mode, and recovery Andres Freund 03:32
Re: Auto-vacuum timing out and preventing connections Andres Freund 03:42
Re: [15] Custom WAL resource managers, single user mode, and recovery Tom Lane 03:42
Re: [15] Custom WAL resource managers, single user mode, and recovery Andres Freund 03:58
Re: Auto-vacuum timing out and preventing connections David Johansen 04:22
Re: Excessive number of replication slots for 12->14 logical replication Kyotaro Horiguchi 04:55
Re: [15] Custom WAL resource managers, single user mode, and recovery Alexander Kukushkin 07:00
Re: [15] Custom WAL resource managers, single user mode, and recovery Andres Freund 07:26
Re: Excessive number of replication slots for 12->14 logical replication hubert depesz lubaczewski 07:45
Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes Kyotaro Horiguchi 07:58
Makefile.global will override configure parameters if "pgsql" and "postgres" appear anywhere in the source path name Andy Bailey 16:13
Re: Makefile.global will override configure parameters if "pgsql" and "postgres" appear anywhere in the source path name Alvaro Herrera 18:38
Re: [15] Custom WAL resource managers, single user mode, and recovery 📎 Jeff Davis 19:43
Re: Makefile.global will override configure parameters if "pgsql" and "postgres" appear anywhere in the source path name Andres Freund 20:25
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands 📎 Tom Lane 21:06
Re: Excessive number of replication slots for 12->14 logical replication Andres Freund 22:14
Re: Makefile.global will override configure parameters if "pgsql" and "postgres" appear anywhere in the source path name Tom Lane 23:22
Re: Makefile.global will override configure parameters if "pgsql" and "postgres" appear anywhere in the source path name Andres Freund 23:30
pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty Walker Philips 23:37

July 16, 2022

Thread Author Time
Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty David Rowley 00:41
Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty Tom Lane 00:45
Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty Tom Lane 00:54
Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty Walker Philips 21:20
Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty Tom Lane 23:07

July 17, 2022

Thread Author Time
BUG #17552: pg_stat_statements tracks internal FK check queries when COPY used to load data PG Bug reporting form 19:23
Re: BUG #17483: postgres_fdw used with text to_tsvector and custom search configuration Tom Lane 22:59

July 18, 2022

Thread Author Time
Re: Excessive number of replication slots for 12->14 logical replication Amit Kapila 03:37
Re: Excessive number of replication slots for 12->14 logical replication Amit Kapila 03:51
BUG #17553: Unreleased file resources exist PG Bug reporting form 06:55
Re: Excessive number of replication slots for 12->14 logical replication hubert depesz lubaczewski 08:09
Re: Excessive number of replication slots for 12->14 logical replication hubert depesz lubaczewski 09:43
BUG #17554: when i use rule on table which have serial column, the nextval exec twice. PG Bug reporting form 09:55
Re: BUG #17552: pg_stat_statements tracks internal FK check queries when COPY used to load data Julien Rouhaud 10:19
Re: BUG #17554: when i use rule on table which have serial column, the nextval exec twice. Francisco Olarte 10:42
Re: Excessive number of replication slots for 12->14 logical replication Amit Kapila 11:20
BUG #17555: Missing rhel-9 repo PG Bug reporting form 12:59
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands David G. Johnston 19:55
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane 20:20
Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes Bruce Momjian 21:21
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands David G. Johnston 22:17

July 19, 2022

Thread Author Time
Re: [15] Custom WAL resource managers, single user mode, and recovery Masahiko Sawada 03:26
Re: BUG #17555: Missing rhel-9 repo Devrim Gündüz 09:00
If a row-level security policy contains a set returning function, pg_dump returns an incorrect serialization of that policy if the return type of the function was altered 📎 Timo Stolz 10:22
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Daniel Verite 11:16

July 20, 2022

Thread Author Time
Trusted extension cannot be dropped by the owner of the extension Harinath Kanchu 06:44
Re: Trusted extension cannot be dropped by the owner of the extension Bruce Momjian 16:35
Re: If a row-level security policy contains a set returning function, pg_dump returns an incorrect serialization of that policy if the return type of the function was altered 📎 Tom Lane 20:54

July 21, 2022

Thread Author Time
Re: If a row-level security policy contains a set returning function, pg_dump returns an incorrect serialization of that policy if the return type of the function was altered Dean Rasheed 07:19
Re: If a row-level security policy contains a set returning function, pg_dump returns an incorrect serialization of that policy if the return type of the function was altered Tom Lane 17:58
Re: If a row-level security policy contains a set returning function, pg_dump returns an incorrect serialization of that policy if the return type of the function was altered 📎 Tom Lane 19:19
Re: If a row-level security policy contains a set returning function, pg_dump returns an incorrect serialization of that policy if the return type of the function was altered Dean Rasheed 21:27

July 22, 2022

Thread Author Time
Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Marco Boeringa 07:56
Re:BUG #17533: run benchmarksql test failed sean 09:24
could not link file in wal restore lines Zsolt Ero 09:24
BUG #17556: ts_headline does not correctly find matches when separated by 4,999 words PG Bug reporting form 14:06
BUG #17557: ts_headline will error with "invalid memory alloc request size" for large documents PG Bug reporting form 15:39
Re: If a row-level security policy contains a set returning function, pg_dump returns an incorrect serialization of that policy if the return type of the function was altered Tom Lane 16:50
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Bruce Momjian 19:07
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Marco Boeringa 19:43
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Marco Boeringa 21:08
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Marco Boeringa 21:17

July 23, 2022

Thread Author Time
Re: could not link file in wal restore lines Michael Paquier 03:36
Re: could not link file in wal restore lines Zsolt Ero 13:05
Re: could not link file in wal restore lines David Steele 13:20
Re: BUG #17557: ts_headline will error with "invalid memory alloc request size" for large documents Japin Li 14:33
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Tom Lane 15:33
Re: could not link file in wal restore lines 📎 Zsolt Ero 16:39
Re: could not link file in wal restore lines David Steele 16:43
Re: could not link file in wal restore lines 📎 Zsolt Ero 16:53

July 24, 2022

Thread Author Time
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Marco Boeringa 07:55
Re: Excessive number of replication slots for 12->14 logical replication 📎 Ajin Cherian 08:16

July 25, 2022

Thread Author Time
BUG #17558: 15beta2: Endless loop with UNIQUE NULLS NOT DISTINCT and INSERT ... ON CONFLICT PG Bug reporting form 01:04
Re: BUG #17556: ts_headline does not correctly find matches when separated by 4,999 words Kyotaro Horiguchi 02:36
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Marco Boeringa 06:04
Re: could not link file in wal restore lines 📎 Kyotaro Horiguchi 08:11
Re: could not link file in wal restore lines Kyotaro Horiguchi 08:25
RE: Excessive number of replication slots for 12->14 logical replication houzj.fnst@fujitsu.com 09:48
Re: Excessive number of replication slots for 12->14 logical replication 📎 Ajin Cherian 11:43
Re: could not link file in wal restore lines David Steele 12:40
Re: BUG #17556: ts_headline does not correctly find matches when separated by 4,999 words Alex Malek 13:31
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Tomas Vondra 13:39
Re: BUG #17558: 15beta2: Endless loop with UNIQUE NULLS NOT DISTINCT and INSERT ... ON CONFLICT Tom Lane 15:39

July 26, 2022

Thread Author Time
Re: could not link file in wal restore lines Kyotaro Horiguchi 02:48
Re: BUG #17558: 15beta2: Endless loop with UNIQUE NULLS NOT DISTINCT and INSERT ... ON CONFLICT Richard Guo 03:17
Re: could not link file in wal restore lines Kyotaro Horiguchi 06:03
Re: could not link file in wal restore lines David Steele 11:33
Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4? Marco Boeringa 12:40
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands 📎 Tom Lane 15:08
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands David G. Johnston 15:22
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane 15:37
Re: could not link file in wal restore lines Zsolt Ero 15:37
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands David G. Johnston 15:48

Browse Archives

Prev | Next