Home > mailing lists

Mailing lists [pgsql-bugs]

1 July

03:12 Re: BUG #18484: "Cannot enlarge string buffer" during parallel execution of prepared statement/partitioning David Rowley
05:49 Re: BUG #18526: 'UPDATE' inconsistency using index scan with 'NOT EXIST' after upgrading to PostgreSQL 16 Richard Guo
05:55 Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join Richard Guo
07:08 using TEMP with the VACUUM function Wing Kin Chong
16:13 Re: using TEMP with the VACUUM function David G. Johnston
17:32 Re: using TEMP with the VACUUM function Tom Lane
18:08 BUG #18527: Imported data using a csv file and made a latest entry into same table using a form. Got an issue! PG Bug reporting form
18:39 Re: BUG #18527: Imported data using a csv file and made a latest entry into same table using a form. Got an issue! David G. Johnston
20:30 Re: BUG #18527: Imported data using a csv file and made a latest entry into same table using a form. Got an issue! Erik Wienhold

2 July

02:25 Re: using TEMP with the VACUUM function Wing Kin Chong
12:57 Re: Bug report - pg_upgrade tool seems to have a race condition when trying to delete a pg_wal file Waka Ranai
13:22 Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join Richard Guo
22:38 BUG #18528: Installer displays error when installing PG Bug reporting form

3 July

05:42 Re: BUG #18528: Installer displays error when installing Sandeep Thakkar
11:44 Re: Bug report - pg_upgrade tool seems to have a race condition when trying to delete a pg_wal file Laurenz Albe
15:12 RE: [EXTERNAL] Re: BUG #18528: Installer displays error when installing Ware, Christopher M. (LARC-D318)[RSES]
18:14 Re: [BUGS] BUG #10123: Weird entries in pg_stat_activity Fujii Masao
21:21 Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert Alvaro Herrera

4 July

07:54 BUG #18529: Can not install as Document PG Bug reporting form
08:54 Re: [BUGS] BUG #10123: Weird entries in pg_stat_activity Fujii Masao
10:57 Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert Tender Wang
15:17 Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert Alvaro Herrera
15:20 Re: BUG #18529: Can not install as Document Erik Wienhold
17:18 Re: BUG #18529: Can not install as Document Laurenz Albe

5 July

01:03 Re: [BUGS] BUG #10123: Weird entries in pg_stat_activity Andres Freund
05:24 Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert Tender Wang
06:41 Re: BUG #18362: unaccent rules and Old Greek text Thomas Munro
07:53 Re: BUG #18362: unaccent rules and Old Greek text Michael Paquier
14:21 Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
15:49 Re: BUG #17889: Invalid cursor direction for a foreign scan that reached the fetch_size (MOVE BACKWARD ALL IN cX) Etsuro Fujita
17:41 Omitting relpages for toast table access not expected Stefan Litsche
17:52 Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada
18:07 Re: Omitting relpages for toast table access not expected Tom Lane

6 July

01:00 Windows Application Issues | PostgreSQL | REF # 51961374 Haifang Wang (Centific Technologies Inc)
14:49 vacuumdb: permission denied for schema "pg_temp_7" vaibhave postgres

7 July

10:16 Re: Windows Application Issues | PostgreSQL | REF # 51961374 Thomas Munro
13:56 Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM Muhammad Ikram
14:00 Re: BUG #18509: Logical decoding behaves badly when processing a change record for a table with altered column Alexander Lakhin

8 July

02:56 Re: Potential data loss due to race condition during logical replication slot creation Michael Paquier
05:33 Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join Richard Guo
06:01 Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada
09:01 AW: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
09:13 Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM Muhammad Ikram
12:01 RE: Potential data loss due to race condition during logical replication slot creation Hayato Kuroda (Fujitsu)
14:35 Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM Sandeep Thakkar
14:44 AW: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
15:58 Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM Sandeep Thakkar
17:02 Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada
18:52 RE: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 51961374 Haifang Wang (Centific Technologies Inc)
20:03 Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Tom Lane

9 July

00:23 Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Melanie Plageman
08:29 Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada
12:27 Re: Potential data loss due to race condition during logical replication slot creation Amit Kapila
14:00 BUG #18531: err when using 'current of' with incremental COMMIT PG Bug reporting form
19:01 Re: pg_rewind fails on Windows where tablespaces are used Andrew Dunstan

10 July

02:12 Re: pg_rewind fails on Windows where tablespaces are used Michael Paquier
04:15 Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada
05:21 Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada
06:43 Re: Potential data loss due to race condition during logical replication slot creation Amit Kapila
08:30 Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada
18:11 encrypted pk8 keys work with libpg connection but not in postgres_fdw Hunter Payne
19:31 RE: [EXTERNAL] Re: BUG #18528: Installer displays error when installing Ware, Christopher M. (LARC-D318)[RSES]

11 July

04:20 Re: pg_rewind fails on Windows where tablespaces are used Chris Travers

12 July

00:16 Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Noah Misch
04:20 Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae Michael Paquier
05:30 Re: BUG #18369: logical decoding core on AssertTXNLsnOrder() Masahiko Sawada
05:52 Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada
06:42 Re: Potential data loss due to race condition during logical replication slot creation Michael Paquier
10:58 BUG #18533: pg_basebackup uses out-of-bounds memory and a segment error occurs during backup PG Bug reporting form
12:31 BUG #18534: ERROR: portal "C_n" does not exist type of error getting thrown. PG Bug reporting form
13:57 Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert Alvaro Herrera
15:36 Re: BUG #18156: Self-referential foreign key in partitioned table not enforced on deletes Alvaro Herrera
19:35 Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); jian he

13 July

12:00 BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error PG Bug reporting form

14 July

18:09 Re: BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error Tom Lane
18:39 libpq: unexpected return code from PQexecParams with a DO INSTEAD rule present Vasilii Smirnov
20:01 Re: BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error Tom Lane
20:30 Re: BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error Tom Lane

15 July

11:28 BUG #18540: Does PG16 standby database support function pg_replication_origin_advance? PG Bug reporting form
13:00 BUG #18541: Reattaching a partition referenced by a foreign key fails with an error PG Bug reporting form
13:51 Re: BUG #17889: Invalid cursor direction for a foreign scan that reached the fetch_size (MOVE BACKWARD ALL IN cX) Etsuro Fujita
14:23 Re: BUG #18534: ERROR: portal "C_n" does not exist type of error getting thrown. Aleksander Alekseev
15:16 Re: BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error Aleksander Alekseev
15:17 Re: BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error Aleksander Alekseev
16:18 Re: BUG #18541: Reattaching a partition referenced by a foreign key fails with an error Tender Wang
16:55 Re: BUG #17889: Invalid cursor direction for a foreign scan that reached the fetch_size (MOVE BACKWARD ALL IN cX) Tom Lane
17:04 Re: libpq: unexpected return code from PQexecParams with a DO INSTEAD rule present Aleksander Alekseev
19:07 Re: BUG #18531: err when using 'current of' with incremental COMMIT Tom Lane
22:35 Re: BUG #18371: There are wrong constraint residues when detach hash partiton concurrently alvherre
22:45 Re: BUG #17889: Invalid cursor direction for a foreign scan that reached the fetch_size (MOVE BACKWARD ALL IN cX) Etsuro Fujita
23:01 Re: BUG #17889: Invalid cursor direction for a foreign scan that reached the fetch_size (MOVE BACKWARD ALL IN cX) Tom Lane

16 July

04:00 Re: BUG #18540: Does PG16 standby database support function pg_replication_origin_advance? Michael Paquier
08:03 Re: BUG #18371: There are wrong constraint residues when detach hash partiton concurrently feichanghong
10:39 Re: BUG #18371: There are wrong constraint residues when detach hash partiton concurrently Tender Wang
12:12 BUG #18542: Order by expression, that contains column from projection isn't working PG Bug reporting form
13:29 Re: BUG #17889: Invalid cursor direction for a foreign scan that reached the fetch_size (MOVE BACKWARD ALL IN cX) Etsuro Fujita
15:45 Re: BUG #18542: Order by expression, that contains column from projection isn't working Tom Lane

17 July

15:53 BUG #18543: Mistake in docs example PG Bug reporting form
16:58 Re: libpq: unexpected return code from PQexecParams with a DO INSTEAD rule present Aleksander Alekseev
17:55 RE：BUG #18533: pg_basebackup uses out-of-bounds memory and a segment error occurs during backup 1165125080
20:03 Re: libpq: unexpected return code from PQexecParams with a DO INSTEAD rule present Tom Lane
22:03 Re: BUG #18543: Mistake in docs example Tom Lane

18 July

12:34 BUG #18544: Setting local config_parameter to DEFAULT behaves unexpectedly when using period in config name PG Bug reporting form
14:46 Re: BUG #18544: Setting local config_parameter to DEFAULT behaves unexpectedly when using period in config name Aleksander Alekseev
14:58 Re: BUG #18544: Setting local config_parameter to DEFAULT behaves unexpectedly when using period in config name Hayden Sim
16:53 Re: BUG #18544: Setting local config_parameter to DEFAULT behaves unexpectedly when using period in config name David G. Johnston
16:55 Re: BUG #18544: Setting local config_parameter to DEFAULT behaves unexpectedly when using period in config name Tom Lane

19 July

05:39 Re: BUG #18544: Setting local config_parameter to DEFAULT behaves unexpectedly when using period in config name Hayden Sim
07:45 Re: BUG #17889: Invalid cursor direction for a foreign scan that reached the fetch_size (MOVE BACKWARD ALL IN cX) Etsuro Fujita
12:25 BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION PG Bug reporting form
16:17 Re: BUG #18544: Setting local config_parameter to DEFAULT behaves unexpectedly when using period in config name David G. Johnston
17:44 Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends Nathan Bossart
20:06 Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends Nathan Bossart
22:03 Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION Tom Lane

20 July

12:00 BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error PG Bug reporting form
19:26 Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error Tom Lane

21 July

01:12 BUG #18547: bemused by your unhelpful installation guides PG Bug reporting form
14:54 Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 Thomas Munro
16:28 Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 Andrew Dunstan
19:52 Re: BUG #18547: bemused by your unhelpful installation guides Christophe Pettus
22:39 Re: BUG #18547: bemused by your unhelpful installation guides David G. Johnston

22 July

01:00 Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 Thomas Munro
05:51 回复: [External]Re: BUG #18540: Does PG16 standby database support function pg_replication_origin_advance? Jason ChenTJ (CN)
11:41 Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error Dean Rasheed
14:24 Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 Andrew Dunstan
15:12 Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 Sandeep Thakkar
17:31 Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error Tom Lane
17:46 Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. Mohammed Siddiqui
19:07 BUG #18549: Support ipv6 link-local addresses in the inet type PG Bug reporting form
19:36 Re: BUG #18549: Support ipv6 link-local addresses in the inet type Tom Lane

23 July

01:37 A generated column cannot be part of a partition key Diego Stammerjohann
11:33 Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. Aleksander Alekseev
14:55 Re: A generated column cannot be part of a partition key Francisco Olarte
15:01 Re: A generated column cannot be part of a partition key Diego Stammerjohann
16:00 BUG #18550: Cross-partition update of a former inheritance parent leads to an assertion failure PG Bug reporting form
16:31 Re: A generated column cannot be part of a partition key Erik Wienhold
16:57 Re: A generated column cannot be part of a partition key Francisco Olarte
17:01 Re: A generated column cannot be part of a partition key Diego Stammerjohann
17:18 Re: A generated column cannot be part of a partition key David G. Johnston
17:51 Re: A generated column cannot be part of a partition key Peter Eisentraut
18:37 BUG #18551: pg_basebackup uses out-of-bounds memory and a segment error occurs during backup PG Bug reporting form
19:35 Re: BUG #18550: Cross-partition update of a former inheritance parent leads to an assertion failure Tom Lane
19:41 Re: BUG #18551: pg_basebackup uses out-of-bounds memory and a segment error occurs during backup Tom Lane
20:21 Re: BUG #18550: Cross-partition update of a former inheritance parent leads to an assertion failure Alvaro Herrera
22:38 Re: BUG #18550: Cross-partition update of a former inheritance parent leads to an assertion failure Tom Lane

24 July

00:00 Re: BUG #18533: pg_basebackup uses out-of-bounds memory and a segment error occurs during backup Tom Lane
01:18 Re: BUG #18549: Support ipv6 link-local addresses in the inet type Johannes Ernst
13:44 Re: BUG #18550: Cross-partition update of a former inheritance parent leads to an assertion failure Alvaro Herrera

25 July

00:51 Re: "unexpected duplicate for tablespace" problem in logical replication Masahiko Sawada
06:51 RE: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. Mohammed Siddiqui
09:08 Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 Thomas Munro
12:53 BUG #18552: slow query, but using union is ok. PG Bug reporting form
15:06 Re: BUG #18552: slow query, but using union is ok. David Rowley

26 July

09:20 BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. PG Bug reporting form
14:56 BUG #18554: pg_verifybackup is not work PG Bug reporting form
16:15 RE: [EXTERNAL] BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. Wetmore, Matthew (CTR)
16:32 Re: BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. David G. Johnston
17:04 Re: BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. Andrew Dunstan
17:32 Re: BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. Zaid Shabbir
20:52 Re: BUG #18554: pg_verifybackup is not work Zaid Shabbir
22:07 BUG #18556: Parallel operation error during CREATE TABLE AS statement PG Bug reporting form

27 July

00:06 BUG #18557: Compatibility issue PG Bug reporting form
02:19 Re: BUG #18557: Compatibility issue Tom Lane
02:46 Re: BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. Thomas Munro
03:10 Re: BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. Christophe Pettus
03:22 Re: BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. 燕尘
12:00 BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column PG Bug reporting form

29 July

04:53 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column Peter Smith
05:23 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column Tom Lane
05:45 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column Peter Smith
06:01 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column Tom Lane
08:18 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column Peter Smith
08:24 Re: BUG #18553: Please seriously address the severe issue of database installation failures on Windows 10. Sandeep Thakkar
09:14 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column David Rowley
11:10 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column Peter Smith
11:24 Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION Андрей Рачицкий
16:52 Re: 回复: [External]Re: BUG #18540: Does PG16 standby database support function pg_replication_origin_advance? Bertrand Drouvot
17:06 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column Tom Lane
17:08 Re: BUG #18558: ALTER PUBLICATION fails with unhelpful error on attempt to use system column Tom Lane

30 July

13:28 Installer initialization failed dharm raj
15:20 Re: Installer initialization failed Zaid Shabbir
15:36 Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. Muhammad Waqas
16:15 Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. Zaid Shabbir
16:21 Re: Installer initialization failed semab tariq
16:34 RE: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. Mohammed Siddiqui
16:41 Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. Zaid Shabbir
16:47 BUG #18559: Crash after detaching a partition concurrently from another session PG Bug reporting form
16:52 Re: BUG #18559: Crash after detaching a partition concurrently from another session Kuntal Ghosh
17:54 Re: Installer initialization failed semab tariq

31 July

05:34 Re: BUG #18559: Crash after detaching a partition concurrently from another session Tender Wang
07:47 BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator PG Bug reporting form
10:43 Re: Installer initialization failed Muhammad Waqas
12:19 Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator Aleksander Alekseev
12:46 Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator hubert depesz lubaczewski
12:53 Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 Sandeep Thakkar
13:55 Inconsistency of timezones in postgresql Chris BSomething
14:11 Re: BUG #18556: Parallel operation error during CREATE TABLE AS statement Aleksander Alekseev
14:50 Re: Inconsistency of timezones in postgresql Aleksander Alekseev
15:31 Re: Inconsistency of timezones in postgresql David G. Johnston
15:35 Re: Inconsistency of timezones in postgresql Chris BSomething
15:52 Re: Inconsistency of timezones in postgresql Aleksander Alekseev
16:00 Re: [EXTERNAL] Re: BUG #18528: Installer displays error when installing Sandeep Thakkar
16:06 Re: Inconsistency of timezones in postgresql Chris BSomething
16:17 Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator Junwang Zhao
16:23 Re: Inconsistency of timezones in postgresql Aleksander Alekseev
16:24 Re: BUG #18556: Parallel operation error during CREATE TABLE AS statement Shaun Thomas
16:33 Re: BUG #18556: Parallel operation error during CREATE TABLE AS statement Aleksander Alekseev
17:07 Re: Inconsistency of timezones in postgresql Chris BSomething
17:35 Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator Tom Lane
17:35 Re: Inconsistency of timezones in postgresql David G. Johnston
17:51 Re: Inconsistency of timezones in postgresql Aleksander Alekseev
18:15 Re: Inconsistency of timezones in postgresql Tom Lane
18:16 Re: Inconsistency of timezones in postgresql David G. Johnston
18:16 BUG #18561: postgresql16-devel rpm cannot be installed due to missing Perl-IPC-Run PG Bug reporting form
18:34 Re: Inconsistency of timezones in postgresql Tom Lane
19:16 Re: BUG #18561: postgresql16-devel rpm cannot be installed due to missing Perl-IPC-Run Andrew Dunstan
20:14 Re: Inconsistency of timezones in postgresql Chris BSomething
20:42 Re: Inconsistency of timezones in postgresql David G. Johnston
22:03 Re: Inconsistency of timezones in postgresql Chris BSomething
22:28 Re: BUG #18561: postgresql16-devel rpm cannot be installed due to missing Perl-IPC-Run Tim Dysinger
22:33 Re: BUG #18561: postgresql16-devel rpm cannot be installed due to missing Perl-IPC-Run Tim Dysinger
22:44 Re: BUG #18561: postgresql16-devel rpm cannot be installed due to missing Perl-IPC-Run Tim Dysinger