pgsql-bugs - August 2020

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

Thread Author Time
BUG #16568: pg_upgrade failed from 9.3 to 9.6 PG Bug reporting form 08:27

Aug. 2, 2020

Thread Author Time
Re: BUG #16568: pg_upgrade failed from 9.3 to 9.6 Tom Lane 21:11

Aug. 3, 2020

Thread Author Time
BUG #16569: Document "59.2. Built-in Operator Classes" have a clerical error PG Bug reporting form 03:28
BUG #16570: Collation not working PG Bug reporting form 07:14
BUG #16571: "time with time zone" type can input '00:00:00+1559'::time with time zone PG Bug reporting form 07:26
Re: BUG #16571: "time with time zone" type can input '00:00:00+1559'::time with time zone Tom Lane 14:18
Re: BUG #16570: Collation not working Daniel Verite 17:35

Aug. 4, 2020

Thread Author Time
Re: BUG #16570: Collation not working Arnaud Perrier 07:15
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎 Peter Eisentraut 14:08
BUG #16572: pgadmin change column order PG Bug reporting form 14:18
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Pavel Stehule 14:21
Re: BUG #16570: Collation not working Daniel Verite 14:32
Re: BUG #16572: pgadmin change column order David G. Johnston 15:08
Re: BUG #16569: Document "59.2. Built-in Operator Classes" have a clerical error Tomas Vondra 17:11
Re: BUG #16556: The database cluster initialisation failed - Win 10 postgresql 12.3 version installation error Tomas Vondra 17:28
BUG #16573: pgbouncer 1.14 addition to EL6 breaks installation PG Bug reporting form 18:21
Re: BUG #16570: Collation not working Tom Lane 22:36

Aug. 5, 2020

Thread Author Time
Re: BUG #16570: Collation not working Arnaud Perrier 06:41
Re: BUG #16572: pgadmin change column order Guillaume Lelarge 08:10
BUG #16574: Error in configuration of pgadmin4-server (amd64 4.24) on Debian version 10.5 PG Bug reporting form 11:46
Index not used without explicit typecast Jan Kort 13:05
Re: Index not used without explicit typecast Tom Lane 14:32
Re: BUG #16570: Collation not working Daniel Verite 14:49
Re: Index not used without explicit typecast Jan Kort 16:39
Re: BUG #16570: Collation not working Jehan-Guillaume de Rorthais 20:31
Re: BUG #16570: Collation not working Tom Lane 21:30

Aug. 6, 2020

Thread Author Time
Re: Index not used without explicit typecast Pavel Stehule 03:48
Re: BUG #16570: Collation not working Jehan-Guillaume de Rorthais 21:18

Aug. 7, 2020

Thread Author Time
BUG #16575: Linux Mint 20, ulyana won't update postgres as described PG Bug reporting form 03:57
Re: BUG #16556: The database cluster initialisation failed - Win 10 postgresql 12.3 version installation error Sandeep Thakkar 04:28
BUG #16576: Creating a connection using psycopg2 results in "zombie" ccapiserver.exe processes on Windows PG Bug reporting form 15:52

Aug. 9, 2020

Thread Author Time
BUG #16577: Segfault on altering a table located in a dropped tablespace PG Bug reporting form 11:00
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Michael Paquier 13:20
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Tom Lane 16:53

Aug. 10, 2020

Thread Author Time
a segfault failure of query 康桥平 10:14
Re: a segfault failure of query Tom Lane 13:44
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace 📎 Alvaro Herrera 18:24
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Tom Lane 18:59
Re: BUG #16573: pgbouncer 1.14 addition to EL6 breaks installation Devrim Gündüz 23:54

Aug. 11, 2020

Thread Author Time
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Michael Paquier 07:04
Re: [noreply@postgresql.org: BUG #16575: Linux Mint 20, ulyana won't update postgres as described] Christoph Berg 09:05
Re: posgres 12 bug (partitioned table) Robert Haas 15:21
Re: posgres 12 bug (partitioned table) Tom Lane 15:33
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 16:02
Re: posgres 12 bug (partitioned table) Robert Haas 17:13
Re: posgres 12 bug (partitioned table) Andres Freund 17:22
Re: posgres 12 bug (partitioned table) Tom Lane 17:52
Re: posgres 12 bug (partitioned table) Andres Freund 18:02
Re: posgres 12 bug (partitioned table) 📎 Andres Freund 18:06
Re: posgres 12 bug (partitioned table) Andres Freund 18:06
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 18:31
Re: posgres 12 bug (partitioned table) Andres Freund 18:39
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 18:55
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 18:59
Re: posgres 12 bug (partitioned table) Andres Freund 19:01

Aug. 12, 2020

Thread Author Time
Re: posgres 12 bug (partitioned table) Amit Langote 03:51
Re: posgres 12 bug (partitioned table) Tom Lane 04:08
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Peter Geoghegan 04:14
Re: posgres 12 bug (partitioned table) Amit Langote 05:19
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎 Peter Eisentraut 07:04
BUG #16578: When making an insert, the database goes to recover mode PG Bug reporting form 07:45
BUG #16579: In some areas of UTC+8, "CST" in the log is recognized as the wrong time zone when importing these PG Bug reporting form 07:51
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 08:06
AW: posgres 12 bug (partitioned table) Wilm Hoyer 09:35
Re: AW: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 10:10
AW: AW: posgres 12 bug (partitioned table) Wilm Hoyer 10:57
Re: AW: AW: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 11:08
Re: BUG #16578: When making an insert, the database goes to recover mode Tom Lane 12:41
Re: BUG #16579: In some areas of UTC+8, "CST" in the log is recognized as the wrong time zone when importing these Tom Lane 12:57
Re: posgres 12 bug (partitioned table) Andres Freund 16:27
BUG #16580: PostgreSQL PassTheHash Protocol Design Weakness Detected - vulnerability PG Bug reporting form 20:41
Re: BUG #16580: PostgreSQL PassTheHash Protocol Design Weakness Detected - vulnerability Stephen Frost 20:54

Aug. 13, 2020

Thread Author Time
Re: posgres 12 bug (partitioned table) Amit Langote 04:13
Re: posgres 12 bug (partitioned table) Tom Lane 04:35
Re: BUG #16565: Systemd service file does not create /var/run/postgresql directory across reboot Marco Cuccato 07:17
Re: BUG #16508: using multi-host connection string when the first host is starting fails Noah Misch 07:55
BUG #16581: Corrupted debian repository PG Bug reporting form 14:12
Re: BUG #16581: Corrupted debian repository Christoph Berg 14:22
Re: BUG #16508: using multi-host connection string when the first host is starting fails 📎 Tom Lane 22:08

Aug. 14, 2020

Thread Author Time
Re: BUG #16508: using multi-host connection string when the first host is starting fails Noah Misch 07:51
BUG #16582: Logical index corruption leading to apparent index scan infinite loop PG Bug reporting form 20:50
Re: BUG #16582: Logical index corruption leading to apparent index scan infinite loop Peter Geoghegan 21:32

Aug. 15, 2020

Thread Author Time
Logical replication stalling for large tables with heavy write activity - Pg11 Mukesh Chhatani 22:17

Aug. 17, 2020

Thread Author Time
BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails PG Bug reporting form 12:02
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Tom Lane 15:26
Weird behaviour after update from 12.2 to 12.3 version Andrii Palko 15:42
Re: BUG #16582: Logical index corruption leading to apparent index scan infinite loop James Lucas 15:51
Re: BUG #16582: Logical index corruption leading to apparent index scan infinite loop James Lucas 16:21
Re: Weird behaviour after update from 12.2 to 12.3 version David G. Johnston 16:55
Re: BUG #16508: using multi-host connection string when the first host is starting fails Cyril Jouve 20:48
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎 Tom Lane 22:37

Aug. 18, 2020

Thread Author Time
BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left PG Bug reporting form 13:43
Re: BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left Magnus Hagander 14:25
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Jehan-Guillaume de Rorthais 16:02
RE: BUG #16461: Segfault in autovacuum process Michael Schanne 16:06
Re: BUG #16461: Segfault in autovacuum process Tom Lane 16:20
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎 Tom Lane 20:09

Aug. 19, 2020

Thread Author Time
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Jiří Fejfar 05:39
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Tom Lane 05:53
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Jiří Fejfar 06:08
BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS PG Bug reporting form 10:31
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS David Rowley 11:34
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Andrew Gierth 13:21
Query Tool does not show in PGADMIN 4.24 📎 Omar Colmenares 16:16

Aug. 20, 2020

Thread Author Time
Re: Query Tool does not show in PGADMIN 4.24 Jiří Fejfar 05:30
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Daniel Verite 11:43
BUG #16586: deduplicate_items=true can be configured for numeric indexes PG Bug reporting form 11:48
RE: Query Tool does not show in PGADMIN 4.24 📎 Omar Colmenares 13:39
BUG #16587: Error when download PG Bug reporting form 16:04
Re: BUG #16272: Index expression can refer to wrong attributes if index is created via CREATE TABLE LIKE 📎 Tom Lane 19:18
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Tom Lane 21:25
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Andrew Gierth 21:51

Aug. 21, 2020

Thread Author Time
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Andy Fan 01:19
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Andy Fan 02:08
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Tom Lane 02:44
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Andy Fan 03:50
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Andy Fan 04:15
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS Andrew Gierth 13:04
BUG #16588: Unable to delete database due to still connection PG Bug reporting form 14:20
Re: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS 📎 Tom Lane 20:49
BUG #16589: Regression when using ADD UNIQUE+ADD FOREIGN KEY in same query in 13 beta PG Bug reporting form 20:54
Re: BUG #16586: deduplicate_items=true can be configured for numeric indexes Peter Geoghegan 22:49

Aug. 22, 2020

Thread Author Time
Re: BUG #16547: ECPG can't CALL the procedure which has INOUT parameter Bruce Momjian 00:59
Re: BUG #16272: Index expression can refer to wrong attributes if index is created via CREATE TABLE LIKE Michael Paquier 01:41
Re: BUG #16547: ECPG can't CALL the procedure which has INOUT parameter Michael Meskes 15:52
Re: BUG #16589: Regression when using ADD UNIQUE+ADD FOREIGN KEY in same query in 13 beta Tom Lane 16:37
Re: BUG #16547: ECPG can't CALL the procedure which has INOUT parameter Bruce Momjian 16:54

Aug. 24, 2020

Thread Author Time
BUG #16590: jdbc driver archives are 0 byte files PG Bug reporting form 10:39
Re: BUG #16590: jdbc driver archives are 0 byte files Dave Cramer 11:43
BUG #16591: Having problem installing PostgreSQL in windows 10 PG Bug reporting form 12:16
Re: BUG #16590: jdbc driver archives are 0 byte files Tim Gregory 13:42
Re: Logical replication stalling for large tables with heavy write activity - Pg11 Amit Kapila 14:09
Re: Logical replication stalling for large tables with heavy write activity - Pg11 Mukesh Chhatani 19:30

Aug. 25, 2020

Thread Author Time
ALTER TABLE error - Could not read block 0 Robins Tharakan 03:59
ALTER TABLE ALTER COLUMN SET TYPE crash Robins Tharakan 04:14
Re: ALTER TABLE ALTER COLUMN SET TYPE crash Michael Paquier 06:05
Re: invalid alloc size error possible in shm_mq Peter Eisentraut 10:00
Re: ALTER TABLE ALTER COLUMN SET TYPE crash 📎 Bruce Momjian 15:55
Re: ALTER TABLE ALTER COLUMN SET TYPE crash Tom Lane 16:14
Re: ALTER TABLE ALTER COLUMN SET TYPE crash Bruce Momjian 17:35
BUG #16592: websearch_to_tsquery() returns queries that don't result in expected matches PG Bug reporting form 20:07
password saved in .psql_history 📎 hans.wolters 20:29
Re: password saved in .psql_history Alvaro Herrera 21:39
BUG #16593: pg_upgrade make corrupt UK indexes PG Bug reporting form 22:55

Aug. 26, 2020

Thread Author Time
Re: BUG #16593: pg_upgrade make corrupt UK indexes Nick Cleaton 05:37
Re: ALTER TABLE ALTER COLUMN SET TYPE crash Michael Paquier 07:30
Re: BUG #16593: pg_upgrade make corrupt UK indexes Magnus Hagander 07:49
Re: ALTER TABLE ALTER COLUMN SET TYPE crash Robins Tharakan 10:57
Re: ALTER TABLE ALTER COLUMN SET TYPE crash Tom Lane 12:00
BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. PG Bug reporting form 20:11
Re: ALTER TABLE ALTER COLUMN SET TYPE crash 📎 Tom Lane 20:25
Re: ALTER TABLE ALTER COLUMN SET TYPE crash Alvaro Herrera 20:44
Re: BUG #16593: pg_upgrade make corrupt UK indexes Bruce Momjian 22:57

Aug. 27, 2020

Thread Author Time
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. Michael Paquier 01:00
BUG #16595: Reads fail with "lost saved point in index" error after writes PG Bug reporting form 03:40
BUG #16596: Windows PG Bug reporting form 04:10
Re: BUG #16593: pg_upgrade make corrupt UK indexes László Tóth 07:13
BUG #16597: postgres_fdw: types in statically defined FOREIGN TABLE are not honored PG Bug reporting form 13:33
Re: BUG #16595: Reads fail with "lost saved point in index" error after writes Tom Lane 15:01
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. Alvaro Herrera 17:25
BUG #16598: SharedFileSetCreate doesn't handle PathNameCreateTemporaryFile failure correctly PG Bug reporting form 18:07
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. 📎 Alvaro Herrera 19:22
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. Jan Mußler 19:51
Re: BUG #16595: Reads fail with "lost saved point in index" error after writes Jesse Kinkead 20:19
Re: BUG #16595: Reads fail with "lost saved point in index" error after writes Tom Lane 20:39
Re: BUG #16595: Reads fail with "lost saved point in index" error after writes Jesse Kinkead 21:50
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. Michael Paquier 23:22

Aug. 28, 2020

Thread Author Time
BUG #16599: Version v4.25 is bad PG Bug reporting form 06:25
Re: BUG #16599: Version v4.25 is bad Magnus Hagander 09:01
[BUG] plpgsql RETURN QUERY with toasted fields -vs- DROP/TRUNCATE Jehan-Guillaume de Rorthais 15:43
Pg_restore failed avinash varma 16:55
Re: Pg_restore failed Magnus Hagander 17:09
Re: Pg_restore failed avinash varma 17:16
Re: Pg_restore failed Magnus Hagander 17:25
BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet PG Bug reporting form 17:58
BUG #16601: Restore Issue PG Bug reporting form 19:04
Re: BUG #16601: Restore Issue David G. Johnston 19:45
Re: BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet Tom Lane 22:07

Aug. 29, 2020

Thread Author Time
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. Michael Paquier 01:34
Re: [BUG] plpgsql RETURN QUERY with toasted fields -vs- DROP/TRUNCATE Tom Lane 17:47

Aug. 30, 2020

Thread Author Time
Re: BUG #16592: websearch_to_tsquery() returns queries that don't result in expected matches Alexander Korotkov 01:44
Re: BUG #16592: websearch_to_tsquery() returns queries that don't result in expected matches 📎 Alexander Korotkov 02:11
Re: BUG #16601: Restore Issue Yash Raj 05:27
Re: BUG #16601: Restore Issue David G. Johnston 06:58
Re: BUG #16601: Restore Issue Yash Raj 08:46
Re: BUG #16601: Restore Issue David G. Johnston 14:10

Aug. 31, 2020

Thread Author Time
BUG #16602: Installation fails with Windows user name "ABC -def". PG Bug reporting form 01:06
Re: BUG #16602: Installation fails with Windows user name "ABC -def". Sandeep Thakkar 08:13
Re: BUG #16601: Restore Issue Yash Raj 18:05
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. Alvaro Herrera 19:48
Re: BUG #16601: Restore Issue David G. Johnston 20:27

Browse Archives

Prev | Next