Mailing lists [pgsql-bugs]

1 December

• 07:57   Re: BUG #19095: Test if function exit() is used fail when linked static VASUKI M
• 12:03   Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big Daniel Gustafsson
• 14:31   BUG #19338: [PG15] Unstable SQL result in test regress/tablespace PG Bug reporting form
• 18:54   Re: BUG #19338: [PG15] Unstable SQL result in test regress/tablespace Tom Lane
• 19:52   Re: BUG #19338: [PG15] Unstable SQL result in test regress/tablespace Dmitry Kovalenko
• 23:11   BUG #19339: odbc_fdw extension, Not able to read data from foreign tables PG Bug reporting form

2 December

• 10:57   BUG #19340: Wrong result from CORR() function PG Bug reporting form
• 13:03   BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation PG Bug reporting form
• 14:30   Re: BUG #19340: Wrong result from CORR() function Laurenz Albe
• 16:02   BUG #19342: ERROR: function gcd(smallint, smallint) is not unique PG Bug reporting form
• 16:36   Re: BUG #19342: ERROR: function gcd(smallint, smallint) is not unique Daniel Gustafsson
• 17:05   Re: BUG #19340: Wrong result from CORR() function Oleg Ivanov
• 19:24   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe
• 19:31   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe
• 19:36   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Heikki Linnakangas
• 20:18   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe
• 20:22   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 20:22   Re: BUG #19340: Wrong result from CORR() function Laurenz Albe
• 20:25   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Tom Lane
• 20:29   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Heikki Linnakangas
• 20:45   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe
• 20:51   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe
• 21:54   Re: BUG #19340: Wrong result from CORR() function Dean Rasheed
• 22:41   BUG #19343: toast_internals.c:139:2: warning: missing braces around initializer [-Wmissing-braces] PG Bug reporting form
• 23:26   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 23:53   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Tom Lane

3 December

• 00:44   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe
• 02:03   Re: BUG #19340: Wrong result from CORR() function Dean Rasheed
• 02:24   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 02:48   Re: BUG #19340: Wrong result from CORR() function Dean Rasheed
• 03:17   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 04:27   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 10:51   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe
• 12:13   Re: BUG #19343: toast_internals.c:139:2: warning: missing braces around initializer [-Wmissing-braces] Heikki Linnakangas
• 14:38   Re: BUG #19340: Wrong result from CORR() function Dean Rasheed
• 14:59   Re: BUG #19095: Test if function exit() is used fail when linked static VASUKI M
• 18:12   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Tom Lane
• 19:33   Re: BUG #19340: Wrong result from CORR() function Tom Lane

4 December

• 01:52   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 02:33   Re: BUG #19095: Test if function exit() is used fail when linked static Daniel Gustafsson
• 03:11   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 03:32   Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier
• 13:19   Re: BUG #19332: Sudden 330x performance degradation of SELECT amid INSERTs Sergey Naumov
• 14:08   Re: BUG #19095: Test if function exit() is used fail when linked static VASUKI M
• 17:25   Segfault due to NULL ParamExecData value Anthonin Bonnefoy
• 18:35   Re: Segfault due to NULL ParamExecData value Tom Lane
• 20:14   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe

5 December

• 03:41   Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier
• 05:17   Re：GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Haowu Ge
• 05:41   BUG #19345: MemoryContextSizeFailure after upgrade 14.11 to 17.7 in stored procedure PG Bug reporting form
• 12:23   Re: BUG #19340: Wrong result from CORR() function Dean Rasheed
• 13:17   Re: BUG #19340: Wrong result from CORR() function Dean Rasheed
• 16:33   Re: Segfault due to NULL ParamExecData value Anthonin Bonnefoy
• 16:36   Re: BUG #19345: MemoryContextSizeFailure after upgrade 14.11 to 17.7 in stored procedure Kirill Reshke

6 December

• 01:17   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 04:12   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Tom Lane
• 09:09   Re: BUG #19340: Wrong result from CORR() function Tom Lane
• 14:51   Re: BUG #19340: Wrong result from CORR() function Dean Rasheed
• 21:18   Re: BUG #19340: Wrong result from CORR() function Tom Lane

7 December

• 00:04   Re: BUG #19345: MemoryContextSizeFailure after upgrade 14.11 to 17.7 in stored procedure Tom Lane
• 01:53   Re: BUG #19340: Wrong result from CORR() function Dean Rasheed
• 02:32   Re: BUG #19340: Wrong result from CORR() function Tom Lane

8 December

• 07:41   Re: BUG #19095: Test if function exit() is used fail when linked static VASUKI M
• 09:10   Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Richard Guo

9 December

• 07:16   Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier
• 09:10   Re: BUG #19095: Test if function exit() is used fail when linked static Peter Eisentraut
• 09:26   Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier
• 09:38   Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Richard Guo
• 11:54   Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Haowu Ge
• 13:23   Re: BUG #19095: Test if function exit() is used fail when linked static VASUKI M
• 14:04   BUG #19348: Disk space error when running COPY after upgrading to PostgreSQL 17.7 PG Bug reporting form
• 14:30   Re: BUG #19345: MemoryContextSizeFailure after upgrade 14.11 to 17.7 in stored procedure weijie JL
• 15:47   Re: BUG #19095: Test if function exit() is used fail when linked static Bilal Yavuz
• 17:28   Re: BUG #19348: Disk space error when running COPY after upgrading to PostgreSQL 17.7 Greg Sabino Mullane

10 December

• 00:19   Re: BUG #19348: Disk space error when running COPY after upgrading to PostgreSQL 17.7 Thomas Munro
• 02:11   Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier
• 04:07   Re: BUG #19348: Disk space error when running COPY after upgrading to PostgreSQL 17.7 weijie JL
• 05:01   Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Richard Guo
• 05:11   Re: BUG #19007: Planner fails to choose partial index with spurious 'not null' Richard Guo
• 06:46   Re: BUG #19332: Sudden 330x performance degradation of SELECT amid INSERTs David Rowley
• 08:14   Re: BUG #19095: Test if function exit() is used fail when linked static Michael Paquier
• 13:03   Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation Laurenz Albe
• 13:31   BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC PG Bug reporting form
• 13:33   Re: BUG #19332: Sudden 330x performance degradation of SELECT amid INSERTs Sergey Naumov
• 14:41   Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables Etsuro Fujita
• 16:33   Re: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC David G. Johnston
• 16:41   Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC ZhangChi
• 16:46   Re: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC David G. Johnston
• 17:01   Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC ZhangChi
• 17:51   BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. PG Bug reporting form
• 18:50   Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables Vijay Reddy
• 19:02   Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Srinath Reddy Sadipiralla
• 19:07   Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC Tom Lane
• 19:40   Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Srinath Reddy Sadipiralla

11 December

• 05:32   Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Haowu Ge
• 07:16   Re: BUG #19006: Assert(BufferIsPinned) in BufferGetBlockNumber() is triggered for forwarded buffer Xuneng Zhou
• 10:27   Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Álvaro Herrera
• 10:29   Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Álvaro Herrera
• 14:01   Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables Etsuro Fujita

12 December

• 05:14   BUG #19352: SQL Error messages do not include schema name along with table or data object name. PG Bug reporting form
• 12:00   Re: BUG #19352: SQL Error messages do not include schema name along with table or data object name. Kirill Reshke
• 12:28   Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Richard Guo
• 13:11   BUG #19353: Error XX000 if referencing expanded array in grouping set: variable not found in subplan target list PG Bug reporting form
• 13:23   Re:Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. yanliang lei
• 13:59   Bug in sub-query Veeranjaneya Vara Prasad Peddireddy
• 18:01   Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Álvaro Herrera
• 18:10   Re: BUG #19352: SQL Error messages do not include schema name along with table or data object name. Álvaro Herrera
• 18:26   Re: Bug in sub-query Tom Lane
• 18:39   Re: BUG #19352: SQL Error messages do not include schema name along with table or data object name. Tom Lane
• 19:54   Re: BUG #19353: Error XX000 if referencing expanded array in grouping set: variable not found in subplan target list Tom Lane

13 December

• 07:15   Re:Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. yanliang lei
• 13:01   Re: BUG #19353: Error XX000 if referencing expanded array in grouping set: variable not found in subplan target list Tender Wang
• 15:18   recovery_target discrepancy? Thomas Rosenstein
• 15:44   Re: Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Álvaro Herrera
• 21:52   BUG #19354: JOHAB rejects valid byte sequences PG Bug reporting form
• 22:34   Cluster is not being created T iv

14 December

• 20:00   Re: Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Srinath Reddy Sadipiralla

15 December

• 04:23   Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Haowu Ge
• 04:40   BUG #19355: Attempt to insert data unexpectedly during concurrent update PG Bug reporting form
• 09:25   Re: BUG #19355: Attempt to insert data unexpectedly during concurrent update Laurenz Albe
• 19:50   Re: Cluster is not being created Robert Haas
• 20:46   Re: BUG #19354: JOHAB rejects valid byte sequences Robert Haas
• 22:35   Re: BUG #19332: Sudden 330x performance degradation of SELECT amid INSERTs David Rowley

16 December

• 03:07   Re: BUG #19354: JOHAB rejects valid byte sequences Jeroen Vermeulen
• 03:56   Re: BUG #19354: JOHAB rejects valid byte sequences Tom Lane
• 06:06   BUG #19356: Unexpected result of prepared UPDATE with force_generic_plan PG Bug reporting form
• 09:23   Re: BUG #19354: JOHAB rejects valid byte sequences VASUKI M
• 10:42   Re: BUG #19354: JOHAB rejects valid byte sequences Jeroen Vermeulen
• 14:30   Re: BUG #19353: Error XX000 if referencing expanded array in grouping set: variable not found in subplan target list Tender Wang
• 17:26   Re: BUG #19354: JOHAB rejects valid byte sequences Robert Haas
• 18:17   Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC Greg Sabino Mullane
• 18:41   Re: BUG #19354: JOHAB rejects valid byte sequences Tom Lane
• 21:42   Re: BUG #19354: JOHAB rejects valid byte sequences Robert Haas

17 December

• 03:25   Possible performance issues: DISTINCT ON + ORDER BY and JIT with aggregation Jhonathan Cruz
• 04:40   Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC ZhangChi
• 05:59   Re: BUG #19354: JOHAB rejects valid byte sequences Michael Paquier
• 08:32   Re: Cluster is not being created VASUKI M
• 09:57   BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query. PG Bug reporting form
• 15:03   BUG #19358: Short circuit optimization exists in generic plan but missed in custom plan PG Bug reporting form
• 15:55   Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC Dave Cramer
• 17:51   Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC Greg Sabino Mullane
• 17:54   Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query. Greg Sabino Mullane
• 18:14   Re: Possible performance issues: DISTINCT ON + ORDER BY and JIT with aggregation Laurenz Albe
• 18:17   Re: BUG #19357: PostgreSQL generates a custom plan that performsworse than the generic plan for a certain query. ZhangChi
• 18:33   Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC Dave Cramer
• 18:39   Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query. Tom Lane
• 18:39   Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC Dave Cramer
• 18:44   Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC Tom Lane
• 18:52   Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query. ZhangChi
• 18:53   Re: BUG #19357: PostgreSQL generates a custom plan that performsworse than the generic plan for a certain query. Pavel Stehule
• 19:08   Re: BUG #19357: PostgreSQL generates a custom plan that performsworsethan the generic plan for a certain query. ZhangChi
• 19:15   Re: BUG #19357: PostgreSQL generates a custom plan that performsworsethan the generic plan for a certain query. Pavel Stehule
• 19:20   Re: BUG #19357: PostgreSQL generates a custom plan thatperformsworsethan the generic plan for a certain query. ZhangChi
• 19:33   Re: BUG #19357: PostgreSQL generates a custom plan thatperformsworsethan the generic plan for a certain query. Pavel Stehule
• 20:11   Re: BUG #19357: PostgreSQL generates a custom plan that performsworsethan the generic plan for a certain query. Greg Sabino Mullane

18 December

• 00:37   Re: BUG #19358: Short circuit optimization exists in generic plan but missed in custom plan Tom Lane
• 09:42   [BUG] PostgreSQL 14.5: Data corruption in table tb_workstation_message (possible fstrim-related on eMMC) 第108次明天
• 11:40   Re: [BUG] PostgreSQL 14.5: Data corruption in table tb_workstation_message (possible fstrim-related on eMMC) Laurenz Albe
• 11:56   Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) Richard Guo
• 16:30   Re: [BUG] PostgreSQL 14.5: Data corruption in table tb_workstation_message (possible fstrim-related on eMMC) Greg Sabino Mullane
• 18:03   BUG #19359: Row level security: Upserts require insert policies in the update path PG Bug reporting form

19 December

• 20:40   Re: BUG #19359: Row level security: Upserts require insert policies in the update path Srinath Reddy Sadipiralla