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

Aug. 1, 2023

Thread Author Time
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Andrey M. Borodin 13:15
Re: BUG #18035: Assertion failure in jsonb_path_query David Rowley 13:46
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 13:48
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 14:02
BUG #18045: NpgSQL installation not working PG Bug reporting form 14:37
RE: pg_hba.conf "authentication file token too long, skipping" Zechman, Derek S 16:29
BUG #18046: stats collection behaviour change is affecting the usability of information. PG Bug reporting form 16:32

Aug. 2, 2023

Thread Author Time
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Amit Kapila 05:20
RE: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Zhijie Hou (Fujitsu) 06:12
Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1 Andrey M. Borodin 08:34
Re: pg_hba.conf "authentication file token too long, skipping" Euler Taveira 16:20
Re: BUG #18045: NpgSQL installation not working Euler Taveira 16:29
[BUG REPORT] Unexpected cast while matching CHAR type 翁思扬 17:23
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Tom Lane 18:01
Re: [BUG REPORT] Unexpected cast while matching CHAR type Tom Lane 18:35
Re: search_path not recomputed when role name changes 📎 Jeff Davis 19:09
Re: pg_restore 14 skips ACL COLUMN when --schema is used Euler Taveira 19:30
Re: pg_restore 14 skips ACL COLUMN when --schema is used Tom Lane 20:06
Re: pg_restore 14 skips ACL COLUMN when --schema is used Euler Taveira 20:53
Re: pg_restore 14 skips ACL COLUMN when --schema is used Kong Man 21:05

Aug. 3, 2023

Thread Author Time
BUG #18047: ODBC to PG long transaction causes PANIC PG Bug reporting form 01:28
Re: BUG #18047: ODBC to PG long transaction causes PANIC 📎 justin tocci 05:08
Re: BUG #18047: ODBC to PG long transaction causes PANIC Julien Rouhaud 05:14
BUG #18048: Database process terminated automatically PG Bug reporting form 10:27
Re: BUG #18048: Database process terminated automatically David Rowley 11:42
WHERE column = X AND column = Y will always be zero matching rows [Quipsy] Markus Karg 14:20
Re: BUG #18047: ODBC to PG long transaction causes PANIC Justin Tocci 14:48
Re: WHERE column = X AND column = Y will always be zero matching rows David G. Johnston 14:48
Re: WHERE column = X AND column = Y will always be zero matching rows Laurenz Albe 14:53
AW: WHERE column = X AND column = Y will always be zero matching rows [Quipsy] Markus Karg 14:53
Re: WHERE column = X AND column = Y will always be zero matching rows David G. Johnston 15:02
Re: WHERE column = X AND column = Y will always be zero matching rows Jaime Casanova 17:55
Re: WHERE column = X AND column = Y will always be zero matching rows Tom Lane 17:59
Re: search_path not recomputed when role name changes Nathan Bossart 23:28
Re: BUG #18047: ODBC to PG long transaction causes PANIC Thomas Munro 23:31

Aug. 4, 2023

Thread Author Time
BUG #18049: dynamic_shared_memory_type's value `posix` doesn't have any effect, syscall shm_get executes PG Bug reporting form 05:22
AW: WHERE column = X AND column = Y will always be zero matching rows [Quipsy] Markus Karg 06:12
Re: BUG #18046: stats collection behaviour change is affecting the usability of information. 📎 Hamid Akhtar 11:22
Re: BUG #18049: dynamic_shared_memory_type's value `posix` doesn't have any effect, syscall shm_get executes Andrew Dunstan 13:22
Re: BUG #18046: stats collection behaviour change is affecting the usability of information. Jobin Augustine 17:10

Aug. 5, 2023

Thread Author Time
Re:BUG #17948: libpq seems to misbehave in a pipelining corner case 📎 Трофимов Иван 12:03

Aug. 6, 2023

Thread Author Time
PostgreSQL doesn't display exact version Jacob Pfundstein 16:19

Aug. 7, 2023

Thread Author Time
Re: BUG #18049: dynamic_shared_memory_type's value `posix` doesn't have any effect, syscall shm_get executes jitu 14:38
Re: search_path not recomputed when role name changes Michael Paquier 23:20

Aug. 8, 2023

Thread Author Time
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Michael Paquier 00:31

Aug. 9, 2023

Thread Author Time
Re: pg_restore 14 skips ACL COLUMN when --schema is used 📎 Euler Taveira 01:31
BUG #18051: char(N) and varchar(N) behave opposite to the documentation PG Bug reporting form 08:55
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation David G. Johnston 12:57
Re: pg_restore 14 skips ACL COLUMN when --schema is used Tom Lane 13:39
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation Nicolas Gouteux 14:04
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation Nicolas Gouteux 14:28
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation David Rowley 14:37
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation David Rowley 14:43
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation Nicolas Gouteux 14:47
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation Nicolas Gouteux 14:49
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation Félix GERZAGUET 15:02
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation David Rowley 15:03
Re: BUG #18051: char(N) and varchar(N) behave opposite to the documentation Tom Lane 15:26
Re: pg_dump needs SELECT privileges on irrelevant extension table 📎 Jacob Champion 23:10

Aug. 10, 2023

Thread Author Time
Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate Bruce Momjian 02:39
Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate Tom Lane 02:53
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 07:45
Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate Bruce Momjian 11:25
BUG #18053: fastpath count per pid in pg_locks shows > 16 entries PG Bug reporting form 12:31
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 23:22

Aug. 11, 2023

Thread Author Time
Re: BUG #18040: PostgreSQL does not report its version correctly Bruce Momjian 02:02
Re: BUG #18040: PostgreSQL does not report its version correctly David G. Johnston 02:42
Re: BUG #17928: Standby fails to decode WAL on termination of primary Noah Misch 02:58
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 06:08
Re: BUG #17928: Standby fails to decode WAL on termination of primary Noah Misch 14:00
Re: BUG #18040: PostgreSQL does not report its version correctly Andrew Dunstan 20:37
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Jacob Speidel 21:15
Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro 23:56

Aug. 12, 2023

Thread Author Time
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 00:20
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Michael Paquier 00:23
Re: BUG #17928: Standby fails to decode WAL on termination of primary Tom Lane 00:32
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Andres Freund 00:48
Re: BUG #17928: Standby fails to decode WAL on termination of primary Noah Misch 21:13

Aug. 13, 2023

Thread Author Time
Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro 03:12
Re: BUG #17928: Standby fails to decode WAL on termination of primary Noah Misch 03:30
BUG #18054: Permission denied. PG Bug reporting form 04:26
Re: BUG #18040: PostgreSQL does not report its version correctly Sandeep Thakkar 09:38
Re: BUG #17950: Incorrect memory access in gtsvector_picksplit() 📎 Alexander Lakhin 13:00
Re: BUG #17950: Incorrect memory access in gtsvector_picksplit() Tom Lane 14:35
Re: BUG #17950: Incorrect memory access in gtsvector_picksplit() Alexander Lakhin 18:00
Re: BUG #18013: Failed installing otheus uibk 19:15
Re: BUG #18013: Failed installing otheus uibk 19:18
gpg error (again) otheus uibk 19:19

Aug. 14, 2023

Thread Author Time
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Michael Paquier 00:11
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 02:08
Re: BUG #18054: Permission denied. Julien Rouhaud 03:00
Re: BUG #18054: Permission denied. Tom Lane 03:27
Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro 03:56
Re: BUG #17928: Standby fails to decode WAL on termination of primary 📎 Thomas Munro 10:28
Re: gpg error (again) Devrim Gündüz 11:02
BUG #18055: logical decoding core on AllocateSnapshotBuilder() PG Bug reporting form 16:04
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() 📎 ocean_li_996 17:03

Aug. 15, 2023

Thread Author Time
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 02:04
Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro 02:36
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 03:00
Re: BUG #17928: Standby fails to decode WAL on termination of primary 📎 Michael Paquier 06:11
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Heikki Linnakangas 14:40
BUG #18057: unaccent removes intentional spaces PG Bug reporting form 19:54
Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used Andy Fan 23:34

Aug. 16, 2023

Thread Author Time
Re: BUG #18057: unaccent removes intentional spaces Michael Paquier 00:00
Re: BUG #17928: Standby fails to decode WAL on termination of primary 📎 Thomas Munro 03:29
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 06:17
BUG #18058: Http Extension Postgres PG Bug reporting form 06:32

Aug. 17, 2023

Thread Author Time
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila 03:24
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() 📎 Zhijie Hou (Fujitsu) 06:51
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila 10:03
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila 10:07
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() 📎 Zhijie Hou (Fujitsu) 12:10
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Masahiko Sawada 14:03
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 14:27
BUG #18059: Unexpected error 25001 in stored procedure PG Bug reporting form 14:35
Postgresql15 crash with :FATAL: could not open shared memory segment "/PostgreSQL.0000000": No such file or directory Emile Amewoto (ZA) 20:27

Aug. 18, 2023

Thread Author Time
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 00:20
Re: BUG #17928: Standby fails to decode WAL on termination of primary Thomas Munro 02:30
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() 📎 Zhijie Hou (Fujitsu) 04:21
Re: BUG #17928: Standby fails to decode WAL on termination of primary Michael Paquier 04:55
Postgresql15 crash with :FATAL: could not open shared memory segment "/PostgreSQL.0000000": No such file or directory Emile Amewoto 05:36
Re: BUG #18057: unaccent removes intentional spaces Michael Paquier 06:18
Re: pg_rewind WAL segments deletion pitfall torikoshia 06:40
BUG #18060: Left joining rows using random() function in join condition doesn't work as expected. PG Bug reporting form 09:30
Re:Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate yanliang lei 13:57
BUG #18061: The psql -v variable option does not work for the -c command option PG Bug reporting form 14:28

Aug. 19, 2023

Thread Author Time
Re: BUG #18057: unaccent removes intentional spaces Tom Lane 16:30
Re: BUG #18059: Unexpected error 25001 in stored procedure Tom Lane 17:19
Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate Vik Fearing 19:39
Re: BUG #18057: unaccent removes intentional spaces Michael Paquier 23:57

Aug. 20, 2023

Thread Author Time
Re: BUG #18057: unaccent removes intentional spaces Tom Lane 00:08
Re: BUG #18057: unaccent removes intentional spaces Michael Paquier 00:20
Re: BUG #18060: Left joining rows using random() function in join condition doesn't work as expected. Tom Lane 16:12
Re:RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() ocean_li_996 16:51
Re: BUG #18061: The psql -v variable option does not work for the -c command option David G. Johnston 16:58
Re: BUG #18060: Left joining rows using random() function in join condition doesn't work as expected. James Inform 17:58
Re: BUG #18060: Left joining rows using random() function in join condition doesn't work as expected. James Inform 18:26
Re: BUG #18060: Left joining rows using random() function in join condition doesn't work as expected. David Rowley 21:04
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Andres Freund 21:05
Re: BUG #18060: Left joining rows using random() function in join condition doesn't work as expected. James Inform 21:12
Re: BUG #17928: Standby fails to decode WAL on termination of primary 📎 Michael Paquier 23:32

Aug. 21, 2023

Thread Author Time
Re: BUG #18057: unaccent removes intentional spaces 📎 Michael Paquier 07:14
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Alvaro Herrera 12:33
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Masahiko Sawada 12:41
Re: BUG #18059: Unexpected error 25001 in stored procedure Robert Haas 13:32
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila 13:37
PGRES_EMPTY_QUERY from Postgre 14.3 Sanjay Patil 14:59
Re: Postgresql15 crash with :FATAL: could not open shared memory segment "/PostgreSQL.0000000": No such file or directory Euler Taveira 15:23
Re: PGRES_EMPTY_QUERY from Postgre 14.3 David G. Johnston 15:52
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 16:04
Re: Postgresql15 crash with :FATAL: could not open shared memory segment "/PostgreSQL.0000000": No such file or directory Emile Amewoto 16:20
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 16:30
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Andres Freund 18:19
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Andres Freund 18:27
cache lookup failed dropping public schema with trgm index Wyatt Alt 18:40
Re: Postgresql15 crash with :FATAL: could not open shared memory segment "/PostgreSQL.0000000": No such file or directory Michael Paquier 22:07
Re: cache lookup failed dropping public schema with trgm index Michael Paquier 22:09
Re: cache lookup failed dropping public schema with trgm index Andres Freund 22:36
Re: cache lookup failed dropping public schema with trgm index Michael Paquier 22:55
Re: cache lookup failed dropping public schema with trgm index Wyatt Alt 23:13
Re: cache lookup failed dropping public schema with trgm index Tom Lane 23:27

Aug. 22, 2023

Thread Author Time
Re: cache lookup failed dropping public schema with trgm index Michael Paquier 01:43
Re: pg_rewind WAL segments deletion pitfall Michael Paquier 05:32
BUG #18063: postgresql-x64-14 service not working PG Bug reporting form 07:11
BUG #18064: Order of cascading deletes by foreign key; "on delete restrict" PG Bug reporting form 08:45
BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector". PG Bug reporting form 09:06
Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector". David G. Johnston 12:51
Re: BUG #18064: Order of cascading deletes by foreign key; "on delete restrict" David G. Johnston 13:10
Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector". Tom Lane 13:26
Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector". David G. Johnston 13:45
Re: BUG #18061: The psql -v variable option does not work for the -c command option Robert Greene 15:31
Re: cache lookup failed dropping public schema with trgm index Andres Freund 18:45
BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION` PG Bug reporting form 18:57
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 19:22
Re: pg_dump assertion failure with "-n pg_catalog" Jeff Davis 20:10
Re: BUG #18059: Unexpected error 25001 in stored procedure Tom Lane 21:29

Aug. 23, 2023

Thread Author Time
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila 08:46
Re: pg_rewind WAL segments deletion pitfall torikoshia 09:04
Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector". kaijian xu 11:40
Re: pg_rewind WAL segments deletion pitfall 📎 Alexander Kukushkin 11:44
Re: BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION` Euler Taveira 19:26
Re: BUG #18059: Unexpected error 25001 in stored procedure 📎 Tom Lane 20:53

Aug. 24, 2023

Thread Author Time
Re: pg_rewind WAL segments deletion pitfall Kyotaro Horiguchi 00:45
BUG #18068: Insufficient permission unless SUPERUSER PG Bug reporting form 02:26
Re: BUG #18068: Insufficient permission unless SUPERUSER David G. Johnston 12:49
Error when using unquoted identifier that contains the word end in a begin atomic block Jonathan Zacharuk 19:53
Re: Error when using unquoted identifier that contains the word end in a begin atomic block Tom Lane 20:12
RE: Error when using unquoted identifier that contains the word end in a begin atomic block Jonathan Zacharuk 20:23

Aug. 25, 2023

Thread Author Time
Re: BUG #18068: Insufficient permission unless SUPERUSER Ghw 00:17
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() 📎 Zhijie Hou (Fujitsu) 04:06
BUG #18069: pg_is_in_recovery() is false but recovery is not yet completed(i.e. recovery.signal is present) PG Bug reporting form 06:40
BUG #18070: Assertion failed when processing error from plpy's iterator PG Bug reporting form 14:00

Aug. 27, 2023

Thread Author Time
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Joe Conway 13:41
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Heikki Linnakangas 20:24

Aug. 28, 2023

Thread Author Time
Re: cache lookup failed dropping public schema with trgm index Michael Paquier 02:15
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Zhijie Hou (Fujitsu) 05:39
group by true now errors with non-integer constant in GROUP BY David Micallef 06:27
Re: group by true now errors with non-integer constant in GROUP BY 📎 John Naylor 09:24
Re: group by true now errors with non-integer constant in GROUP BY Tom Lane 19:56

Browse Archives

Prev | Next