Mailing lists [pgsql-bugs]

1 January 2022

• 20:43   Re: BUG #17350: GIST TRGM Index is broken when combining with combining INCLUDE with a string function (e.g. lower). Tom Lane
• 21:00   BUG #17351: Altering a composite type created for a partitioned table can lead to a crash PG Bug reporting form

2 January 2022

• 00:27   Re: BUG #17351: Altering a composite type created for a partitioned table can lead to a crash Tom Lane
• 22:00   Re: BUG #17344: Assert failed on queiring async_capable foreign table with inheritance Alexander Lakhin

3 January 2022

• 13:38   BUG #17352: Column CHECK regex error PG Bug reporting form
• 14:11   Re: BUG #17352: Column CHECK regex error Francisco Olarte
• 14:16   Re: BUG #17352: Column CHECK regex error Vik Fearing

4 January 2022

• 11:03   Re: BUG #17344: Assert failed on queiring async_capable foreign table with inheritance Etsuro Fujita
• 17:57   BUG #17354: pg_hba_file_rules always shows verify-ca when auth_method=cert PG Bug reporting form

5 January 2022

• 19:48   Typo in MS Root Cert Expiration Date Bic.Nguyen@gd-ms.com

6 January 2022

• 03:40   Bug report: variable_conflict + ON CONFLICT Alexi Theodore
• 04:27   Re: Bug report: variable_conflict + ON CONFLICT Tom Lane
• 05:22   Re: Bug report: variable_conflict + ON CONFLICT David G. Johnston
• 05:48   Re: Bug report: variable_conflict + ON CONFLICT Alexi Theodore
• 11:00   BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition PG Bug reporting form
• 11:50   BUG #17356: hunspell-hu dictionary processing error PG Bug reporting form
• 12:56   Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition Etsuro Fujita
• 15:00   Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition Alexander Lakhin
• 23:51   Re: BUG #17351: Altering a composite type created for a partitioned table can lead to a crash Tom Lane

7 January 2022

• 01:58   Possible bug report Milos Musicki
• 03:51   BUG #17357: When working with the window_function, the Where Clause does not work properly! PG Bug reporting form
• 04:30   Re: Possible bug report David G. Johnston
• 09:15   Re: BUG #17344: Assert failed on queiring async_capable foreign table with inheritance Etsuro Fujita
• 09:19   Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition Etsuro Fujita
• 13:38   BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 PG Bug reporting form
• 14:39   Re: BUG #17357: When working with the window_function, the Where Clause does not work properly! Pantelis Theodosiou
• 23:48   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Tom Lane

8 January 2022

• 07:00   Re: BUG #17344: Assert failed on queiring async_capable foreign table with inheritance Alexander Lakhin
• 11:57   Re: BUG #17344: Assert failed on queiring async_capable foreign table with inheritance Etsuro Fujita
• 13:28   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Mikael Kjellström
• 18:51   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Tom Lane
• 22:00   Re: BUG #17344: Assert failed on queiring async_capable foreign table with inheritance Alexander Lakhin
• 22:12   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Mikael Kjellström
• 22:44   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Andres Freund
• 22:59   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Tom Lane
• 23:06   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Andres Freund
• 23:35   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Tom Lane
• 23:45   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Andres Freund

9 January 2022

• 00:25   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Tom Lane
• 03:38   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Tom Lane
• 11:18   Postgres HA and Pglogical Padmakumar Kadayaprth
• 20:00   Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction Alexander Lakhin
• 22:58   postgresql bug davood hasankhani

10 January 2022

• 08:43   Re: postgresql bug Semab Tariq
• 13:47   BUG #17360: array_to_string should be immutable instead of stable PG Bug reporting form
• 17:54   Re: BUG #17360: array_to_string should be immutable instead of stable Tom Lane
• 18:01   Re: BUG #17360: array_to_string should be immutable instead of stable Gergely Czuczy
• 18:54   Re: BUG #17360: array_to_string should be immutable instead of stable David G. Johnston
• 19:17   Re: BUG #17360: array_to_string should be immutable instead of stable David G. Johnston
• 19:33   Re: BUG #17360: array_to_string should be immutable instead of stable Tom Lane
• 21:32   Re: BUG #17360: array_to_string should be immutable instead of stable David G. Johnston
• 22:31   Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Peter Geoghegan

11 January 2022

• 01:29   BUG #17361: Unique index constraint inconsistence PG Bug reporting form
• 03:08   Re: BUG #17361: Unique index constraint inconsistence Tom Lane
• 09:44   Re: BUG #17361: Unique index constraint inconsistence Роман Григорович
• 13:46   BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7 PG Bug reporting form
• 22:45   Re: When Update balloons memory Peter Geoghegan
• 22:54   Re: When Update balloons memory Tom Lane
• 22:59   Re: When Update balloons memory Peter Geoghegan

12 January 2022

• 00:15   Re: When Update balloons memory Peter Geoghegan
• 01:19   Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7 Peter Geoghegan
• 01:46   BUG #17363: 14 regression: "could not identify a hash function for type record" in a nested record in sublink PG Bug reporting form
• 03:48   Re: BUG #17361: Unique index constraint inconsistence Peter Geoghegan
• 11:04   wrong output in dump of rules with old values of row type columns Timur Khanjanov
• 14:12   Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2 Peter Eisentraut
• 14:16   Re: Postgres HA and Pglogical Peter Eisentraut
• 17:21   Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7 Pasi Eronen
• 18:08   Re: wrong output in dump of rules with old values of row type columns Tom Lane
• 18:34   Re: BUG #17363: 14 regression: "could not identify a hash function for type record" in a nested record in sublink Tom Lane
• 18:53   BUG #17364: Errors caused by views PG Bug reporting form
• 19:59   Re: wrong output in dump of rules with old values of row type columns Timur Khanjanov
• 20:58   Re: BUG #17364: Errors caused by views Tom Lane
• 22:25   Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund

13 January 2022

• 00:05   Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Peter Geoghegan
• 02:44   Re: When Update balloons memory Peter Geoghegan
• 12:11   BUG #17365: Error: redefinition of 'stat' in win32_port.h when including postgres.h PG Bug reporting form
• 15:23   Re: BUG #17365: Error: redefinition of 'stat' in win32_port.h when including postgres.h Julien Rouhaud
• 18:12   Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7 Peter Eisentraut
• 18:22   Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7 Peter Eisentraut
• 18:28   Re: BUG #17365: Error: redefinition of 'stat' in win32_port.h when including postgres.h Tom Lane

14 January 2022

• 05:15   Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund
• 07:06   BUG #17366: Error result returned in timestamp2timestamptz, expected to be off by one hour PG Bug reporting form
• 14:30   Re: BUG #17366: Error result returned in timestamp2timestamptz, expected to be off by one hour Francisco Olarte
• 18:24   Re: BUG #17366: Error result returned in timestamp2timestamptz, expected to be off by one hour Tom Lane
• 20:00   Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Alexander Lakhin
• 22:00   Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum Andres Freund

15 January 2022

• 08:41   Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction Thomas Munro
• 11:00   BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction PG Bug reporting form
• 19:00   Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction Alexander Lakhin

16 January 2022

• 09:00   Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction Alexander Lakhin
• 16:05   pg_upgrade --check doesn't check pg_pltemplate modifications Tomas Barton
• 18:06   Re: BUG #17365: Error: redefinition of 'stat' in win32_port.h when including postgres.h Mario Emmenlauer
• 18:14   Re: BUG #17365: Error: redefinition of 'stat' in win32_port.h when including postgres.h Mario Emmenlauer
• 18:18   Re: BUG #17365: Error: redefinition of 'stat' in win32_port.h when including postgres.h Julien Rouhaud
• 18:30   Re: BUG #17365: Error: redefinition of 'stat' in win32_port.h when including postgres.h Mario Emmenlauer
• 19:43   Re: pg_upgrade --check doesn't check pg_pltemplate modifications Tom Lane

17 January 2022

• 00:00   Re: BUG #17363: 14 regression: "could not identify a hash function for type record" in a nested record in sublink Tom Lane

18 January 2022

• 11:01   Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition Etsuro Fujita
• 12:31   BUG #17369: tmp files didn't deleted after oom killer killed process PG Bug reporting form
• 21:20   Re: BUG #17369: tmp files didn't deleted after oom killer killed process Tom Lane

19 January 2022

• 06:05   BUG #17370: shmem lost on segfault PG Bug reporting form
• 12:28   Re: BUG #17370: shmem lost on segfault Julien Rouhaud
• 12:34   Re: BUG #17370: shmem lost on segfault RekGRpth
• 12:46   Re: BUG #17370: shmem lost on segfault Julien Rouhaud

20 January 2022

• 00:06   BUG #17371: Immutable INTERVAL to TEXT cast can cause incorrect query results PG Bug reporting form
• 00:42   Re: BUG #17371: Immutable INTERVAL to TEXT cast can cause incorrect query results Tom Lane
• 07:00   BUG #17372: Altering statistics during concurrent drop can lead to a server crash PG Bug reporting form
• 09:12   BUG #17373: Missing rhel-8.3-x86_64 yum repository dir for postgresql 14 PG Bug reporting form
• 12:25   BUG #17374: Bug in restore PG Bug reporting form
• 17:11   Re: BUG #17374: Bug in restore Tom Lane
• 17:35   BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER PG Bug reporting form
• 20:57   Re: BUG #17372: Altering statistics during concurrent drop can lead to a server crash Tomas Vondra

21 January 2022

• 05:00   Further information on BUG #17299: Exit code 3 when open connections concurrently (PQisthreadsafe() == 1) Liam Bowen
• 06:56   Re: Further information on BUG #17299: Exit code 3 when open connections concurrently (PQisthreadsafe() == 1) Tom Lane
• 08:29   Re: Further information on BUG #17299: Exit code 3 when open connections concurrently (PQisthreadsafe() == 1) Liam Bowen
• 09:00   Re: BUG #17372: Altering statistics during concurrent drop can lead to a server crash Alexander Lakhin
• 12:22   BUG #17376: Adding unique column with a function() default results in "could not read block 0 in file" error PG Bug reporting form
• 12:41   Re: BUG #17373: Missing rhel-8.3-x86_64 yum repository dir for postgresql 14 Devrim Gündüz
• 12:53   RE: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER B Ganesh Kishan
• 18:10   Re: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER David G. Johnston
• 18:20   Re: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER Tom Lane
• 20:27   Re: BUG #17376: Adding unique column with a function() default results in "could not read block 0 in file" error Japin Li
• 20:36   Re: BUG #17376: Adding unique column with a function() default results in "could not read block 0 in file" error Tom Lane
• 23:42   Re: Further information on BUG #17299: Exit code 3 when open connections concurrently (PQisthreadsafe() == 1) Tom Lane

22 January 2022

• 03:18   Re: BUG #17376: Adding unique column with a function() default results in "could not read block 0 in file" error Japin Li
• 07:15   Re: BUG #17376: Adding unique column with a function() default results in "could not read block 0 in file" error Tom Lane
• 09:33   Re: BUG #17376: Adding unique column with a function() default results in "could not read block 0 in file" error David G. Johnston
• 12:12   BUG #17377: only superusers can query or manipulate replication origins PG Bug reporting form

23 January 2022

• 05:55   BUG #17378: WRONG VALUE ON - A.2. Time Zones PG Bug reporting form
• 22:20   Re: BUG #17378: WRONG VALUE ON - A.2. Time Zones Tom Lane

24 January 2022

• 04:10   BUG #17379: Cannot issue multi-command statements using a replication connection PG Bug reporting form
• 08:55   RE: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER B Ganesh Kishan
• 17:52   Re: BUG #17379: Cannot issue multi-command statements using a replication connection Tom Lane
• 21:00   Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition Alexander Lakhin
• 22:00   Re: BUG #17379: Cannot issue multi-command statements using a replication connection Tom Lane

25 January 2022

• 05:28   BUG #17381: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" After installing PG Bug reporting form
• 14:38   Re: BUG #17381: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" After installing Matti Linnanvuori

26 January 2022

• 11:25   BUG #17382: When vacuum full or vacuumdb - F is executed, a large number of empty files will be generated in the PG Bug reporting form
• 11:29   回复：BUG #17382: When vacuum full or vacuumdb - F is executed, a large number of empty files will be generated in the 两个孩子的爹
• 12:03   Re: BUG #17354: pg_hba_file_rules always shows verify-ca when auth_method=cert Magnus Hagander
• 18:29   Re: BUG #17382: When vacuum full or vacuumdb - F is executed, a large number of empty files will be generated in the Tom Lane

27 January 2022

• 10:25   Re: BUG #17344: Assert failed on queiring async_capable foreign table with inheritance Etsuro Fujita
• 11:10   Re: BUG #17088: FailedAssertion in prepagg.c Kyotaro Horiguchi
• 12:07   The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type ideriha.takeshi@fujitsu.com
• 13:11   No access to TOAST tables shown in EXPLAIN ( ANALYZE, BUFFERS ) Christophe Courtois
• 16:59   RE: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER B Ganesh Kishan
• 17:16   Re: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER Bharath Rupireddy
• 17:52   Re: No access to TOAST tables shown in EXPLAIN ( ANALYZE, BUFFERS ) Tom Lane
• 23:57   BUG #17384: ERROR: missing chunk number 0 for toast value 152073604 in pg_toast_2619 PG Bug reporting form

28 January 2022

• 09:48   Re: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type Amit Langote
• 11:41   Postgresql error : PANIC: could not locate a valid checkpoint record Pragati Agarwal
• 12:07   BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end PG Bug reporting form
• 13:51   RE: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type ideriha.takeshi@fujitsu.com
• 16:41   BUG #17386: btree index corruption after reindex concurrently on write heavy table PG Bug reporting form
• 16:42   Re: BUG #17382: When vacuum full or vacuumdb - F is executed, a large number of empty files will be generated in the 两个孩子的爹
• 17:17   Re: BUG #17386: btree index corruption after reindex concurrently on write heavy table Maxim Boguk
• 18:26   Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Dmitry Koval
• 19:15   Re: BUG #17382: When vacuum full or vacuumdb - F is executed, a large number of empty files will be generated in the Tom Lane
• 19:17   snapshot recovery conflict despite hot_standby_feedback set to on Drouvot, Bertrand
• 20:22   BUG #17387: Working in PG13 but not in PGH14: array_agg(RECORD) PG Bug reporting form
• 23:19   Re: BUG #17387: Working in PG13 but not in PGH14: array_agg(RECORD) Pavel Stehule
• 23:28   Re: BUG #17387: Working in PG13 but not in PGH14: array_agg(RECORD) Pavel Stehule

29 January 2022

• 00:43   Re: BUG #17387: Working in PG13 but not in PGH14: array_agg(RECORD) Tom Lane
• 00:55   Re: BUG #17387: Working in PG13 but not in PGH14: array_agg(RECORD) Tom Lane
• 02:48   Re: BUG #17387: Working in PG13 but not in PGH14: array_agg(RECORD) Tom Lane
• 05:34   Re: BUG #17386: btree index corruption after reindex concurrently on write heavy table Noah Misch
• 06:00   Re: BUG #17386: btree index corruption after reindex concurrently on write heavy table Peter Geoghegan
• 06:44   Re: BUG #17387: Working in PG13 but not in PGH14: array_agg(RECORD) Tom Lane
• 08:43   Re: BUG #17386: btree index corruption after reindex concurrently on write heavy table Michael Paquier
• 18:23   Re: BUG #17386: btree index corruption after reindex concurrently on write heavy table Maxim Boguk

30 January 2022

• 05:47   Report a potential bug caused by a improper call to pfree() wliang@stu.xidian.edu.cn
• 06:43   Re: BUG #17386: btree index corruption after reindex concurrently on write heavy table Noah Misch
• 13:59   Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition Etsuro Fujita
• 16:36   Re: Report a potential bug caused by a improper call to pfree() Julien Rouhaud
• 18:29   Re: Report a potential bug caused by a improper call to pfree() Tom Lane
• 19:32   Missing include in float.h Ian R. Campbell
• 21:38   Re: Missing include in float.h Tom Lane

31 January 2022

• 05:41   Re: Report a potential bug caused by a improper call to pfree() Kyotaro Horiguchi
• 11:44   BUG #17388: postgis cant be installed on postgres 11 and centos 7 PG Bug reporting form
• 12:04   RE: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type ideriha.takeshi@fujitsu.com
• 15:00   RE: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER B Ganesh Kishan
• 19:11   BUG #17389: pg_repack creates race conditions on streaming replicas PG Bug reporting form