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

Sept. 1, 2020

Thread Author Time
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. 📎 Alvaro Herrera 01:25
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. 📎 Alvaro Herrera 01:30
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. 📎 Michael Paquier 02:58
答复: a segfault failure of query KANGQIAOPING754 10:49
BUG #16603: Permission issue PG Bug reporting form 16:09
Re: BUG #16603: Permission issue Stephen Frost 16:16
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. Alvaro Herrera 17:44
Re: BUG #16601: Restore Issue Yash Raj 18:27
BUG #16604: pg_dump with --jobs breaks SSL connections PG Bug reporting form 20:08
Re: BUG #16486: Prompted password is ignored when password specified in connection string 📎 Bruce Momjian 20:38
Re: BUG #16557: getProcedureColumns() function returns columns, when there is no existing Stored Procedure in the DB Dave Cramer 22:35
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Peter Geoghegan 23:01
Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message. Michael Paquier 23:03

Sept. 2, 2020

Thread Author Time
RE: BUG #16557: getProcedureColumns() function returns columns, when there is no existing Stored Procedure in the DB 📎 Adarshdeep Cheema 02:21
Re: BUG #16486: Prompted password is ignored when password specified in connection string Oleksandr Shulgin 07:54
Re: BUG #16586: deduplicate_items=true can be configured for numeric indexes Matthias van de Meent 10:43
BUG #16605: PostgreSQL recovery startup process waiting and blocking to application queries PG Bug reporting form 10:58
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Peter Eisentraut 12:06
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Jehan-Guillaume de Rorthais 12:55
Re: BUG #16486: Prompted password is ignored when password specified in connection string Bruce Momjian 13:18
Re: BUG #16486: Prompted password is ignored when password specified in connection string Tom Lane 14:46
Re: BUG #16557: getProcedureColumns() function returns columns, when there is no existing Stored Procedure in the DB Dave Cramer 15:39
[BUG v13] Crash with event trigger in extension 📎 Jehan-Guillaume de Rorthais 17:37
Re: [BUG v13] Crash with event trigger in extension Alvaro Herrera 17:53
Re: BUG #16486: Prompted password is ignored when password specified in connection string Tom Lane 19:47

Sept. 3, 2020

Thread Author Time
Re: BUG #16605: PostgreSQL recovery startup process waiting and blocking to application queries Kyotaro Horiguchi 03:22
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Daniel Verite 07:41
Download page of Postgres not working Vibhor Mark Steele 07:48
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Peter Eisentraut 08:26
BUG #16606: V 4.25: unable to drop database PG Bug reporting form 08:43
Re: Download page of Postgres not working Daniel Gustafsson 08:54
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Jehan-Guillaume de Rorthais 08:57
Re: Download page of Postgres not working Magnus Hagander 09:03
Re: Download page of Postgres not working Dave Page 09:28
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Daniel Verite 09:29
Re: BUG #16606: V 4.25: unable to drop database Alexander Korotkov 17:32
Re: [BUG v13] Crash with event trigger in extension 📎 Jehan-Guillaume de Rorthais 17:41
[No subject] Tom Lane 17:49
Re: BUG #16486: Prompted password is ignored when password specified in connection string 📎 Bruce Momjian 19:05

Sept. 4, 2020

Thread Author Time
Re: [BUG v13] Crash with event trigger in extension Michael Paquier 01:20
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 01:21
Re: [BUG v13] Crash with event trigger in extension Jehan-Guillaume de Rorthais 09:37
Re: [BUG v13] Crash with event trigger in extension Alvaro Herrera 13:27
Re: [BUG v13] Crash with event trigger in extension 📎 Jehan-Guillaume de Rorthais 14:56
Re: [BUG] plpgsql RETURN QUERY with toasted fields -vs- DROP/TRUNCATE Jehan-Guillaume de Rorthais 15:02
Re: BUG #16419: wrong parsing BC year in to_date() function David G. Johnston 19:45
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 20:12
Re: BUG #16419: wrong parsing BC year in to_date() function 📎 Peter Eisentraut 21:05

Sept. 6, 2020

Thread Author Time
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎 Tom Lane 23:46

Sept. 7, 2020

Thread Author Time
Re: [BUG v13] Crash with event trigger in extension Michael Paquier 01:35
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Pavel Stehule 03:46
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows 📎 Jehan-Guillaume de Rorthais 13:27

Sept. 8, 2020

Thread Author Time
Re: [BUG v13] Crash with event trigger in extension 📎 Michael Paquier 05:27
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Michael Paquier 07:45
Re: [BUG v13] Crash with event trigger in extension Jehan-Guillaume de Rorthais 14:15
Re: [BUG v13] Crash with event trigger in extension Alvaro Herrera 14:33
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Peter Eisentraut 14:36
Re: [BUG v13] Crash with event trigger in extension Jehan-Guillaume de Rorthais 17:07
Re: [BUG v13] Crash with event trigger in extension Alvaro Herrera 17:32
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Alvaro Herrera 21:37
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Tomas Vondra 23:55

Sept. 9, 2020

Thread Author Time
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Peter Eisentraut 08:08
BUG #16610: server process was terminated by signal 11: Segmentation fault PG Bug reporting form 09:27
Re: [BUG v13] Crash with event trigger in extension Jehan-Guillaume de Rorthais 10:58
Re: invalid alloc size error possible in shm_mq 📎 Markus Wanner 12:37
Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Michael Paquier 12:46
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Tom Lane 13:38
BUG #16611: devel package installation issue.When tried to installed the PostgreSQL 11.0 version ecpg not get PG Bug reporting form 13:59
Re: BUG #16611: devel package installation issue.When tried to installed the PostgreSQL 11.0 version ecpg not get Magnus Hagander 14:12
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows 📎 Jehan-Guillaume de Rorthais 16:20
BUG #16613: Built in suppress_redundant_updates_trigger() trigger not supressing redundant updates PG Bug reporting form 16:25
Re: BUG #16613: Built in suppress_redundant_updates_trigger() trigger not supressing redundant updates Tom Lane 17:38
Re: BUG #16613: Built in suppress_redundant_updates_trigger() trigger not supressing redundant updates Stephane Desnault 18:05
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Peter Eisentraut 18:47

Sept. 10, 2020

Thread Author Time
BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain PG Bug reporting form 08:45
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Peter Eisentraut 13:45
Re: BUG #15858: could not stat file - over 4GB Greg Steiner 14:30
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Tom Lane 14:43

Sept. 11, 2020

Thread Author Time
Re: [BUG v13] Crash with event trigger in extension Michael Paquier 06:14
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Michael Paquier 06:30
Re: [BUG v13] Crash with event trigger in extension Jehan-Guillaume de Rorthais 08:09
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Tom Lane 14:21
Re: BUG #16605: PostgreSQL recovery startup process waiting and blocking to application queries Tushar Takate 16:48

Sept. 12, 2020

Thread Author Time
Re: [BUG v13] Crash with event trigger in extension Michael Paquier 00:21
Re: [BUG v13] Crash with event trigger in extension Alvaro Herrera 00:22
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Michael Paquier 01:48
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Giorgio Saviane 08:18
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Francisco Olarte 10:59
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Giorgio Saviane 11:57
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Francisco Olarte 15:13
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Tom Lane 15:49
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Giorgio Saviane 16:06
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Tom Lane 18:18
Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain Giorgio Saviane 18:38

Sept. 13, 2020

Thread Author Time
BUG #16615: Cannot determine type of Date for "is null" expression PG Bug reporting form 00:28
Re: BUG #16272: Index expression can refer to wrong attributes if index is created via CREATE TABLE LIKE Alexander Lakhin 07:00
Re: BUG #16615: Cannot determine type of Date for "is null" expression Tom Lane 14:42
Re: BUG #16272: Index expression can refer to wrong attributes if index is created via CREATE TABLE LIKE Tom Lane 16:53

Sept. 14, 2020

Thread Author Time
Re: BUG #16605: PostgreSQL recovery startup process waiting and blocking to application queries Kyotaro Horiguchi 02:05
Re: BUG #16615: Cannot determine type of Date for "is null" expression yuanhang 03:23
Re: BUG #16615: Cannot determine type of Date for "is null" expression David G. Johnston 18:29

Sept. 15, 2020

Thread Author Time
Re: BUG #16486: Prompted password is ignored when password specified in connection string David G. Johnston 01:59
BUG #16616: Segmentation fault when use explain PG Bug reporting form 03:47
Re: BUG #16604: pg_dump with --jobs breaks SSL connections Daniel Gustafsson 11:36
Re: BUG #16604: pg_dump with --jobs breaks SSL connections Magnus Hagander 12:04
Re: BUG #16616: Segmentation fault when use explain Tom Lane 13:54

Sept. 16, 2020

Thread Author Time
Re: [BUG v13] Crash with event trigger in extension Alvaro Herrera 00:26
Re: [BUG v13] Crash with event trigger in extension Michael Paquier 06:36
BUG #16618: XX000: cache lookup failed for function PG Bug reporting form 07:18
Re: [BUG v13] Crash with event trigger in extension Jehan-Guillaume de Rorthais 08:53
BUG #16619: Amcheck detects corruption in hstore' btree index (ver 2) PG Bug reporting form 10:34
Strange output of XML attribute values Andrew Marynchuk (Андрей Маринчук) 12:09
Re: Strange output of XML attribute values Pavel Stehule 12:50
BUG #16620: Autovacuum does not process certain databases after migration from postgresql 10 PG Bug reporting form 13:39
Re: Strange output of XML attribute values Pavel Stehule 13:40
Re: BUG #16619: Amcheck detects corruption in hstore' btree index (ver 2) 📎 Anastasia Lubennikova 14:24
Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values RECHTÉ Marc 15:06
Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values Jehan-Guillaume de Rorthais 15:31
Re: BUG #16619: Amcheck detects corruption in hstore' btree index (ver 2) Peter Geoghegan 17:47
table partition with inheritance having current_timestamp issue if we miss range table Nagaraj Raj 18:22
Re: table partition with inheritance having current_timestamp issue if we miss range table Tom Lane 18:51
Re: Strange output of XML attribute values Andrew Marynchuk (Андрей Маринчук) 20:23
BUG #16621: Unexpected Foreign Key Constraint Violation when Creating New Child Partition PG Bug reporting form 20:35
Re: BUG #16620: Autovacuum does not process certain databases after migration from postgresql 10 Max Vikharev 20:50
Re: BUG #16619: Amcheck detects corruption in hstore' btree index (ver 2) Alexander Korotkov 21:55
Re: BUG #16619: Amcheck detects corruption in hstore' btree index (ver 2) Peter Geoghegan 22:29

Sept. 17, 2020

Thread Author Time
Re: BUG #16620: Autovacuum does not process certain databases after migration from postgresql 10 Tom Lane 01:19
Re: Strange output of XML attribute values Pavel Stehule 03:49
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Michael Paquier 05:53
Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values RECHTÉ Marc 06:38
Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values Jehan-Guillaume de Rorthais 07:39
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 07:45
Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values RECHTÉ Marc 11:02
Re: BUG #15858: could not stat file - over 4GB 📎 Juan José Santamaría Flecha 15:16
Re: BUG #15858: could not stat file - over 4GB Tom Lane 16:04
Re: BUG #15858: could not stat file - over 4GB 📎 Ranier Vilela 18:13
Re: BUG #15858: could not stat file - over 4GB Tom Lane 18:26
Re: BUG #15858: could not stat file - over 4GB Juan José Santamaría Flecha 18:47
MinGW compilation Tomasz Szypowski 20:12

Sept. 18, 2020

Thread Author Time
BUG #16622: pg_dump produces erroneus ALTER TABLE statement for a table with an inherited generated column PG Bug reporting form 04:58
BUG #16623: JSON select query result is getting differed when we change DB version PG Bug reporting form 05:55
Re: BUG #16622: pg_dump produces erroneus ALTER TABLE statement for a table with an inherited generated column 📎 Daniel Gustafsson 09:38
Re: BUG #15858: could not stat file - over 4GB Juan José Santamaría Flecha 10:47
Re: BUG #16623: JSON select query result is getting differed when we change DB version Tom Lane 13:52
BUG #16624: Query Optimizer - Performance bug related to predicate simplification PG Bug reporting form 16:14
Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification Tom Lane 21:22

Sept. 19, 2020

Thread Author Time
BUG #16625: Query Optimizer - Performance bug related to removal of unnecessary aggregate function PG Bug reporting form 03:32
Re: BUG #16625: Query Optimizer - Performance bug related to removal of unnecessary aggregate function Christophe Pettus 15:57
Re: BUG #16625: Query Optimizer - Performance bug related to removal of unnecessary aggregate function Xinyu Liu 16:05

Sept. 21, 2020

Thread Author Time
Re: BUG #16625: Query Optimizer - Performance bug related to removal of unnecessary aggregate function David Rowley 00:00
Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification David Rowley 01:49
Re: BUG #16622: pg_dump produces erroneus ALTER TABLE statement for a table with an inherited generated column Tom Lane 21:20

Sept. 22, 2020

Thread Author Time
Postgresql Bug Report 📎 İsmet BALAT 06:41
Re: Postgresql Bug Report Julien Rouhaud 08:13
Re: Postgresql Bug Report 📎 İsmet BALAT 11:36
Re: Postgresql Bug Report Julien Rouhaud 11:52
Re: Postgresql Bug Report Julien Rouhaud 13:03
Re: Postgresql Bug Report İsmet BALAT 13:07
BUG #16627: union all with partioned table yields random aggregate results PG Bug reporting form 15:10
Re: BUG #16627: union all with partioned table yields random aggregate results Tom Lane 15:53
RE: BUG #16627: union all with partioned table yields random aggregate results Brian Kanaga 17:41
Re: BUG #16627: union all with partioned table yields random aggregate results Tom Lane 18:45
BUG #16628: Hostame and string connection functions PG Bug reporting form 18:57

Sept. 23, 2020

Thread Author Time
BUG #16629: Repo Error During Upgrade PG Bug reporting form 00:30
Re: BUG #16627: union all with partioned table yields random aggregate results 📎 David Rowley 03:10
BUG #16630: TupleDesc reference leak: TupleDesc 0x7fad89c9c928 (16386,-1) still referenced PG Bug reporting form 08:26
RE: BUG #16627: union all with partioned table yields random aggregate results 📎 Brian Kanaga 13:47
RE: BUG #16627: union all with partioned table yields random aggregate results Brian Kanaga 13:53
mysql-fdw fail Emmanuel OÑA 15:49
Re: BUG #16630: TupleDesc reference leak: TupleDesc 0x7fad89c9c928 (16386,-1) still referenced Peter Geoghegan 16:12
Re: BUG #16630: TupleDesc reference leak: TupleDesc 0x7fad89c9c928 (16386,-1) still referenced Pavel Stehule 16:28
BUG #16631: postgres_fdw tries to insert into generated columns PG Bug reporting form 18:41
Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification Peter Geoghegan 19:22
Re: BUG #16604: pg_dump with --jobs breaks SSL connections Zsolt Ero 19:26
Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification Tom Lane 19:48
Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification Peter Geoghegan 20:49

Sept. 24, 2020

Thread Author Time
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Michael Paquier 03:34
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Tom Lane 04:06
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Michael Paquier 04:11
Re: BUG #15383: Join Filter cost estimation problem in 10.5 David Rowley 05:10
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Michael Paquier 06:32
BUG #16632: Not a bug, just a typo PG Bug reporting form 07:06
BUG #16633: Foreign data wrapper mysql-fdw issue PG Bug reporting form 08:46
BUG #16634: Conflicting names of indexes for partitioned tables PG Bug reporting form 09:20
Re: BUG #16632: Not a bug, just a typo Daniel Gustafsson 09:39
Re: BUG #16627: union all with partioned table yields random aggregate results David Rowley 09:43
Re: mysql-fdw fail Etsuro Fujita 10:35
Re: BUG #16634: Conflicting names of indexes for partitioned tables Tom Lane 14:08
Re: BUG #16632: Not a bug, just a typo Jonathan S. Katz 14:55
Re: BUG #16604: pg_dump with --jobs breaks SSL connections Tom Lane 16:11
Re: BUG #16604: pg_dump with --jobs breaks SSL connections 📎 Tom Lane 17:24
Re: BUG #16604: pg_dump with --jobs breaks SSL connections Tom Lane 17:42
Re: BUG #16604: pg_dump with --jobs breaks SSL connections 📎 Tom Lane 20:13
Re: BUG #16634: Conflicting names of indexes for partitioned tables Michał Albrycht 20:26
PG13 pg_receivewal failing Grigory Smolkin 20:51
Re: BUG #16628: Hostame and string connection functions Bruce Momjian 21:07

Sept. 25, 2020

Thread Author Time
Re: PG13 pg_receivewal failing Fujii Masao 00:46
Re: BUG #15383: Join Filter cost estimation problem in 10.5 David Rowley 01:49
Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification Xinyu Liu 02:43
BUG #16635: Query Optimizer - Performance optimization for the UNION function PG Bug reporting form 03:39

Browse Archives

Prev | Next