Mailing lists [pgsql-bugs]

1 September 2021

• 05:25   BUG #17172: NaN compare error in hash agg PG Bug reporting form
• 12:21   BUG #17173: Primary Key ignored resulting in duplicate values PG Bug reporting form
• 14:17   BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 PG Bug reporting form
• 16:28   Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston
• 16:33   Re: BUG #17173: Primary Key ignored resulting in duplicate values David G. Johnston
• 16:46   RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya
• 16:46   Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston
• 16:54   RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya
• 17:02   Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston
• 18:40   Re: BUG #17172: NaN compare error in hash agg Tom Lane
• 18:59   BUG #17175: The aarch64 repo is missing repomd.xml.asc metadata file, fails GPG verification PG Bug reporting form
• 19:11   The order of postgresql.conf parameters is potentially confusing. Very minor cosmetic bug or "niggle"! Pól Ua Laoínecháin
• 19:35   Re: The order of postgresql.conf parameters is potentially confusing. Very minor cosmetic bug or "niggle"! David G. Johnston
• 19:39   Re: The order of postgresql.conf parameters is potentially confusing. Very minor cosmetic bug or "niggle"! Tom Lane
• 20:19   Re: Unexpected behavior from using default config value Euler Taveira
• 22:00   Re: Unexpected behavior from using default config value Tom Lane

2 September 2021

• 07:00   Re: BUG #17126: Server crashes on dropping user while enumerating owned objects that are droppped concurrently Alexander Lakhin
• 11:15   Re: BUG #17158: Distinct ROW fails with Postgres 14 Peter Eisentraut
• 13:54   BUG #17176: Error raised on valid query PG Bug reporting form
• 21:52   Re: BUG #17176: Error raised on valid query Tom Lane

3 September 2021

• 00:28   Re: BUG #17172: NaN compare error in hash agg Tom Lane
• 03:31   BUG #17177: Secondary fails to start after upgrade from 13.3 PG Bug reporting form
• 07:56   BUG #17178: probes.h: No such file or directory when running 'make install' PG Bug reporting form
• 08:01   Re: BUG #17178: probes.h: No such file or directory when running 'make install' Kevin Burke
• 08:47   BUG #17179: EOF detected PG Bug reporting form
• 14:34   Re: BUG #17177: Secondary fails to start after upgrade from 13.3 Kyotaro Horiguchi
• 16:23   Re: BUG #17178: probes.h: No such file or directory when running 'make install' Tom Lane
• 16:34   Re: BUG #17179: EOF detected Tom Lane
• 17:26   Re: BUG #17178: probes.h: No such file or directory when running 'make install' Kevin Burke
• 21:53   Re: BUG #17177: Secondary fails to start after upgrade from 13.3 Andriy Bartash
• 23:36   BUG #17181: pg_cancel_backend and pg_terminate_backend fail to work PG Bug reporting form

4 September 2021

• 09:00   BUG #17182: Race condition on concurrent DROP and CREATE of dependent object PG Bug reporting form

5 September 2021

• 14:28   Logs vanish after partial log destination change hubert depesz lubaczewski
• 17:15   Re: BUG #17182: Race condition on concurrent DROP and CREATE of dependent object Tom Lane
• 17:24   Re: Logs vanish after partial log destination change Tom Lane

6 September 2021

• 10:57   Re: Logs vanish after partial log destination change hubert depesz lubaczewski
• 11:18   Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows Pawel Kudzia

7 September 2021

• 14:34   Re: Unexpected behavior from using default config value Yongqian Li

8 September 2021

• 05:08   BUG #17183: missing websearch_to_tsquery PG Bug reporting form
• 09:45   Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data Noah Misch
• 10:21   BUG #17184: When using openssl, the memory of a static variable is not freed in libpq PG Bug reporting form
• 10:26   Re: BUG #17183: missing websearch_to_tsquery Julien Rouhaud
• 12:27   Re: BUG #17158: Distinct ROW fails with Postgres 14 Peter Eisentraut
• 16:11   BUG #17185: PostgreSQL performance GNU vs LLVM PG Bug reporting form
• 16:35   Re: BUG #17184: When using openssl, the memory of a static variable is not freed in libpq Tom Lane
• 16:46   Technical Support Murphy, Kimberly R CTR TRANSCOM TCJ6 (USA)"
• 21:27   Re: Technical Support Daniel Gustafsson

9 September 2021

• 00:45   Duplicate comment on a table ldh@laurent-hasson.com
• 01:23   Re: Duplicate comment on a table David G. Johnston
• 07:08   Re: Technical Support Semab Tariq
• 08:32   Re: BUG #17184: When using openssl, the memory of a static variable is not freed in libpq Alexander Dzuba
• 15:50   Segmentation fault on postgresql 13.4, 12.8 with function call in a cursor Tomas Barton
• 19:08   Re: Segmentation fault on postgresql 13.4, 12.8 with function call in a cursor Sergei Kornilov
• 19:14   Re: Segmentation fault on postgresql 13.4, 12.8 with function call in a cursor Tom Lane

10 September 2021

• 05:12   Re: BUG #17184: When using openssl, the memory of a static variable is not freed in libpq Michael Paquier
• 07:29   BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522) PG Bug reporting form
• 10:07   Re: BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522) Michael Paquier
• 11:57   BUG #17187: Incorrect field update operation? PG Bug reporting form
• 13:05   BUG #17188: Multiple rows are present with same values on a unique column PG Bug reporting form
• 13:07   Re: BUG #17188: Multiple rows are present with same values on a unique column Ashish Kumar
• 14:06   Re: BUG #17183: missing websearch_to_tsquery Julien Rouhaud
• 14:47   Re: BUG #17188: Multiple rows are present with same values on a unique column Julien Rouhaud
• 16:02   Re: PG12 → PG13 database conversion anomaly: ERROR: function kepler_start_3(double precision, double precision) does not exist David G. Johnston
• 22:27   Re: BUG #17158: Distinct ROW fails with Postgres 14 Tom Lane

11 September 2021

• 08:38   Re: BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522) Michael Paquier
• 12:00   Re: BUG #17182: Race condition on concurrent DROP and CREATE of dependent object Alexander Lakhin

13 September 2021

• 05:59   Re: BUG #17184: When using openssl, the memory of a static variable is not freed in libpq Kyotaro Horiguchi
• 07:37   Re: BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522) Michael Paquier
• 08:27   BUG #17189: Index not created when primary key created PG Bug reporting form
• 08:32   BUG #17190: lock contention high in postgreSQL13.3 wrt GCC/llvm PG Bug reporting form
• 12:24   Re: BUG #17189: Index not created when primary key created Pavel Stehule
• 13:36   Re: BUG #17189: Index not created when primary key created hubert depesz lubaczewski
• 15:27   BUG #17191: Docker / buildx issue - An image created with buildx requires to set custom PGDATA location PG Bug reporting form
• 15:56   Re: BUG #17189: Index not created when primary key created David G. Johnston
• 16:59   Re: BUG #17185: PostgreSQL performance GNU vs LLVM arjun shetty
• 17:06   Re: BUG #17191: Docker / buildx issue - An image created with buildx requires to set custom PGDATA location Euler Taveira
• 17:13   Re: BUG #17185: PostgreSQL performance GNU vs LLVM Euler Taveira

14 September 2021

• 06:03   [BUG] Deadlock detected when update with multiple clients tanghy.fnst@fujitsu.com
• 10:00   Re: [BUG] Deadlock detected when update with multiple clients hubert depesz lubaczewski
• 12:47   BUG #17192: The csvlog is corrupted PG Bug reporting form
• 16:44   BUG #17193: Issue with pg_output login PG Bug reporting form
• 17:39   Re: BUG #17158: Distinct ROW fails with Postgres 14 Peter Eisentraut
• 18:02   Re: BUG #17158: Distinct ROW fails with Postgres 14 Tom Lane

15 September 2021

• 09:28   bugs or my fault Yudianto Prasetyo
• 09:30   Re: bugs or my fault Yudianto Prasetyo
• 13:16   Re: bugs or my fault Peter Smith
• 13:26   Re: BUG #17158: Distinct ROW fails with Postgres 14 Peter Eisentraut
• 13:38   Re: bugs or my fault Yudianto Prasetyo
• 15:36   Re: bugs or my fault Sergei Kornilov
• 15:44   Re: bugs or my fault Yudianto Prasetyo
• 16:38   Re: bugs or my fault Sergei Kornilov
• 17:16   Re: bugs or my fault Yudianto Prasetyo
• 17:41   RE: BUG #17192: The csvlog is corrupted Jef Vervecken
• 21:46   Re: BUG #17193: Issue with pg_output login Euler Taveira
• 21:53   Re: BUG #17193: Issue with pg_output login Sushant Kamboj

16 September 2021

• 15:36   Re: BUG #17193: Issue with pg_output login Sushant Kamboj

17 September 2021

• 12:49   Query planning on partitioned table causes postgres 13.4 to consume all memory Duncan Sands
• 14:13   Re: BUG #17070: Sometimes copy from ingnores transaction Дмитрий Секретов
• 15:17   BUG #17194: Issue with pgoutput PG Bug reporting form

18 September 2021

• 06:18   Re: BUG #17070: Sometimes copy from ingnores transaction Noah Misch

19 September 2021

• 01:20   Re: BUG #17061: Impossible to query the fields of the tuple created by SEARCH BREADTH FIRST BY .. SET .. Jaime Casanova
• 12:17   BUG #17195: Can't bind $1::int param when I use COPY TO STDOUT statement - libpq, C++ PG Bug reporting form
• 17:20   Re: BUG #17061: Impossible to query the fields of the tuple created by SEARCH BREADTH FIRST BY .. SET .. Tom Lane
• 18:04   Re: BUG #17194: Issue with pgoutput Tom Lane
• 18:08   Re: BUG #17195: Can't bind $1::int param when I use COPY TO STDOUT statement - libpq, C++ Tom Lane
• 19:03   Re: Query planning on partitioned table causes postgres 13.4 to consume all memory Tom Lane

20 September 2021

• 07:41   Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data Noah Misch
• 09:14   BUG #17196: old_snapshot_threshold is not honored if there is a transaction PG Bug reporting form
• 15:10   Re: Query planning on partitioned table causes postgres 13.4 to consume all memory Duncan Sands
• 22:00   BUG #17197: Assert failed on inserting index tuples after VACUUM PG Bug reporting form
• 23:35   Re: BUG #17197: Assert failed on inserting index tuples after VACUUM Peter Geoghegan

21 September 2021

• 00:03   Re: BUG #17197: Assert failed on inserting index tuples after VACUUM Peter Geoghegan
• 03:18   BUG #17198: Planning time too high when execute query on standby cluster PG Bug reporting form
• 08:00   Re: BUG #17197: Assert failed on inserting index tuples after VACUUM Alexander Lakhin
• 09:04   Re: BUG #17189: Index not created when primary key created Puneet Sharma
• 09:55   Re: BUG #17198: Planning time too high when execute query on standby cluster Magnus Hagander
• 11:23   Re: BUG #17189: Index not created when primary key created Jaime Casanova
• 13:49   Re: BUG #17189: Index not created when primary key created Puneet Sharma
• 15:52   BUG #17199: Calling stored procedure with stable function as argument results in wrong result PG Bug reporting form
• 18:01   Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result Tom Lane
• 18:49   Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result Tom Lane
• 19:27   Re: BUG #17198: Planning time too high when execute query on standby cluster Andriy Bartash
• 23:46   Re: BUG #17193: Issue with pg_output login Euler Taveira

22 September 2021

• 00:09   Re: BUG #17193: Issue with pg_output login Gerdan Rezende dos Santos
• 04:30   Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES Neil Chen
• 16:17   BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? PG Bug reporting form
• 21:13   Internal error with types changes and prepared statements Daniele Varrazzo
• 21:27   Re: Internal error with types changes and prepared statements Tom Lane
• 21:32   Re: Internal error with types changes and prepared statements Daniele Varrazzo

23 September 2021

• 05:22   Re: BUG #17197: Assert failed on inserting index tuples after VACUUM Peter Geoghegan
• 07:44   Re: BUG #17183: missing websearch_to_tsquery Budi Setiawan
• 11:30   BUG #17201: Pg_largeobject table grows uncontrollably PG Bug reporting form

24 September 2021

• 00:14   BUG #17202: GENERATED BY DEFAULT AS IDENTITY not inherited (but SERIAL is) PG Bug reporting form
• 05:32   Re: BUG #17202: GENERATED BY DEFAULT AS IDENTITY not inherited (but SERIAL is) Japin Li
• 13:04   Re: BUG #17202: GENERATED BY DEFAULT AS IDENTITY not inherited (but SERIAL is) Erik Huelsmann

25 September 2021

• 20:25   Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data Andrey Borodin
• 23:10   Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data Noah Misch

27 September 2021

• 13:55   Snapshot leak warning with lo_export in subtransaction Heikki Linnakangas
• 15:33   Re: Snapshot leak warning with lo_export in subtransaction Alvaro Herrera

28 September 2021

• 09:15   Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? hpc researcher_mspk
• 12:50   pg_basebackup behavior on non-existent slot Dimitri Fontaine
• 13:25   Re: pg_basebackup behavior on non-existent slot Magnus Hagander
• 14:12   Re: [EXTERNAL] Re: pg_basebackup behavior on non-existent slot Dimitri Fontaine
• 15:57   v.13.3 Trigger Before Insert Max Tomich
• 16:39   Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? Tom Lane

29 September 2021

• 06:09   BUG #17203: missing websearch_to_tsquery PG Bug reporting form
• 12:24   Re: [EXTERNAL] pg_basebackup behavior on non-existent slot Daniel Gustafsson
• 16:36   Re: BUG #17203: missing websearch_to_tsquery Tom Lane
• 16:42   BUG #17204: Import PostgreSQL view to ADO.NET Entity Framework Model PG Bug reporting form

30 September 2021

• 10:19   BUG #17205: pg_class.reltuples vakue wrong for brin indexes after vacuum (by many orders of magnitude) PG Bug reporting form
• 12:03   Bug report function to_date should reject HH24:MI:SS formatting options Sébastien Caunes
• 16:35   Re: Bug report function to_date should reject HH24:MI:SS formatting options Tom Lane
• 17:10   Re: Bug report function to_date should reject HH24:MI:SS formatting options Sébastien Caunes
• 23:54   BUG #17206: the function array_cat(anyarray, anyarray) does not exist PG Bug reporting form