pgsql-bugs - May 2022

If you find a bug, please use the bug reporting form.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

May 1, 2022

Thread Author Time
Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1) David G. Johnston 15:58
Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1) Tom Lane 17:08
Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1) David G. Johnston 19:34
Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1) Tom Lane 19:46

May 2, 2022

Thread Author Time
Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1) 📎 David G. Johnston 02:22
Implicitly created operator family not listed by pg_event_trigger_ddl_commands LEMAIRE Leslie - SG/SNUM/UNI/DRC (Chargée de mission) 11:27
postgresql11-11.14-1PGDG.rhel8.x86_64.rpm reports incorrect name Miller, Mark - Xylem 13:55

May 3, 2022

Thread Author Time
bug in postgres 14.2 Van Droogenbroeck David 08:17
Fw: bug in postgres 14.2 Van Droogenbroeck David 08:41
Types pollution with unknown oids and server-side parameters binding Daniele Varrazzo 19:10
Re: Types pollution with unknown oids and server-side parameters binding Tom Lane 19:55
Re: Types pollution with unknown oids and server-side parameters binding David G. Johnston 20:31
Re: Types pollution with unknown oids and server-side parameters binding Tom Lane 22:18
Re: Types pollution with unknown oids and server-side parameters binding Daniele Varrazzo 22:35
Re: Types pollution with unknown oids and server-side parameters binding David G. Johnston 23:06
Re: Types pollution with unknown oids and server-side parameters binding Tom Lane 23:17
Re: Types pollution with unknown oids and server-side parameters binding Daniele Varrazzo 23:48

May 4, 2022

Thread Author Time
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Alvaro Herrera 10:17
pg_upgrade (12->14) fails on aggregate Petr Vejsada 13:05
Re: pg_upgrade (12->14) fails on aggregate David G. Johnston 14:34
Re: Query generates infinite loop Jeff Janes 19:01
Re: Query generates infinite loop Tom Lane 19:24

May 5, 2022

Thread Author Time
BUG #17474: Segmentation fault from INSERT ( JumbleExpr ) PG Bug reporting form 12:10
Re: BUG #17474: Segmentation fault from INSERT ( JumbleExpr ) Tom Lane 13:44
Re: BUG #17474: Segmentation fault from INSERT ( JumbleExpr ) Victor Yegorov 14:34
Re: BUG #17474: Segmentation fault from INSERT ( JumbleExpr ) Tom Lane 15:12
Security Definer functions no longer works in PG14+ Jobin Augustine 15:49
Re: Security Definer functions no longer works in PG14+ Jan Katins 18:31

May 6, 2022

Thread Author Time
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands 📎 Masahiko Sawada 05:26
Re: Security Definer functions no longer works in PG14+ Jobin Augustine 05:37
Re: Security Definer functions no longer works in PG14+ Andrew Borodin 06:21
Re: Security Definer functions no longer works in PG14+ David G. Johnston 06:32
Re: Security Definer functions no longer works in PG14+ Andrew Borodin 06:51
Re: Security Definer functions no longer works in PG14+ Pavel Stehule 06:57

May 7, 2022

Thread Author Time
Re: Security Definer functions no longer works in PG14+ Amit Kapila 10:22

May 8, 2022

Thread Author Time
Re: Security Definer functions no longer works in PG14+ Jobin Augustine 07:03
BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) PG Bug reporting form 22:11

May 9, 2022

Thread Author Time
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Tom Lane 00:22
Re: Query generates infinite loop Corey Huinker 03:44
Re: Query generates infinite loop Tom Lane 04:02
Re: Security Definer functions no longer works in PG14+ Amit Kapila 04:08
Re: Query generates infinite loop Corey Huinker 06:19
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Miloš Urbánek 07:21
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Pavel Stehule 08:21
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Miloš Urbánek 08:35
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Miloš Urbánek 08:39
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Miloš Urbánek 08:52
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Miloš Urbánek 08:59
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Pavel Stehule 09:50
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Miloš Urbánek 10:02
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Pavel Stehule 10:25
BUG #17477: A crash bug in transformValuesClause() PG Bug reporting form 10:28
Re: BUG #17477: A crash bug in transformValuesClause() Masahiko Sawada 14:03
Re: BUG #17477: A crash bug in transformValuesClause() 📎 Tom Lane 15:25
BUG #17478: Missing documents in the index after CREATE INDEX CONCURRENTLY (but existing in the table) PG Bug reporting form 15:28
Re: BUG #17478: Missing documents in the index after CREATE INDEX CONCURRENTLY (but existing in the table) Maxim Boguk 16:24
Re: BUG #17478: Missing documents in the index after CREATE INDEX CONCURRENTLY (but existing in the table) Tom Lane 16:32
Re: Query generates infinite loop Tom Lane 16:42
Re: BUG #17477: A crash bug in transformValuesClause() Jonathan S. Katz 17:20
Re: BUG #17477: A crash bug in transformValuesClause() Tom Lane 17:42
Re: BUG #17477: A crash bug in transformValuesClause() Masahiko Sawada 18:15
Re: BUG #17477: A crash bug in transformValuesClause() Tom Lane 18:33
Re: BUG #17477: A crash bug in transformValuesClause() Alvaro Herrera 20:55
Re: BUG #17477: A crash bug in transformValuesClause() Tom Lane 21:08
Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) Miloš Urbánek 23:26

May 10, 2022

Thread Author Time
BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery PG Bug reporting form 01:02
BUG #17480: Assertion failure in parse_relation.c PG Bug reporting form 08:21
Re: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery Richard Guo 10:07
Re: BUG #17480: Assertion failure in parse_relation.c Alvaro Herrera 10:50
Re: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery Richard Guo 11:05
Re: BUG #17478: Missing documents in the index after CREATE INDEX CONCURRENTLY (but existing in the table) Stefan Pastrilov 18:17
Re: Query generates infinite loop Corey Huinker 23:24
Re: Query generates infinite loop Tom Lane 23:42

May 11, 2022

Thread Author Time
Re: BUG #17480: Assertion failure in parse_relation.c Tom Lane 00:04
Posgresql-13 Bug (idle_in_transaction_session_timeout) Ram Pratap Maurya 07:52
Re: Posgresql-13 Bug (idle_in_transaction_session_timeout) Masahiko Sawada 08:35
RE: Posgresql-13 Bug (idle_in_transaction_session_timeout) Ram Pratap Maurya 09:19
Re: Posgresql-13 Bug (idle_in_transaction_session_timeout) Masahiko Sawada 11:45
Re: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery Tom Lane 23:11

May 12, 2022

Thread Author Time
Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" Devrim Gündüz 06:07
Re: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery Richard Guo 07:51
Re: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery Tom Lane 14:51

May 13, 2022

Thread Author Time
Negative value of numGroups Andrey Lepikhov 06:56

May 14, 2022

Thread Author Time
Re: Statistics updates is delayed when using `commit and chain` 📎 Laetitia Avrot 15:11

May 15, 2022

Thread Author Time
BUG #17481: sometime pg_stat_statements coredump PG Bug reporting form 02:37
Re: BUG #17480: Assertion failure in parse_relation.c 📎 Alvaro Herrera 10:42

May 16, 2022

Thread Author Time
Re: postgresql11-11.14-1PGDG.rhel8.x86_64.rpm reports incorrect name Devrim Gündüz 01:05
Re: BUG #17469: postgresql-11.service file not configured to match setup/initdb options specified Devrim Gündüz 01:07
Re: BUG #17470: Installation error Devrim Gündüz 01:09
BUG #17482: make world get error PG Bug reporting form 03:07
Regarding postgresql installation on Google Cloud [Error] 김범승 06:02
Re: BUG #17480: Assertion failure in parse_relation.c Richard Guo 06:39
BUG #17483: postgres_fdw used with text to_tsvector and custom search configuration PG Bug reporting form 09:25
Re: Regarding postgresql installation on Google Cloud [Error] Magnus Hagander 11:38
Re: BUG #17482: make world get error Tom Lane 14:38
Re: BUG #17483: postgres_fdw used with text to_tsvector and custom search configuration Tom Lane 14:49
Re: BUG #17481: sometime pg_stat_statements coredump Tom Lane 15:21
RE: [EXT] Re: BUG #17469: postgresql-11.service file not configured to match setup/initdb options specified Joe Hebert (jhebert) 18:48
pg_rewind fails to detect timeline change James Coleman 21:02
Re: BUG #17481: sometime pg_stat_statements coredump Michael Paquier 23:52

May 17, 2022

Thread Author Time
Re: Negative value of numGroups 📎 Andrey Lepikhov 12:59
Re: Negative value of numGroups Tom Lane 15:34

May 18, 2022

Thread Author Time
BUG #17484: Query does not prune partitions correctly PG Bug reporting form 09:37
BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY PG Bug reporting form 10:42
Re: BUG #17484: Query does not prune partitions correctly David Rowley 10:54
Re: BUG #17484: Query does not prune partitions correctly Damir Ciganović-Janković 11:22

May 19, 2022

Thread Author Time
About pg_basebackup 菊池祐 03:35
Re: About pg_basebackup David G. Johnston 03:46
Re: About pg_basebackup 菊池祐 04:14
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin 04:22
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier 04:32
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Петър Славов 05:24
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Петър Славов 06:23
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier 08:02
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Michael Paquier 08:56
Re: Negative value of numGroups 📎 Andrey Lepikhov 09:03
BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. PG Bug reporting form 12:03
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera 12:03
BUG #17487: Parallel execution fails when original user is removed PG Bug reporting form 18:46
Re: BUG #17449: Disk space not released Giorgio Saviane 20:15
Re: BUG #17487: Parallel execution fails when original user is removed Tom Lane 20:47
Re: BUG #17487: Parallel execution fails when original user is removed Kirill Kravtsov 23:08

May 20, 2022

Thread Author Time
Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640 Suralkar, Yogendra (Yogendra) 05:53
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Amit Kapila 08:51
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands 📎 Alvaro Herrera 10:34
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Michael Paquier 10:49
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Alvaro Herrera 10:57
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Masahiko Sawada 11:36
Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. Daniel Gustafsson 12:51
BUG #17490: unconsistency between TRUNCATE RESTART IDENTITY and setval() PG Bug reporting form 13:13
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Alvaro Herrera 14:12
Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. Tom Lane 14:34
Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640 Tom Lane 14:49
Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. Daniel Gustafsson 15:07
Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. 📎 Tom Lane 15:19
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands 📎 Alvaro Herrera 15:23
Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. 📎 Tom Lane 17:05
Re: BUG #17478: Missing documents in the index after CREATE INDEX CONCURRENTLY (but existing in the table) Andrey Borodin 18:44
Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. Daniel Gustafsson 19:06

May 21, 2022

Thread Author Time
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Michael Paquier 03:14
Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Masahiko Sawada 04:27
Re: Negative value of numGroups Tom Lane 17:15
Re: BUG #17449: Disk space not released Jeff Janes 18:12
Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. Tom Lane 18:47

May 23, 2022

Thread Author Time
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY 📎 Michael Paquier 05:40
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera 08:07
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin 09:02
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY 📎 Andrey Borodin 10:49
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY 📎 Andrey Borodin 13:06
BUG #17491: PgAgent keeps failing PG Bug reporting form 17:51
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan 18:13
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan 18:18

May 24, 2022

Thread Author Time
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier 01:08
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier 01:20
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan 02:19
How is this possible "publication does not exist" 📎 operations i 02:20
Fwd: How is this possible "publication does not exist" 📎 operations i 02:34
Re: BUG #17491: PgAgent keeps failing John Naylor 03:41
Re: How is this possible "publication does not exist" Amit Kapila 04:13
BUG #17492: error MSB4126: The specified solution configuration "Release|arm64" is invalid PG Bug reporting form 08:19
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera 09:02
Re: How is this possible "publication does not exist" Amit Kapila 09:38
Use of signal-unsafe functions from signal handlers 📎 Mats Kindahl 09:42
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin 10:08
Re: Use of signal-unsafe functions from signal handlers Julien Rouhaud 10:14
Re: BUG #17492: error MSB4126: The specified solution configuration "Release|arm64" is invalid Juan José Santamaría Flecha 11:00
BUG #17494: High demand for displacement sort PG Bug reporting form 11:04
Re: Use of signal-unsafe functions from signal handlers Mats Kindahl 12:10
Re: Use of signal-unsafe functions from signal handlers Julien Rouhaud 12:37
Re: Use of signal-unsafe functions from signal handlers Tom Lane 14:15
BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function PG Bug reporting form 16:17
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund 16:37
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan 17:38
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund 18:15
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund 18:37
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin 18:38
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund 18:46
BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes PG Bug reporting form 18:56
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund 19:01
Re: BUG #17494: High demand for displacement sort Jeff Janes 19:44
Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes Jeff Janes 19:55
Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640 📎 Tom Lane 20:05
Re: BUG #17496: to_char function resets if interval exceeds 23 hours 59 minutes Nathan Bossart 20:11
Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640 David Steele 20:33
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Greg Stark 21:11
BUG #17497: Data directory has been changed to default PG Bug reporting form 21:50
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund 22:24

May 25, 2022

Thread Author Time
Re: BUG #17492: error MSB4126: The specified solution configuration "Release|arm64" is invalid Michael Paquier 00:37
Re: Use of signal-unsafe functions from signal handlers Michael Paquier 00:45
Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function Michael Paquier 00:51
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier 00:59
Re: Use of signal-unsafe functions from signal handlers Andres Freund 01:01
Re: Use of signal-unsafe functions from signal handlers Tom Lane 01:25
Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function David Rowley 02:17
Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function Richard Guo 02:35
Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function Richard Guo 03:22
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin 04:00
Re: How is this possible "publication does not exist" 📎 operations i 04:02
Re: How is this possible "publication does not exist" Amit Kapila 04:09
Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund 04:20

Browse Archives

Prev | Next