pgsql-bugs - July 2023

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, 2023

Thread Author Time
Re: Server closed the connection unexpectedly (memory leak) Andres Freund 02:56
BUG #18010: Bug with installation/auto-configuration PG Bug reporting form 04:45
BUG #18011: Declarative partition privilege problem cause incorrect execution plans PG Bug reporting form 07:54
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() 📎 Andrew Dunstan 13:14
BUG #18005: PSQL Process hangs in parallel mode / complement information 📎 ess.bee59 14:37
Re: BUG #18011: Declarative partition privilege problem cause incorrect execution plans David Rowley 21:11

July 2, 2023

Thread Author Time
BUG #18012: Installer fails to run .bat files when they are registered to Notepad++ PG Bug reporting form 06:42
Re: BUG #18002: Duplicate entries of row possible even after having primary key David Rowley 21:53
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andres Freund 21:54
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 21:57
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andres Freund 22:13
Re: BUG #18009: Postgres Recovery not happening Thomas Munro 22:27

July 3, 2023

Thread Author Time
Re: BUG #18002: Duplicate entries of row possible even after having primary key Peter Geoghegan 01:06
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 02:15
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview Michael Paquier 02:26
Re: BUG #17968: installation Sandeep Thakkar 06:46
BUG #18013: Failed installing PG Bug reporting form 08:41
Re: Toasted column values during replication. (Enhancement) Amit Kapila 08:50
group by can use alias from select list but not the having clause 📎 hape Hape 09:43
Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 11:36
Re: Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 12:58
Re: group by can use alias from select list but not the having clause David G. Johnston 13:41
回复: BUG #18011: Declarative partition privilege problem cause incorrect execution plans liu zhilong 13:51
Re: group by can use alias from select list but not the having clause Tom Lane 14:12
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Tristan Partin 14:42
Re: group by can use alias from select list but not the having clause Pantelis Theodosiou 14:57
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 16:17
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 16:25
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 16:28
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 16:31
Re: BUG #17949: Adding an index introduces serialisation anomalies. Thomas Munro 22:02

July 4, 2023

Thread Author Time
Re: Backend handling replication slot stuck using 100% cpu, unkillable shveta malik 03:26
Re: BUG #18012: Installer fails to run .bat files when they are registered to Notepad++ Sandeep Thakkar 10:54
BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used PG Bug reporting form 11:00
Re: Backend handling replication slot stuck using 100% cpu, unkillable Tomas Vondra 11:30
Re: Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 11:52
Re: Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 11:53
Re: Backend handling replication slot stuck using 100% cpu, unkillable Tomas Vondra 13:04
Re: BUG #18009: Postgres Recovery not happening Vamshikrishna T 13:48
Re: Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 13:55
Re: BUG #17695: Failed Assert in logical replication snapbuild. Daniel Gustafsson 15:43
XML column causes record to be both NULL and NOT NULL Wilm Hoyer 18:46
Re: XML column causes record to be both NULL and NOT NULL Tom Lane 18:59

July 5, 2023

Thread Author Time
Re: BUG #17695: Failed Assert in logical replication snapbuild. Masahiko Sawada 01:23
Re: BUG #18009: Postgres Recovery not happening Thomas Munro 03:35
AW: XML column causes record to be both NULL and NOT NULL Wilm Hoyer 06:43
BUG #18015: missing dependency packages for postgis extension PG Bug reporting form 08:54
Fwd: BUG #18015: missing dependency packages for postgis extension Laurenz Albe 13:29
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 20:45
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 20:53
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Tristan Partin 20:55
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower 📎 David Rowley 23:55

July 6, 2023

Thread Author Time
The same 2PC data maybe recovered twice 蔡梦娟 (玊于) 02:02
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Richard Guo 09:26
Re: BUG #17968: installation Sandeep Thakkar 13:44
BUG #18016: REINDEX TABLE failure PG Bug reporting form 20:29
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files Jacob Champion 21:14
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files Tom Lane 23:05

July 7, 2023

Thread Author Time
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower 📎 Richard Guo 07:02
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files Daniel Gustafsson 07:23
回复:The same 2PC data maybe recovered twice 📎 蔡梦娟 (玊于) 09:48
BUG #18017: configure --with-ldap fails when openldap is installed PG Bug reporting form 16:46
Re: BUG #18017: configure --with-ldap fails when openldap is installed Miriam Blume 18:23
RE: BUG #18017: configure --with-ldap fails when openldap is installed Wetmore, Matthew (CTR) 19:33
Re: BUG #18017: configure --with-ldap fails when openldap is installed Laurenz Albe 21:35

July 8, 2023

Thread Author Time
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files Michael Paquier 00:05
Re: BUG #18016: REINDEX TABLE failure Michael Paquier 00:17
Re: BUG #18016: REINDEX TABLE failure Tom Lane 00:20
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 12:48

July 9, 2023

Thread Author Time
Re: BUG #18016: REINDEX TABLE failure Gurjeet Singh 07:01
Re: BUG #18016: REINDEX TABLE failure Michael Paquier 07:55
RE: BUG #18016: REINDEX TABLE failure Richard Veselý 13:54
Re: BUG #18016: REINDEX TABLE failure Tom Lane 14:18
Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger 📎 Alexander Lakhin 15:00

July 10, 2023

Thread Author Time
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower David Rowley 02:14
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower 📎 Richard Guo 06:39
Re: BUG #18009: Postgres Recovery not happening Vamshikrishna T 11:27
Re: BUG #18016: REINDEX TABLE failure 📎 Gurjeet Singh 16:35
Re: BUG #18016: REINDEX TABLE failure Gurjeet Singh 16:43
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andres Freund 19:51
Re: BUG #17928: Standby fails to decode WAL on termination of primary 📎 Noah Misch 20:00
BUG #18018: Homebrew link is broken PG Bug reporting form 22:32
Re: BUG #18009: Postgres Recovery not happening Thomas Munro 23:52

July 11, 2023

Thread Author Time
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Tristan Partin 00:52
Got FATAL in lock_twophase_recover() during recovery 📎 suyu.cmj 02:35
Re: BUG #17928: Standby fails to decode WAL on termination of primary 📎 Kyotaro Horiguchi 06:54
RE: BUG #18016: REINDEX TABLE failure Richard Veselý 09:31
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 14:15
Re: BUG #18018: Homebrew link is broken Gurjeet Singh 18:14
Re: BUG #18018: Homebrew link is broken Michael Paquier 23:39
Re: Got FATAL in lock_twophase_recover() during recovery Michael Paquier 23:41

July 12, 2023

Thread Author Time
Re: The same 2PC data maybe recovered twice Andy Fan 02:57
Re: The same 2PC data maybe recovered twice 📎 suyu.cmj 07:20
BUG #18019: misbehaviour by replication PG Bug reporting form 10:08
Re: BUG #18018: Homebrew link is broken 📎 Daniel Gustafsson 12:49
Re: BUG #17977: PorstGreSQL in a jail crashes randomly with Signal 10 bus error Stephen Frost 12:56
Re: BUG #18018: Homebrew link is broken 📎 Jonathan S. Katz 13:45
Re: BUG #18018: Homebrew link is broken Daniel Gustafsson 13:59
Re: BUG #17977: PorstGreSQL in a jail crashes randomly with Signal 10 bus error Cory Albrecht 20:03
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() 📎 Andrew Dunstan 20:08

July 13, 2023

Thread Author Time
Re: The same 2PC data maybe recovered twice Michael Paquier 06:58
Re: BUG #18019: misbehaviour by replication 📎 Kyotaro Horiguchi 07:49
RE: BUG #18019: misbehaviour by replication 📎 Hayato Kuroda (Fujitsu) 08:21
Re: BUG #18019: misbehaviour by replication André Kutepow 09:03
Re: BUG #18019: misbehaviour by replication Amit Kapila 10:28
Re: BUG #18019: misbehaviour by replication Amit Kapila 10:30
Re: BUG #17968: installation Manika Singhal 13:04
Re: BUG #18012: Installer fails to run .bat files when they are registered to Notepad++ Manika Singhal 13:05
Re: BUG #18008: SSL certificate error for Stackbuilder 4.2.1 Sandeep Thakkar 15:45

July 14, 2023

Thread Author Time
Re: BUG #18012: Installer fails to run .bat files when they are registered to Notepad++ Matt Feemster 05:08
Re: pg_dump needs SELECT privileges on irrelevant extension table Akshat Jaimini 07:45
Re: pg_dump needs SELECT privileges on irrelevant extension table Andrew Dunstan 12:04
Re: BUG #17949: Adding an index introduces serialisation anomalies. Artem Anisimov 13:05
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files Daniel Gustafsson 13:07
Re: pg_dump needs SELECT privileges on irrelevant extension table Jacob Champion 22:20

July 15, 2023

Thread Author Time
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Alexander Lakhin 07:00
BUG #18021: Loading Error PG Bug reporting form 08:43

July 16, 2023

Thread Author Time
BUG #18023: when the query shows an error SQL Error [XX000]: ERROR: pg_attribute catalog is missing PG Bug reporting form 09:27
Re: BUG #17948: libpq seems to misbehave in a pipelining corner case 📎 Трофимов Иван 11:57
Re: BUG #17552: pg_stat_statements tracks internal FK check queries when COPY used to load data Tomas Vondra 15:19
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Alexander Lakhin 20:00
Re: BUG #17949: Adding an index introduces serialisation anomalies. Thomas Munro 22:04

July 17, 2023

Thread Author Time
Re: BUG #17928: Standby fails to decode WAL on termination of primary Noah Misch 00:49
Query returns error "there is no parameter $1" but server logs that there are two parameters supplied Paul De Audney 02:25
BUG #18025: Probably we need to change behaviour of the checkpoint failures in PG PG Bug reporting form 05:03
Re: The same 2PC data maybe recovered twice 📎 suyu.cmj 06:26
Re: BUG #18021: Loading Error Manika Singhal 07:37
Re: BUG #18025: Probably we need to change behaviour of the checkpoint failures in PG Laurenz Albe 07:53
Re: Query returns error "there is no parameter $1" but server logs that there are two parameters supplied Laurenz Albe 07:58
Re: The same 2PC data maybe recovered twice Michael Paquier 07:59
Re: BUG #18025: Probably we need to change behaviour of the checkpoint failures in PG Michael Paquier 08:06
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files Michael Paquier 08:29
pg_dump needs an option to add the force flag to the drop database Joan 08:47
Re: The same 2PC data maybe recovered twice 📎 suyu.cmj 09:20
Re: Query returns error "there is no parameter $1" but server logs that there are two parameters supplied Tom Lane 13:45
BUG #18026: compile error / fe-auth.c:807:64: error: 'CHAR_BIT' undeclared (first use in this function) PG Bug reporting form 15:27
Re: BUG #18026: compile error / fe-auth.c:807:64: error: 'CHAR_BIT' undeclared (first use in this function) Tom Lane 16:15
Re: BUG #18026: compile error / fe-auth.c:807:64: error: 'CHAR_BIT' undeclared (first use in this function) Marcel Hofstetter 16:21
Re: BUG #18026: compile error / fe-auth.c:807:64: error: 'CHAR_BIT' undeclared (first use in this function) Marcel Hofstetter 18:46
Re: BUG #18026: compile error / fe-auth.c:807:64: error: 'CHAR_BIT' undeclared (first use in this function) Tom Lane 18:55
Re: BUG #18026: compile error / fe-auth.c:807:64: error: 'CHAR_BIT' undeclared (first use in this function) Tom Lane 20:42
Bug with aggregate Window Functions when using Order By. Elements dropped if order by provided Walker Philips 21:41
BUG #18027: Logical replication taking forever PG Bug reporting form 22:33
Re: Query returns error "there is no parameter $1" but server logs that there are two parameters supplied Paul De Audney 23:27

July 18, 2023

Thread Author Time
Re: pg_dump needs an option to add the force flag to the drop database vignesh C 03:40
Re: pg_dump needs an option to add the force flag to the drop database Tom Lane 03:51
Re: The same 2PC data maybe recovered twice Michael Paquier 05:13
Re: BUG #18026: compile error / fe-auth.c:807:64: error: 'CHAR_BIT' undeclared (first use in this function) Michael Paquier 05:44
Re: pg_dump needs an option to add the force flag to the drop database Joan 07:48
Re: Bug with aggregate Window Functions when using Order By. Elements dropped if order by provided Laurenz Albe 10:10
Re: Bug with aggregate Window Functions when using Order By. Elements dropped if order by provided David Rowley 11:14
Re: BUG #17552: pg_stat_statements tracks internal FK check queries when COPY used to load data Sergei Kornilov 16:19

July 19, 2023

Thread Author Time
Re: BUG #18027: Logical replication taking forever Amit Kapila 04:19
Re: BUG #18027: Logical replication taking forever Andres Martin del Campo Campos 04:59
BUG #18029: Misleading warning about Collation Changes with newer glibc version PG Bug reporting form 06:32
Re: BUG #18019: misbehaviour by replication Kyotaro Horiguchi 06:52
BUG #18030: Large memory consumption caused by in-clause subqueries PG Bug reporting form 08:49
Re: BUG #18030: Large memory consumption caused by in-clause subqueries Laurenz Albe 10:39
Re: BUG #18027: Logical replication taking forever vignesh C 11:07
BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker PG Bug reporting form 15:00
Re: BUG #18030: Large memory consumption caused by in-clause subqueries 📎 David Rowley 23:13
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files 📎 Daniel Gustafsson 23:16

July 20, 2023

Thread Author Time
Re: BUG #18030: Large memory consumption caused by in-clause subqueries Tom Lane 00:11
BUG #18033: org.postgresql.util.PSQLException: PG Bug reporting form 03:11
Re: BUG #17928: Standby fails to decode WAL on termination of primary Kyotaro Horiguchi 06:01
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Kyotaro Horiguchi 07:28
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Kyotaro Horiguchi 07:44
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files Michael Paquier 07:47
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used 📎 Kyotaro Horiguchi 08:29
Re: BUG #18033: org.postgresql.util.PSQLException: Daniel Gustafsson 08:47
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files 📎 Daniel Gustafsson 10:36
Re: BUG #18033: org.postgresql.util.PSQLException: Shashanth Reddy 14:58
Re: BUG #18033: org.postgresql.util.PSQLException: Daniel Gustafsson 15:06
BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate PG Bug reporting form 15:25
Re: BUG #18027: Logical replication taking forever Andres Martin del Campo Campos 17:16
Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files Michael Paquier 23:53

July 21, 2023

Thread Author Time
Re: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker 📎 Masahiko Sawada 08:01
Re: BUG #18027: Logical replication taking forever vignesh C 08:56
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used 📎 Alexander Lakhin 09:00
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Tom Lane 17:20
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Alexander Lakhin 19:00
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Tom Lane 19:21

July 22, 2023

Thread Author Time
Re: BUG #18027: Logical replication taking forever Amit Kapila 05:25
Re: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker Alexander Lakhin 10:00

July 24, 2023

Thread Author Time
Re: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker Masahiko Sawada 01:39
pg_hba.conf "authentication file token too long, skipping" Zechman, Derek S 15:05
Re: pg_hba.conf "authentication file token too long, skipping" Tom Lane 16:51
Re: BUG #18027: Logical replication taking forever Andres Martin del Campo Campos 18:03

July 25, 2023

Thread Author Time
Re: BUG #18018: Homebrew link is broken Jonathan S. Katz 02:17
Re: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker Andres Freund 03:39
Re: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker 📎 Masahiko Sawada 07:35
BUG #18035: Assertion failure in jsonb_path_query PG Bug reporting form 08:57
Add instructions for downloading Linux (Mint) Черников Д А 09:30
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Alexander Lakhin 10:00
Re: BUG #18035: Assertion failure in jsonb_path_query 📎 David Rowley 14:55
Re: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker Andres Freund 16:27

July 26, 2023

Thread Author Time
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Kyotaro Horiguchi 02:29
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Tom Lane 02:41
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Kyotaro Horiguchi 02:53
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Kyotaro Horiguchi 02:59

Browse Archives

Prev | Next