Mailing lists [pgsql-bugs]

1 May 2020

• 17:38   BUG #16407: Column mismatch PG Bug reporting form
• 19:34   Re: BUG #16407: Column mismatch David G. Johnston
• 23:27   BUG #16408: We are facing issue while taking the backup using pgbackrest 2.22 version PG Bug reporting form

2 May 2020

• 00:21   Re: BUG #16408: We are facing issue while taking the backup usingpgbackrest 2.22 version David Steele
• 02:55   BUG #16409: 404 Error link PG Bug reporting form
• 07:45   Re: BUG #16329: Valgrind detects an invalid read when building a gistindex with buffering Alexander Lakhin
• 12:22   BUG #16410: initialisation cluster base donnée à échouée PG Bug reporting form
• 16:19   BUG #16411: Problem while running postgre sql on my Laptop PG Bug reporting form
• 19:56   Re: BUG #16411: Problem while running postgre sql on my Laptop David G. Johnston

3 May 2020

• 05:12   BUG #16412: Make postgres rpm repository and packages compatible with new modular package system PG Bug reporting form
• 09:18   Re: BUG #16410: initialisation cluster base donnée à échouée Fabien COELHO
• 09:59   Re: BUG #16410: initialisation cluster base donnée à échouée Michael Paquier

4 May 2020

• 04:59   BUG #16413: Broken Dependency pgadmin4-web to pgadmin4-python3-psutil PG Bug reporting form
• 06:17   BUG #16414: Backend process blocked for 120s until kernel killed it PG Bug reporting form
• 10:26   VS: BUG #16404: PostgreSQL 12.2: Database restore does not accept theEEST time zone. Suhonen Reijo (Valtori)
• 18:08   BUG #16415: Postgres 11.6 CentOS docker image needs a repo update PG Bug reporting form
• 18:22   Re: BUG #16415: Postgres 11.6 CentOS docker image needs a repo update Stephen Frost
• 18:24   Re: VS: BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone. Tom Lane
• 19:14   Re: BUG #16393: PANIC: cannot abort transaction, it was alreadycommitted Andres Freund

5 May 2020

• 09:28   BUG #16416: unable to start the server with pg_CTL PG Bug reporting form
• 10:25   BUG #16417: Unable to connect to server PG Bug reporting form
• 11:37   Re: BUG #16416: unable to start the server with pg_CTL Daniel Gustafsson
• 21:59   Re: BUG #16329: Valgrind detects an invalid read when building a gist index with buffering Tom Lane
• 23:44   Re: BUG #16393: PANIC: cannot abort transaction, it was already committed Andreas Seltenreich

6 May 2020

• 03:20   Clarity Bug for Schema Permissions, Potential Vulnerability? Justis Lincoln Mackaoui
• 10:45   Re: BUG #16416: unable to start the server with pg_CTL Sandeep Thakkar
• 10:46   Re: Clarity Bug for Schema Permissions, Potential Vulnerability? Oleksandr Shulgin
• 11:02   Re: BUG #16398: Installation process fails if StackBuilder is selected. Fahar Abbas
• 11:05   Re: BUG #16384: having trouble while installation Fahar Abbas
• 12:30   BUG #16418: postgis23_96 dependency proj49 missing now pgdg94 default to disabled PG Bug reporting form
• 16:13   Re: Clarity Bug for Schema Permissions, Potential Vulnerability? David G. Johnston
• 16:37   Re: Clarity Bug for Schema Permissions, Potential Vulnerability? Jeff Janes
• 17:05   Re: Clarity Bug for Schema Permissions, Potential Vulnerability? David G. Johnston

7 May 2020

• 00:26   BUG #16419: wrong parsing BC year in to_date() function PG Bug reporting form
• 01:45   Re: BUG #16419: wrong parsing BC year in to_date() function David G. Johnston
• 03:59   رد: BUG #16419: wrong parsing BC year in to_date() function دار الآثار للنشر والتوزيع-صنعاء Dar Alathar-Yemen
• 06:12   Re: BUG #16419: wrong parsing BC year in to_date() function David G. Johnston
• 08:05   Re: BUG #16419: wrong parsing BC year in to_date() function David G. Johnston
• 11:58   BUG #16420: problem running into post install step while installation. PG Bug reporting form
• 12:28   Re: BUG #16420: problem running into post install step while installation. Fahar Abbas
• 13:23   رد: BUG #16419: wrong parsing BC year in to_date() function دار الآثار للنشر والتوزيع-صنعاء Dar Alathar-Yemen
• 14:17   BUG #16421: Table Rapid Growth due to tuple accumulation PG Bug reporting form
• 14:48   رد: BUG #16419: wrong parsing BC year in to_date() function دار الآثار للنشر والتوزيع-صنعاء Dar Alathar-Yemen
• 16:58   BUG #16422: psqlodbc PG Bug reporting form
• 18:35   Re: BUG #16420: problem running into post install step while installation. Euler Taveira

8 May 2020

• 03:35   BUG #16423: Sequential Scan on query after reindex was done PG Bug reporting form
• 10:13   a bug for shm_mq bucoo@sohu.com
• 10:42   BUG #16424: COPY Command fails for CSV formath PG Bug reporting form
• 13:18   pg_dump Volodymyr Blahoi
• 17:08   Re: pg_dump David G. Johnston
• 17:17   Re: pg_dump Fabio Pardi
• 17:17   Re: BUG #16424: COPY Command fails for CSV formath David G. Johnston
• 18:25   BUG #16425: Possible error in full join PG Bug reporting form
• 19:17   Re: BUG #16425: Possible error in full join Jeff Janes

9 May 2020

• 05:33   Postgredb issue Thusitha Maheepala
• 15:44   BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed PG Bug reporting form
• 17:24   Re: BUG #16426: In active/hot standby mode, create database and droptemplate databases cause standby restart failed Euler Taveira
• 17:38   Re: Postgredb issue David G. Johnston
• 18:05   Re: Postgredb issue Rod Taylor
• 18:09   Re: Postgredb issue Rod Taylor
• 18:10   Re: BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed Tom Lane
• 18:38   Re: Postgredb issue Thusitha Maheepala
• 18:49   Re: Postgredb issue Tom Lane

10 May 2020

• 03:44   BUG #16427: pgsql_tmp - temp files not released PG Bug reporting form
• 15:32   Re: BUG #16427: pgsql_tmp - temp files not released Tomas Vondra
• 16:48   Re: BUG #16427: pgsql_tmp - temp files not released Euler Taveira

11 May 2020

• 06:04   BUG #16428: pg_ctl unusable after standard install PG Bug reporting form
• 08:37   Re: BUG #16420: problem running into post install step while installation. Fahar Abbas
• 09:10   Re: BUG #16427: pgsql_tmp - temp files not released Michael Paquier
• 13:48   BUG #16429: PgAdmin4 is installed but not able to connect to the Azure Database for Postgres PG Bug reporting form
• 23:00   Re: BUG #16329: Valgrind detects an invalid read when building a gistindex with buffering Alexander Lakhin

12 May 2020

• 08:00   Re: BUG #16329: Valgrind detects an invalid read when building a gistindex with buffering Alexander Lakhin
• 15:28   Substring expression fails on single character input Per-Åke Ling
• 17:10   Re: Substring expression fails on single character input Tom Lane
• 17:47   BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache PG Bug reporting form
• 18:42   Re: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache Tom Lane
• 18:44   Re: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache Sergei Kornilov
• 18:47   Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache David G. Johnston

13 May 2020

• 01:15   Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache Jeff Janes
• 01:56   RE: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache 
• 05:37   BUG #16431: Trigger not allowing new data insert PG Bug reporting form
• 12:28   BUG #16432: ECCN code for PGAdmin 3 and 4 PG Bug reporting form
• 13:06   BUG #16433: Information disclosure via log file PG Bug reporting form
• 13:43   Re: BUG #16432: ECCN code for PGAdmin 3 and 4 Magnus Hagander
• 13:45   Re: BUG #16433: Information disclosure via log file Magnus Hagander
• 18:07   BUG #16434: some data lost PG Bug reporting form
• 21:20   BUG #16435: regexp_split_to_table different behavior in 9.2 and 12.2 PG Bug reporting form

14 May 2020

• 00:17   Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and 12.2 David G. Johnston
• 08:38   BUG #16436: Functions with input parameter table type failing from application PG Bug reporting form
• 11:13   Re:BUG #16434: some data lost Konstantin Davydenka
• 13:31   Multi-parent inherited table with mixed storage options cannot berestored Heikki Linnakangas
• 14:12   Re: BUG #16436: Functions with input parameter table type failingfrom application Pavel Stehule
• 16:19   Re: Re:BUG #16434: some data lost Tom Lane
• 19:21   BUG #16437: The dump is stored with error in creating VIEW statement. PG Bug reporting form
• 20:18   Re: BUG #16437: The dump is stored with error in creating VIEW statement. Tom Lane
• 22:23   Re: BUG #16437: The dump is stored with error in creating VIEW statement. Tom Lane

15 May 2020

• 05:35   BUG #16438: Installation failure at the end when Use Unicode UTF-8 worldwide language support. PG Bug reporting form
• 05:54   Re: Multi-parent inherited table with mixed storage options cannot be restored Amit Langote
• 06:36   attached TAP test is hanging Mahendra Singh Thalor
• 07:22   Re: Multi-parent inherited table with mixed storage options cannotbe restored Kyotaro Horiguchi
• 10:47   BUG #16439: can not read table info for greenplum 6 PG Bug reporting form
• 12:52   Re: attached TAP test is hanging Peter Eisentraut
• 13:49   Re: BUG #16439: can not read table info for greenplum 6 Magnus Hagander
• 15:56   Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and12.2 prashant rokad
• 16:53   Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -hlocalhost --jobs=2 crashes David Gilman
• 19:46   BUG #16440: pg_basebackup intermittently hangs waiting for input unless run with --checkpoint=fast option PG Bug reporting form
• 20:51   Re: BUG #16440: pg_basebackup intermittently hangs waiting for inputunless run with --checkpoint=fast option Magnus Hagander
• 21:39   Re: BUG #16440: pg_basebackup intermittently hangs waiting for inputunless run with --checkpoint=fast option Curt Kolovson
• 21:47   Re: BUG #16440: pg_basebackup intermittently hangs waiting for inputunless run with --checkpoint=fast option Curt Kolovson

16 May 2020

• 00:07   BUG #16441: Cannot multi-insert into generated column with DEFAULT value PG Bug reporting form
• 01:32   BUG #16442: terraform provider postgresql 9.0.0/9.4/12.3/current/latest fail PG Bug reporting form
• 04:20   Re: BUG #16439: can not read table info for greenplum 6 Michael Paquier
• 05:17   Re: BUG #16442: terraform provider postgresql 9.0.0/9.4/12.3/current/latestfail David G. Johnston

17 May 2020

• 17:42   BUG #16443: Too much memory usage on insert query PG Bug reporting form
• 17:54   BUG #16444: Vacuum writes the table twice PG Bug reporting form
• 18:32   Re: BUG #16443: Too much memory usage on insert query Kurt Roeckx
• 18:40   Re: BUG #16443: Too much memory usage on insert query Tom Lane
• 19:01   Re: BUG #16443: Too much memory usage on insert query Kurt Roeckx

18 May 2020

• 10:35   BUG #16446: ERROR: virtual tuple table slot does not have system attributes on insert to partitioned table PG Bug reporting form
• 11:34   Re: BUG #16428: pg_ctl unusable after standard install Sandeep Thakkar
• 12:11   BUG #16447: The query field of the pg_stat_activity table displays the clear text of the password. PG Bug reporting form
• 12:14   BUG #16448: Remote code execution vulnerability PG Bug reporting form
• 12:16   BUG #16449: Log file and the query field of the pg_stat_statements table display clear text password. PG Bug reporting form
• 12:17   BUG #16450: Recovery.conf file shows clear text password. PG Bug reporting form
• 12:17   BUG #16451: .psql_history file shows clear text password. PG Bug reporting form
• 12:43   Re: BUG #16447: The query field of the pg_stat_activity tabledisplays the clear text of the password. Magnus Hagander
• 12:45   Re: BUG #16449: Log file and the query field of thepg_stat_statements table display clear text password. Magnus Hagander
• 12:46   Re: BUG #16451: .psql_history file shows clear text password. Magnus Hagander
• 12:47   Re: BUG #16450: Recovery.conf file shows clear text password. Magnus Hagander
• 12:49   Re: BUG #16448: Remote code execution vulnerability Heikki Linnakangas
• 17:22   Re: BUG #16448: Remote code execution vulnerability David G. Johnston
• 17:57   Re: BUG #16441: Cannot multi-insert into generated column withDEFAULT value Peter Eisentraut
• 18:08   Re: BUG #16283: crash on create index segmentation fault Arthur Cheysson
• 18:10   Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value Colin Darie
• 19:22   Re: BUG #16283: crash on create index segmentation fault Tom Lane

19 May 2020

• 09:22   Re: BUG #16449: Log file and the query field of thepg_stat_statements table display clear text password. Oleksandr Shulgin
• 10:02   Re: BUG #16449: Log file and the query field of thepg_stat_statements table display clear text password. Michael Paquier
• 11:19   Re: [bug] Table not have typarray when created by single user mode wenjing zeng
• 11:49   BUG #16452: pgp_sym_encrypt_bytea with compress-level=6 : Wrong key or corrupt data PG Bug reporting form
• 12:40   Re: [bug] Table not have typarray when created by single user mode shawn wang
• 16:20   BUG #16453: Not able to load a 10gb file. PG Bug reporting form
• 17:14   Re: BUG #16453: Not able to load a 10gb file. Daniel Gustafsson
• 17:22   Re: BUG #16453: Not able to load a 10gb file. Juan José Santamaría Flecha
• 18:32   Re: [bug] Table not have typarray when created by single user mode Alvaro Herrera
• 19:09   Re: [bug] Table not have typarray when created by single user mode Tom Lane

20 May 2020

• 03:52   Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -hlocalhost --jobs=2 crashes David Gilman
• 11:15   Re: [bug] Table not have typarray when created by single user mode shawn wang
• 15:05   Re: BUG #16343: Build problem: Install.pm "Could not find debug orrelease binaries" Daniel Gustafsson
• 15:58   time values past 24:00:00 (or rather 23:59:60) Christoph Berg
• 17:43   Re: Re : Re: BUG #16441: Cannot multi-insert into generated columnwith DEFAULT value Peter Eisentraut

21 May 2020

• 00:24   Unique constraint error instead of serialization_failure Benny Kramek
• 03:52   BUG #16454: Mixed isolation levels inside transactions PG Bug reporting form
• 04:46   Re: Unique constraint error instead of serialization_failure Thomas Munro
• 04:56   Re: BUG #16454: Mixed isolation levels inside transactions Thomas Munro
• 05:14   Re: BUG #16454: Mixed isolation levels inside transactions Tom Lane
• 05:51   RE: BUG #16454: Mixed isolation levels inside transactions Albin, Lloyd P
• 07:00   Re: BUG #16454: Mixed isolation levels inside transactions Tom Lane
• 08:47   Re: BUG #16343: Build problem: Install.pm "Could not find debug orrelease binaries" Michael Paquier
• 08:53   Re: time values past 24:00:00 (or rather 23:59:60) Tom Lane
• 10:28   Re: [bug] Table not have typarray when created by single user mode wenjing zeng
• 14:37   Re: [bug] Table not have typarray when created by single user mode Amit Kapila
• 14:39   BUG #16455: Broken RPMs python-ldap2pg postgresql11-devel PG Bug reporting form
• 20:01   Re: BUG #16283: crash on create index segmentation fault Arthur Cheysson

22 May 2020

• 02:45   Re: Unique constraint error instead of serialization_failure Thomas Munro
• 15:50   error Ruslana Akyk

23 May 2020

• 00:08   Re: planner weirdness: a join uses nestloop with checking conditionwhen there are two subplan-or-hashed subqueries Alexey Bashtanov
• 17:21   BUG #16456: Implicit unsigned integer truncation at multixact.c:2626 PG Bug reporting form

24 May 2020

• 18:43   BUG #16457: Implicit signed integer truncation or sign change at sortsupport.c:60 PG Bug reporting form

25 May 2020

• 03:02   BUG #16458: pg_restore lists data in corrupted backup files without checking if data exists PG Bug reporting form
• 06:37   Re: [bug] Table not have typarray when created by single user mode shawn wang
• 07:58   Re: BUG #16456: Implicit unsigned integer truncation atmultixact.c:2626 Kyotaro Horiguchi
• 11:39   BUG #16459: YUM pgdg11-updates-debuginfo repository missing repodata/repomd.xml for RHEL8* PG Bug reporting form
• 18:43   BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA; PG Bug reporting form
• 22:54   BUG #16461: Segfault in autovacuum process PG Bug reporting form
• 23:35   Re: logical replication: could not create file "state.tmp": Fileexists Alvaro Herrera

26 May 2020

• 03:19   Re: BUG #16380: documentation: host[no]gssenc vs.address/IP-address/IP-mask fields Bruce Momjian
• 03:38   Re: BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITHDATA; Michael Paquier
• 04:26   Re: BUG #16380: documentation: host[no]gssenc vs.address/IP-address/IP-mask fields Justin Pryzby
• 04:41   Re: logical replication: could not create file "state.tmp": Fileexists Michael Paquier
• 05:07   Re: BUG #16380: documentation: host[no]gssenc vs.address/IP-address/IP-mask fields Bruce Momjian
• 12:49   ... Andrey Klychkov
• 13:21   Re: BUG #16461: Segfault in autovacuum process David Rowley
• 13:44   Re: Peter Eisentraut
• 14:28   BUG #16462: Update Statement destructive behaviour with joins PG Bug reporting form
• 15:48   Re: BUG #16462: Update Statement destructive behaviour with joins David Rowley
• 16:18   BUG #16463: Sporadic SSL handshake failures in Windows client PG Bug reporting form
• 16:53   Re[2]:  Andrey Klychkov
• 16:55   Re: BUG #16463: Sporadic SSL handshake failures in Windows client Tom Lane
• 17:50   Re: Re[2]:  Tom Lane
• 20:00   BUG #16464: Unable to restore database backed up with pg_dump into sql that contains expression based index PG Bug reporting form
• 20:53   Re: BUG #16464: Unable to restore database backed up with pg_dumpinto sql that contains expression based index David G. Johnston

27 May 2020

• 07:33   RE: error Tulegen Nuryshov
• 10:48   Re: Re[2]:  Michael Paquier
• 11:00   BUG #16465: Inconsistent results from comparison of row value expressions PG Bug reporting form
• 11:00   Re: error Daniel Gustafsson
• 12:14   Re: BUG #16465: Inconsistent results from comparison of row valueexpressions Vik Fearing
• 15:10   Re[4]:  Andrey Klychkov
• 15:16   Re: BUG #16465: Inconsistent results from comparison of row value expressions Tom Lane
• 15:18   Re: Re[2]: Tom Lane
• 18:23   Explicit deterministic COLLATE fails with pattern matching operationson column with non-deterministic collation James Lucas
• 18:53   Re: Explicit deterministic COLLATE fails with pattern matchingoperations on column with non-deterministic collation David G. Johnston
• 19:19   Re: Explicit deterministic COLLATE fails with pattern matchingoperations on column with non-deterministic collation James Lucas
• 21:00   BUG #16466: Valgrind detects an invalid read in dblink_open() with a cursor inside a transaction PG Bug reporting form
• 22:58   Re: BUG #16466: Valgrind detects an invalid read in dblink_open()with a cursor inside a transaction Joe Conway

28 May 2020

• 00:00   Re: BUG #16466: Valgrind detects an invalid read in dblink_open()with a cursor inside a transaction Alexander Lakhin
• 01:09   BUG #16467: XX000 fun PG Bug reporting form
• 03:21   Re: Explicit deterministic COLLATE fails with pattern matching operations on column with non-deterministic collation Tom Lane
• 08:37   Re: BUG #16467: XX000 fun Kyotaro Horiguchi
• 09:39   BUG #16468: Doc: release note 13, missing GUC enable_groupingsets_hash_disk PG Bug reporting form
• 09:55   Re:  Michael Paquier
• 09:59   Re: Re[2]: Michael Paquier
• 10:12   Re: BUG #16468: Doc: release note 13, missing GUCenable_groupingsets_hash_disk Michael Paquier
• 16:14   Re: Re[2]: Tom Lane
• 18:30   pgbench bug / limitation Jawarilal, Manish
• 20:31   Re: pgbench bug / limitation Tom Lane
• 20:50   Re: BUG #16466: Valgrind detects an invalid read in dblink_open()with a cursor inside a transaction Joe Conway
• 21:04   Re: Explicit deterministic COLLATE fails with pattern matchingoperations on column with non-deterministic collation James Lucas
• 21:29   Re: Explicit deterministic COLLATE fails with pattern matching operations on column with non-deterministic collation Tom Lane
• 21:48   Re: Explicit deterministic COLLATE fails with pattern matchingoperations on column with non-deterministic collation Daniel Verite
• 23:42   Re: Explicit deterministic COLLATE fails with pattern matchingoperations on column with non-deterministic collation James Lucas
• 23:48   Re: Explicit deterministic COLLATE fails with pattern matching operations on column with non-deterministic collation Tom Lane

29 May 2020

• 03:50   BUG #16469: High unicode character mangled on write and read with ODBC driver PG Bug reporting form
• 07:23   RE: pgbench bug / limitation Jawarilal, Manish
• 08:29   Re: Re[2]: Michael Paquier
• 16:17   Re: Re[2]: Tom Lane
• 17:45   Re: pgbench bug / limitation Tom Lane
• 18:19   BUG #16471: Unable to install postgis30_12 PG Bug reporting form

31 May 2020

• 04:51   Re: Re[2]: Michael Paquier