pgsql-bugs since 2020-09-25 00:00

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. 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
Re: BUG #16634: Conflicting names of indexes for partitioned tables Michał Albrycht 07:55
Re: PG13 pg_receivewal failing Grigory Smolkin 08:16
Memory leak in RelationBuildRowSecurity 📎 Konstantin Knizhnik 09:52
Re: BUG #16419: wrong parsing BC year in to_date() function Asif Rehman 11:39
BUG #16636: Upper case issue in JSONB type PG Bug reporting form 13:36
Re: Memory leak in RelationBuildRowSecurity Tom Lane 13:48
Re: BUG #16620: Autovacuum does not process certain databases after migration from postgresql 10 Max Vikharev 13:53
Re: Memory leak in RelationBuildRowSecurity Konstantin Knizhnik 15:16
Re: BUG #16636: Upper case issue in JSONB type David G. Johnston 15:38
Re: BUG #16627: union all with partioned table yields random aggregate results Brian Kanaga 17:54
Re: Memory leak in RelationBuildRowSecurity 📎 Tom Lane 18:07
Re: BUG #16627: union all with partioned table yields random aggregate results David G. Johnston 18:26
Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification Peter Geoghegan 20:51

Sept. 26, 2020

Thread Author Time
Re: BUG #16636: Upper case issue in JSONB type ChandraKumar Ovanan 06:25
could not translate host name "istes.rds.amazonaws.com" to address: Temporary failure in name resolution iT Inject Solar LLP 14:23
BUG #16637: Postgressql throws exception 'relation already exists' when trying to execute partition from code PG Bug reporting form 15:19
Re: Possible Spam(8.241):could not translate host name "istes.rds.amazonaws.com" to address: Temporary failure in name resolution Christopher Browne 16:00
Re: Memory leak in RelationBuildRowSecurity Konstantin Knizhnik 16:37
Re: Memory leak in RelationBuildRowSecurity Tom Lane 17:05
Re: Possible Spam(8.241):could not translate host name "istes.rds.amazonaws.com" to address: Temporary failure in name resolution iT Inject Solar LLP 17:15
Re: could not translate host name "istes.rds.amazonaws.com" to address: Temporary failure in name resolution Francisco Olarte 18:00
Re: BUG #16637: Postgressql throws exception 'relation already exists' when trying to execute partition from code Tom Lane 20:21

Sept. 27, 2020

Thread Author Time
recovery.conf' is not creating in pg_basebackup with version 13 Nagaraj Raj 03:42
Re: recovery.conf' is not creating in pg_basebackup with version 13 Jaime Casanova 03:46
BUG #16638: Some tables in the database cannot be opened PG Bug reporting form 06:53
Re: BUG #16638: Some tables in the database cannot be opened Tom Lane 15:06

Sept. 28, 2020

Thread Author Time
Re: BUG #16627: union all with partioned table yields random aggregate results 📎 David Rowley 07:12
BUG #16639: Syntax error in pgsql when executing local \copy instead of SQL copy PG Bug reporting form 13:25
Re: BUG #16639: Syntax error in pgsql when executing local \copy instead of SQL copy hubert depesz lubaczewski 13:46
BUG #16640: Documentation table formatting issue PG Bug reporting form 22:14

Sept. 29, 2020

Thread Author Time
Re: BUG #16622: pg_dump produces erroneus ALTER TABLE statement for a table with an inherited generated column 📎 Daniel Gustafsson 08:24
BUG #16641: Postgresql driver 42.2.15 and 42.2.16 has problems connecting to AWS RDS Postgresql database PG Bug reporting form 09:57
Re: BUG #16640: Documentation table formatting issue Daniel Gustafsson 10:26
Re: BUG #16622: pg_dump produces erroneus ALTER TABLE statement for a table with an inherited generated column Tom Lane 16:38
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 17:26
BUG #16642: INFORMATION_SCHEMA-DESIGN PG Bug reporting form 17:31
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 17:50
Re: table partition with inheritance having current_timestamp issue if we miss range table Nagaraj Raj 18:18
Re: BUG #16419: wrong parsing BC year in to_date() function 📎 Tom Lane 18:18
Re: recovery.conf' is not creating in pg_basebackup with version 13 Nagaraj Raj 18:22
Re: table partition with inheritance having current_timestamp issue if we miss range table Nagaraj Raj 18:24
BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop PG Bug reporting form 19:46
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Tom Lane 20:09
ERROR: insufficient columns in the PRIMARY KEY constraint definition Nagaraj Raj 21:36
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Nagaraj Raj 21:41
BUG #16644: null value for defaults in OLD variable for trigger PG Bug reporting form 21:50
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition David Rowley 22:05
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Tom Lane 22:22
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition David Rowley 22:29
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Tom Lane 22:37
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Alvaro Herrera 22:39
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Tom Lane 22:43
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition David Rowley 23:08
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition 📎 David Rowley 23:13
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Tom Lane 23:21
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition 📎 Alvaro Herrera 23:22
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition David Rowley 23:53

Sept. 30, 2020

Thread Author Time
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Tom Lane 00:06
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition David Rowley 00:12
Trigger function is not working as expected after migration from v9.6 to v11.7 Nagaraj Raj 00:45
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Nagaraj Raj 00:45
Re: table partition with inheritance having current_timestamp issue if we miss range table David Rowley 01:02
Re: Trigger function is not working as expected after migration from v9.6 to v11.7 David Rowley 01:05
BUG #16645: pg_upgrade does not mark template1 as a system database PG Bug reporting form 01:50
Re: BUG #16644: null value for defaults in OLD variable for trigger Tom Lane 02:21
Re: BUG #16645: pg_upgrade does not mark template1 as a system database Tom Lane 02:45
Re: BUG #16636: Upper case issue in JSONB type David G. Johnston 02:57
RE: BUG #16645: pg_upgrade does not mark template1 as a system database Y. NAKAGAWA 04:11
Incorrect version of initdb rob stone 06:01
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Henry Hinze 06:34
BUG #16646: systemctl stop postgresql-12 stuck PG Bug reporting form 06:42
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Michael Paquier 07:15
Re: Incorrect version of initdb Magnus Hagander 07:57
Re: table partition with inheritance having current_timestamp issue if we miss range table David Rowley 09:09
Too many waits on extension of relation. avinash varma 09:09
BUG #16647: ts_lexize with dict_voikko no longer works as of PostgreSQL 13.0 PG Bug reporting form 10:19
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Henry Hinze 10:44
Re: BUG #16647: ts_lexize with dict_voikko no longer works as of PostgreSQL 13.0 Heikki Linnakangas 11:40
Re: BUG #16647: ts_lexize with dict_voikko no longer works as of PostgreSQL 13.0 Matti Linnanvuori 12:06
Re: BUG #16640: Documentation table formatting issue hubert depesz lubaczewski 13:14
RE: [EXTERNAL] Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Godfrin, Philippe E 13:31
Re: [EXTERNAL] Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Tom Lane 14:16
BUG #16648: Using postgres:12.4-alpine docker image, get 12.2 when running postgres -V command inside container PG Bug reporting form 14:35
RE: [EXTERNAL] BUG #16648: Using postgres:12.4-alpine docker image, get 12.2 when running postgres -V command inside container Esmeraldo, Michael W. 15:13
Re: BUG #16644: null value for defaults in OLD variable for trigger Andrew Dunstan 17:02
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 17:56
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 18:11
Bugreport | Logical replication PostgreSQL 12 | Error after disable / enable replication Michael Weber 18:20
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 18:42
PostgreSQL 9.6 fails to install on Ubuntu Daniele Varrazzo 18:50
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 18:50
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 19:05
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 19:11
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 20:20
Re: BUG #16419: wrong parsing BC year in to_date() function Robert Haas 20:49
Assertion failure with 6-dimensional array in PL/python Heikki Linnakangas 21:06
Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition Alvaro Herrera 21:27
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Tom Lane 21:32
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 21:35
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Alvaro Herrera 21:42
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Tom Lane 21:52
Re: BUG #16419: wrong parsing BC year in to_date() function Robert Haas 22:10
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 22:36
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 22:36
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 23:26
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 23:41

Oct. 1, 2020

Thread Author Time
Re: BUG #16419: wrong parsing BC year in to_date() function Robert Haas 00:24
Re: BUG #16419: wrong parsing BC year in to_date() function David G. Johnston 00:38
Re: BUG #16419: wrong parsing BC year in to_date() function Tom Lane 00:40
Re: BUG #16636: Upper case issue in JSONB type ChandraKumar Ovanan 06:23
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Peter Eisentraut 17:22
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Peter Eisentraut 17:24
Re: BUG #16641: Postgresql driver 42.2.15 and 42.2.16 has problems connecting to AWS RDS Postgresql database Dave Cramer 23:04

Oct. 2, 2020

Thread Author Time
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop 📎 Alvaro Herrera 00:08
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop Tom Lane 01:19
Re: BUG #16641: Postgresql driver 42.2.15 and 42.2.16 has problems connecting to AWS RDS Postgresql database Flemming Rene Jønsson 05:22
BUG #16651: could rename global.tmp to global.stat due to permission denied PG Bug reporting form 09:10
Re: BUG #16519: SET SESSION ROLE in plpgsql requires string literal. 📎 David G. Johnston 20:11

Oct. 3, 2020

Thread Author Time
Unnecessary FOR UPDATE lock instead of possible FOR NO KEY UPDATE lock in an UPSERT statement lights go out 00:14
Re: BUG #16486: Prompted password is ignored when password specified in connection string Bruce Momjian 02:19
Adding partitions to the existing table in PostgreSQL Naveen Kumar 17:04
BUG #16652: SELECT pg_reload_conf(); returning true despite loading config has failed PG Bug reporting form 19:32
Re: BUG #16652: SELECT pg_reload_conf(); returning true despite loading config has failed David G. Johnston 20:02

Oct. 4, 2020

Thread Author Time
BUG #16653: Regression in CTE evaluation PG Bug reporting form 16:18
Re: BUG #16653: Regression in CTE evaluation Bruce Momjian 17:13
Re: BUG #16653: Regression in CTE evaluation Tom Lane 17:36
Re: BUG #16653: Regression in CTE evaluation Cherio 22:19

Oct. 5, 2020

Thread Author Time
Re: BUG #16620: Autovacuum does not process certain databases after migration from postgresql 10 Max Vikharev 09:23
BUG #16654: aarch64 can not install postgres12 because of file not exist PG Bug reporting form 10:51
BUG #16655: pg_dump segfault when excluding postgis table PG Bug reporting form 20:54
Re: BUG #16655: pg_dump segfault when excluding postgis table Tom Lane 22:31

Oct. 6, 2020

Thread Author Time
BUG #16656: Last update to PyGreSQL in Postgres repo drop python 2.7 support PG Bug reporting form 07:48
RE: BUG #16645: pg_upgrade does not mark template1 as a system database Y. NAKAGAWA 09:44
RE: [EXTERNAL] BUG #16655: pg_dump segfault when excluding postgis table Godfrin, Philippe E 12:48
Re: [EXTERNAL] BUG #16655: pg_dump segfault when excluding postgis table Cameron Daniel 13:37
Re: BUG #16645: pg_upgrade does not mark template1 as a system database Tom Lane 13:55
Re: Adding partitions to the existing table in PostgreSQL Stephen Frost 16:17
Re: BUG #16655: pg_dump segfault when excluding postgis table Stephen Frost 16:33
Re: BUG #16655: pg_dump segfault when excluding postgis table Tom Lane 17:01
Re: BUG #16655: pg_dump segfault when excluding postgis table 📎 Tom Lane 19:06
Re: BUG #16655: pg_dump segfault when excluding postgis table Tom Lane 21:26
BUG #16657: Index not reflecting update when date to timestamp comparison operation used in index scan PG Bug reporting form 22:22
BUG #16658: HSTORE typecast exception is XX000 - inconsistent with the other cast exceptions (22xxx) PG Bug reporting form 23:45

Oct. 7, 2020

Thread Author Time
Re: BUG #16655: pg_dump segfault when excluding postgis table Tom Lane 01:04
Re: BUG #16657: Index not reflecting update when date to timestamp comparison operation used in index scan Tom Lane 01:31
Re: BUG #16655: pg_dump segfault when excluding postgis table Stephen Frost 02:08
BUG #16659: postgresql leaks memory or do not limit its usage PG Bug reporting form 12:28
BUG #16660: 64-bit build fails when run on a subst drive PG Bug reporting form 16:08
Re: BUG #16655: pg_dump segfault when excluding postgis table Tom Lane 16:56
Re: BUG #16659: postgresql leaks memory or do not limit its usage Tom Lane 17:06
Re: BUG #15858: could not stat file - over 4GB Emil Iggland 19:13

Oct. 8, 2020

Thread Author Time
WIDTH_BUCKET inconsistency Martin Visser 10:57
BUG #16661: Changing columns after the rule is created leads to an error when the RETURNING is used PG Bug reporting form 12:26
Re: WIDTH_BUCKET inconsistency Tom Lane 15:14
Re: WIDTH_BUCKET inconsistency Tom Lane 15:28
BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830 PG Bug reporting form 15:49
Re: BUG #16661: Changing columns after the rule is created leads to an error when the RETURNING is used Tom Lane 17:30

Oct. 9, 2020

Thread Author Time
Re: BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830 Michael Paquier 00:32
Re: BUG #16662: pgbench: error: client 418 script 0 aborted in command 5 query 0: ERROR: invalid page in block 4830 两个孩子的爹 01:53
BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted PG Bug reporting form 13:24
BUG #16664: Problem running django PG Bug reporting form 16:51
Re: BUG #16664: Problem running django David G. Johnston 17:04
Re: BUG #16664: Problem running django Francisco Olarte 17:05
Re: BUG #15858: could not stat file - over 4GB Tom Lane 20:22

Oct. 10, 2020

Thread Author Time
BUG #16665: Segmentation fault PG Bug reporting form 02:38
Re: BUG #16665: Segmentation fault Pavel Stehule 09:04
Re: BUG #16665: Segmentation fault Raphael Megzari 11:19
Re: BUG #16665: Segmentation fault Pavel Stehule 11:23
Re: BUG #16665: Segmentation fault Pavel Stehule 11:25
Re: BUG #16665: Segmentation fault Raphael Megzari 11:27
Re: BUG #15858: could not stat file - over 4GB 📎 Juan José Santamaría Flecha 11:31
Re: BUG #16665: Segmentation fault Pavel Stehule 11:55
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 12:23
Re: BUG #15858: could not stat file - over 4GB Juan José Santamaría Flecha 14:29
Re: BUG #16665: Segmentation fault Raphael Megzari 14:50
Re: BUG #16665: Segmentation fault Pavel Stehule 14:56
Re: BUG #15858: could not stat file - over 4GB Tom Lane 17:42
Re: BUG #15858: could not stat file - over 4GB Juan José Santamaría Flecha 19:00
Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop 📎 Alvaro Herrera 19:06

Oct. 11, 2020

Thread Author Time
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 00:24
Re: BUG #15858: could not stat file - over 4GB Tom Lane 00:34
Re: BUG #16665: Segmentation fault Raphael Megzari 01:13
Re: BUG #16665: Segmentation fault Pavel Stehule 05:36
Re: BUG #16665: Segmentation fault Raphael Megzari 06:54
Re: BUG #16665: Segmentation fault Pavel Stehule 07:13

Oct. 12, 2020

Thread Author Time
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 01:01
Re: BUG #15858: could not stat file - over 4GB Tom Lane 03:27
Identity column behavior discrepancies when inserting one or many rows Jean Prulière 10:05
Re: BUG #16329: Valgrind detects an invalid read when building a gist index with buffering 📎 Pavel Borisov 12:30
Re: BUG #15858: could not stat file - over 4GB Juan José Santamaría Flecha 12:33
BUG #16666: Slight memory leak when running pg_ctl reload PG Bug reporting form 13:32
BUG #16667: COMMIT AND CHAIN does not udpates database metrics ie. xact_commit PG Bug reporting form 13:55
Re: BUG #16666: Slight memory leak when running pg_ctl reload Bruce Momjian 14:19
Re: BUG #16666: Slight memory leak when running pg_ctl reload Tom Lane 14:42
Re: BUG #15858: could not stat file - over 4GB Tom Lane 15:13
Re: BUG #16667: COMMIT AND CHAIN does not udpates database metrics ie. xact_commit Tom Lane 15:21

Browse Archives

Prev | Next