Mailing lists [pgsql-bugs]

1 April 2021

• 00:27   Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG Tom Lane
• 00:45   Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG Sergey KOPOSOV
• 01:47   Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG Tom Lane
• 01:52   Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG Sergey KOPOSOV
• 01:55   Re: BUG #16948: Packages not signed Devrim Gündüz
• 16:05   Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG Sergey KOPOSOV
• 18:39   Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG Tom Lane
• 21:13   Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG Tom Lane

2 April 2021

• 14:09   RE: BUG #16922: In cascading replication, a standby server aborted when an upstream standby server promoted egashira.yusuke@fujitsu.com
• 16:51   standby fails with out-of-order XID insertion upon start Radoslav Nedyalkov
• 17:09   Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES Boris P. Korzun
• 20:35   Re: Number of Shared Blocks Hit Andres Freund

4 April 2021

• 02:07   BUG #16952: PG admin errors out when connecting via ssh because it can't get pg_settings PG Bug reporting form
• 03:45   Re: BUG #16952: PG admin errors out when connecting via ssh because it can't get pg_settings Tom Lane

6 April 2021

• 12:30   Do we need to add parameter to libpq to set the TCP_SYNCNT parameter chenyanfei

7 April 2021

• 03:57   PG 13.2 working with postgresql-13-setup Karl Burkett
• 12:09   BUG #16953: OOB access while converting "interval" to char PG Bug reporting form
• 13:59   XX000: iso-8859-1 type of jsonb container. Poot, Bas (B.J.)
• 15:08   Re: BUG #16953: OOB access while converting "interval" to char Julien Rouhaud
• 19:31   Re: BUG #16707: Memory leak Andres Freund
• 21:11   Re: XX000: iso-8859-1 type of jsonb container. Dmitry Dolgov

8 April 2021

• 13:17   Re: BUG #16953: OOB access while converting "interval" to char Michael Paquier
• 14:04   Re: BUG #16953: OOB access while converting "interval" to char Julien Rouhaud
• 14:37   Re: BUG #16953: OOB access while converting "interval" to char Michael Paquier
• 16:35   BUG #16954: After install postgresql.service activates but does not activate postgresql@11-main.service PG Bug reporting form
• 16:53   BUG #16955: Replication port problems PG Bug reporting form
• 18:00   BUG #16956: psql won't load command history PG Bug reporting form
• 18:15   Re: BUG #16955: Replication port problems Tom Lane
• 19:04   Re: BUG #16956: psql won't load command history Tom Lane
• 20:14   Re: BUG #16956: psql won't load command history Robin Knipe

9 April 2021

• 09:52   Update locks the row even if there is no row to update Roman
• 13:42   Re: BUG #16953: OOB access while converting "interval" to char Julien Rouhaud
• 13:58   Re: BUG #16953: OOB access while converting "interval" to char Michael Paquier
• 23:51   BUG #16957: initdb.exe initialize a database cluster has stopped working PG Bug reporting form

10 April 2021

• 00:31   BUG #16958: "Invalid reference to FROM-clause entry for table" when qualifying columns in "on conflict .. where" PG Bug reporting form
• 01:42   Re: BUG #16931: source code problem about commit_ts Alvaro Herrera
• 10:57   Re: BUG #16958: "Invalid reference to FROM-clause entry for table" when qualifying columns in "on conflict .. where" Pantelis Theodosiou
• 13:28   Re: BUG #16958: "Invalid reference to FROM-clause entry for table" when qualifying columns in "on conflict .. where" Vik Fearing
• 19:28   Re: BUG #16958: "Invalid reference to FROM-clause entry for table" when qualifying columns in "on conflict .. where" Tom Lane
• 19:54   Re: BUG #16958: "Invalid reference to FROM-clause entry for table" when qualifying columns in "on conflict .. where" Peter Geoghegan

11 April 2021

• 03:20   Re: BUG #16958: "Invalid reference to FROM-clause entry for table" when qualifying columns in "on conflict .. where" Tom Lane
• 07:18   Re: BUG #16957: initdb.exe initialize a database cluster has stopped working Sandeep Thakkar
• 13:34   Re: BUG #16957: initdb.exe initialize a database cluster has stopped working sadaqat
• 18:09   Re: BUG #16931: source code problem about commit_ts Fujii Masao

12 April 2021

• 02:50   BUG #16959: Unnesting null from string_to_array silently removes whole rows from result PG Bug reporting form
• 03:46   Re: BUG #16959: Unnesting null from string_to_array silently removes whole rows from result Tom Lane
• 06:04   Re: BUG #16953: OOB access while converting "interval" to char Michael Paquier
• 06:13   Re: BUG #16953: OOB access while converting "interval" to char Julien Rouhaud
• 20:19   BUG #16960: Illegal reflective access operation PG Bug reporting form
• 23:30   Re: BUG #16960: Illegal reflective access operation Tom Lane

13 April 2021

• 17:01   Problem with accessing TOAST data in stored procedures Yura Sokolov
• 17:29   Re: Problem with accessing TOAST data in stored procedures Yura Sokolov
• 18:43   BUG #16961: Could not access status of transaction PG Bug reporting form
• 19:15   Re: XX000: iso-8859-1 type of jsonb container. Dmitry Dolgov
• 22:17   BUG #16962: Conflicting Request Error Installing pgAudit PG Bug reporting form

14 April 2021

• 09:01   Re: Problem with accessing TOAST data in stored procedures Michael Paquier
• 19:11   Re: BUG #16961: Could not access status of transaction Stepan Yankevych
• 23:13   Re: [BUGS] BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail Bruce Momjian
• 23:15   Re: BUG #16962: Conflicting Request Error Installing pgAudit Bruce Momjian

15 April 2021

• 11:54   Re: postgres has no spinlock support on riscv rv64imafdc Thomas Munro
• 12:15   BUG #16963: Wrong command in C:\Program Files (x86)\PostgreSQL\10\pg_env.bat PG Bug reporting form
• 13:16   BUG #16964: Quadratic performance degradation of INSERT and ADD CONSTRAINT for intarray/GIST EXCLUDE CONSTRAINT PG Bug reporting form
• 17:04   Re: postgres has no spinlock support on riscv rv64imafdc Tom Lane
• 19:05   BUG #16965: Select query fails with ERROR: XX000: could not find pathkey item to sort PG Bug reporting form
• 20:17   Re: BUG #16964: Quadratic performance degradation of INSERT and ADD CONSTRAINT for intarray/GIST EXCLUDE CONSTRAINT Tom Lane
• 21:55   Re: BUG #16964: Quadratic performance degradation of INSERT and ADD CONSTRAINT for intarray/GIST EXCLUDE CONSTRAINT Maxim Boguk
• 22:35   Re: BUG #16964: Quadratic performance degradation of INSERT and ADD CONSTRAINT for intarray/GIST EXCLUDE CONSTRAINT Maxim Boguk

16 April 2021

• 00:13   BUG #16966: Nested loop joining across tables with varchar -> bpchar cast always scans varchar table first PG Bug reporting form
• 00:38   Re: BUG #16965: Select query fails with ERROR: XX000: could not find pathkey item to sort Bruce Momjian
• 15:36   Re: BUG #16966: Nested loop joining across tables with varchar -> bpchar cast always scans varchar table first Tom Lane
• 19:16   Re: BUG #16966: Nested loop joining across tables with varchar -> bpchar cast always scans varchar table first Zeb Burke-Conte
• 19:49   Re: BUG #16966: Nested loop joining across tables with varchar -> bpchar cast always scans varchar table first Tom Lane
• 19:52   BUG #16967: Extremely slow update statement in trigger PG Bug reporting form
• 22:18   BUG #16968: Planner does not recognize optimization PG Bug reporting form
• 22:27   Re: BUG #16968: Planner does not recognize optimization Eugen Konkov

17 April 2021

• 14:18   BUG #16969: INSERT of multiple rows into GENERATED ALWAYS AS IDENTITY column with DEFAULT value is broken. PG Bug reporting form
• 18:03   function to_char Fontana Daniel C. \(Desartec S.R.L.\)
• 18:09   Re: function to_char Tom Lane
• 18:16   Re: BUG #16969: INSERT of multiple rows into GENERATED ALWAYS AS IDENTITY column with DEFAULT value is broken. Tom Lane

18 April 2021

• 17:53   websearch_to_tsquery() returns queries that don't match to_tsvector() Valentin Gatien-Baron

19 April 2021

• 03:23   Re: BUG #16959: Unnesting null from string_to_array silently removes whole rows from result Pete O'Such
• 05:45   BUG #16970: pgrouting_11-3.1.3-1.rhel8.x86_64.rpm is not signed PG Bug reporting form
• 16:27   Re: BUG #16970: pgrouting_11-3.1.3-1.rhel8.x86_64.rpm is not signed Devrim Gündüz
• 21:29   BUG #16971: Incompatible datalayout errors with llvmjit PG Bug reporting form
• 21:49   RE: BUG #16961: Could not access status of transaction Stepan Yankevych

20 April 2021

• 09:45   BUG #16972: parameter parallel_leader_participation's category problem PG Bug reporting form
• 10:17   BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header PG Bug reporting form
• 11:08   Re: BUG #16972: parameter parallel_leader_participation's category problem Bharath Rupireddy
• 13:34   BUG #16974: memory leak PG Bug reporting form
• 17:32   Re: BUG #16974: memory leak Tom Lane
• 18:27   BUG #16975: Not able to integrate and run Pgroonga Text search module PG Bug reporting form
• 21:48   Re: BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header Tom Lane
• 22:29   Re: BUG #16971: Incompatible datalayout errors with llvmjit Andres Freund

21 April 2021

• 00:42   Re: BUG #16971: Incompatible datalayout errors with llvmjit Tom Stellard
• 01:52   Re: BUG #16971: Incompatible datalayout errors with llvmjit Andres Freund
• 05:46   Re: BUG #16972: parameter parallel_leader_participation's category problem Michael Paquier
• 06:45   Re: BUG #16972: parameter parallel_leader_participation's category problem Bharath Rupireddy
• 12:05   Re: BUG #16974: memory leak RekGRpth
• 12:40   Re: postgres has no spinlock support on riscv rv64imafdc Thomas Munro
• 13:44   Re: BUG #16972: parameter parallel_leader_participation's category problem Michael Paquier
• 14:37   Re: BUG #16972: parameter parallel_leader_participation's category problem Bharath Rupireddy
• 15:39   BUG #16976: server crash when deleting via a trigger on a foreign table PG Bug reporting form
• 16:27   Re: BUG #16974: memory leak Tom Lane
• 16:40   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Tom Lane
• 17:08   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Herwig Goemans
• 22:10   Re: posgres 12 bug (partitioned table) Tom Lane
• 22:59   Re: posgres 12 bug (partitioned table) Andres Freund
• 23:51   Re: posgres 12 bug (partitioned table) Tom Lane

22 April 2021

• 00:12   Re: posgres 12 bug (partitioned table) Andres Freund
• 00:38   Re: posgres 12 bug (partitioned table) Tom Lane
• 00:48   Re: posgres 12 bug (partitioned table) Andres Freund
• 02:07   pg_cron leak memory bug, please help, thanks Yi Sun
• 03:57   Re: BUG #16972: parameter parallel_leader_participation's category problem Michael Paquier
• 04:02   Re: BUG #16972: parameter parallel_leader_participation's category problem Bharath Rupireddy
• 08:00   Re: BUG #16972: parameter parallel_leader_participation's category problem Michael Paquier
• 08:04   Re: BUG #16972: parameter parallel_leader_participation's category problem Bharath Rupireddy
• 13:09   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Herwig Goemans
• 13:52   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Michael Paquier
• 15:17   Re: posgres 12 bug (partitioned table) Amit Langote
• 16:12   BUG #16977: SET LC_TIME TO local_variable don't work PG Bug reporting form
• 16:20   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Herwig Goemans
• 16:24   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Tom Lane
• 16:42   Re: BUG #16977: SET LC_TIME TO local_variable don't work David G. Johnston
• 16:50   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Tom Lane
• 17:10   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Herwig Goemans
• 17:14   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Tom Lane
• 17:14   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Herwig Goemans
• 17:22   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Herwig Goemans
• 17:24   Bug in handling default privileges inside extension update scripts Mats Kindahl
• 17:49   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Tom Lane
• 17:51   Re: pg_cron leak memory bug, please help, thanks Devrim Gündüz
• 18:15   Re: Bug in handling default privileges inside extension update scripts Stephen Frost
• 18:41   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Clinton Adams
• 21:21   Re: posgres 12 bug (partitioned table) Tom Lane
• 21:31   Re: posgres 12 bug (partitioned table) Andres Freund
• 21:37   Re: posgres 12 bug (partitioned table) Tom Lane
• 21:57   Re: posgres 12 bug (partitioned table) Andres Freund
• 22:09   Re: posgres 12 bug (partitioned table) Tom Lane
• 22:54   Re: posgres 12 bug (partitioned table) Andres Freund
• 23:28   Re: posgres 12 bug (partitioned table) Tom Lane

23 April 2021

• 01:45   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Thomas Munro
• 03:13   BUG #16978: Nested CTEs give ERROR in v13 PG Bug reporting form
• 04:05   Re: posgres 12 bug (partitioned table) Amit Langote
• 04:50   Re: BUG #16967: Extremely slow update statement in trigger David Fetter
• 05:58   Re: BUG #16967: Extremely slow update statement in trigger Tom Lane
• 06:54   BUG #16979: WITH RECURSIVE SQL crashes v13.x PG Bug reporting form
• 09:42   Re: BUG #16974: memory leak RekGRpth
• 13:10   BUG #16980: invalid memory alloc request size PG Bug reporting form
• 13:54   BUG #16981: pg_dump errors out with incompatible option set but empty tar dump file is created as result PG Bug reporting form
• 16:36   BUG #16982: pg_rewind cannot deal with configuration files (postgresql.conf) located outside data directory PG Bug reporting form
• 17:08   Re: BUG #16978: Nested CTEs give ERROR in v13 Tom Lane
• 17:11   Re: BUG #16979: WITH RECURSIVE SQL crashes v13.x Tom Lane
• 17:56   Re: BUG #16978: Nested CTEs give ERROR in v13 Bruce Momjian
• 18:15   Re: XX000: iso-8859-1 type of jsonb container. Dmitry Dolgov
• 18:17   Re: BUG #16967: Extremely slow update statement in trigger Nicolas Burri
• 18:37   Re: BUG #16978: Nested CTEs give ERROR in v13 Tom Lane
• 21:03   Re: BUG #16978: Nested CTEs give ERROR in v13 Bruce Momjian

24 April 2021

• 08:59   Re: BUG #16980: invalid memory alloc request size Michael Paquier
• 17:54   Re: BUG #16980: invalid memory alloc request size Tom Lane

25 April 2021

• 14:57   Re: BUG #16939: Plural interval for negative singular Noah Misch

26 April 2021

• 11:55   Re: Bug in handling default privileges inside extension update scripts Mats Kindahl
• 13:14   BUG #16984: any version i install it says database cluster initialization failed PG Bug reporting form
• 16:06   Re: BUG #16984: any version i install it says database cluster initialization failed Mihir Pandya
• 16:40   Re: pg_restore - generated column - not populating Peter Eisentraut
• 19:31   Re: BUG #16939: Plural interval for negative singular Bruce Momjian
• 19:45   Re: BUG #16939: Plural interval for negative singular Tom Lane
• 20:02   Re: BUG #16939: Plural interval for negative singular Tom Lane
• 20:29   Re: Bug in handling default privileges inside extension update scripts Stephen Frost

27 April 2021

• 11:37   Re: Bug in handling default privileges inside extension update scripts Mats Kindahl
• 14:32   BUG #16985: ModifyWaitEvent function does not have pgsocket fd and void *user_data arguments PG Bug reporting form

28 April 2021

• 01:50   Re: BUG #16939: Plural interval for negative singular Alvaro Herrera
• 02:15   Re: BUG #16939: Plural interval for negative singular Gavin Flower
• 03:09   Re: BUG #16939: Plural interval for negative singular Tom Lane
• 03:59   Re: BUG #16985: ModifyWaitEvent function does not have pgsocket fd and void *user_data arguments Thomas Munro
• 06:43   Re: BUG #16939: Plural interval for negative singular Tom Lane
• 08:22   Re: BUG #16982: pg_rewind cannot deal with configuration files (postgresql.conf) located outside data directory Neil Chen
• 08:37   Re: BUG #16985: ModifyWaitEvent function does not have pgsocket fd and void *user_data arguments RekGRpth
• 13:52   ogr_fdw missing from /pub/repos/yum/13/fedora/fedora-34-x86_64/ Kieran McCusker
• 15:24   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Herwig Goemans
• 17:10   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Tom Lane
• 20:02   On update cascade failing when moving data between partitions Daniel Nicoletti
• 21:23   Re: Bug in handling default privileges inside extension update scripts Stephen Frost

29 April 2021

• 12:59   BUG #16986: reindex error on ltree index PG Bug reporting form
• 13:49   BUG #16988: Spurious "SET LOCAL can only be used in transaction blocks" warning using implicit transaction block PG Bug reporting form
• 15:04   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Herwig Goemans
• 19:03   Re: BUG #16988: Spurious "SET LOCAL can only be used in transaction blocks" warning using implicit transaction block Tom Lane
• 19:05   Re: BUG #16976: server crash when deleting via a trigger on a foreign table Tom Lane

30 April 2021

• 02:02   Re: ALTER CONSTRAINT on a partitioned FK isn't working Alvaro Herrera
• 05:04   syslogger file descriptor question chenyanfei
• 05:16   syslogger file descriptor question chenyanfei
• 11:58   BUG #16989: parameter track_commit_timestamp's category problem PG Bug reporting form
• 12:33   Re: BUG #16989: parameter track_commit_timestamp's category problem Bharath Rupireddy
• 14:02   Re: syslogger file descriptor question Magnus Hagander
• 20:56   Re: BUG #16908: Postgres (12) allows you (re)-attach partitions that violate Foreign Key constraints? Alvaro Herrera