pgsql-bugs - October 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

Oct. 1, 2022

Thread Author Time
Bug / Unintentional Feature: non-immutable functions can be used for generated columns. Shane Plesner 15:18
Re: Bug / Unintentional Feature: non-immutable functions can be used for generated columns. David G. Johnston 18:54
BUG #17626: Permission denied errors should list role as well as user PG Bug reporting form 21:09
Re: Bug / Unintentional Feature: non-immutable functions can be used for generated columns. Shane Plesner 21:44
Re: pg ignores wal files in pg_wal, and instead tries to load them from archive/primary Jeff Janes 21:44
Re: Bug / Unintentional Feature: non-immutable functions can be used for generated columns. Tom Lane 23:04

Oct. 3, 2022

Thread Author Time
Re: v15rc1 shadowbuild fails when using src from symlink Michael Paquier 08:41
Re: Translation bug in French starting in v13 Guillaume Lelarge 08:53
Re: BUG #17626: Permission denied errors should list role as well as user Tom Lane 13:50
Re: BUG #17626: Permission denied errors should list role as well as user David G. Johnston 15:40
Re: BUG #17626: Permission denied errors should list role as well as user Tom Lane 15:53
Re: BUG #17626: Permission denied errors should list role as well as user Loren Siebert 17:12
Re: BUG #17626: Permission denied errors should list role as well as user David G. Johnston 22:04

Oct. 4, 2022

Thread Author Time
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records 📎 Tom Lane 22:54
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records 📎 Tom Lane 23:53

Oct. 5, 2022

Thread Author Time
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records Nathan Bossart 00:15
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records Kyotaro Horiguchi 01:41
Re: BUG #17619: AllocSizeIsValid violation in parallel hash join 📎 Masahiko Sawada 04:56
Re: BUG #17578: undetected (on one side) deadlock with reindex CONCURRENTLY partitioned index vs drop index Noah Misch 10:46
Re: BUG #17616: Silently skipping to update data to the database with owner privileges using flyway scripts Noah Misch 11:02
WAL segments removed from primary despite the fact that logical replication slot needs it. hubert depesz lubaczewski 15:23
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records 📎 Tom Lane 15:30
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records Nathan Bossart 19:00

Oct. 6, 2022

Thread Author Time
Re:Re: Fwd: BUG #17017: Two versions of the same row of records are returned in one query 李可强 07:28
v15rc2(/v15rc1/v15b4) shadowbuild fails when using src from symlink Frank van Vugt 15:16
Re: Re: Fwd: BUG #17017: Two versions of the same row of records are returned in one query Peter Geoghegan 16:06
Re: v15rc2(/v15rc1/v15b4) shadowbuild fails when using src from symlink Alvaro Herrera 16:57

Oct. 7, 2022

Thread Author Time
Re: v15rc2(/v15rc1/v15b4) shadowbuild fails when using src from symlink Michael Paquier 01:06
Re: v15rc2(/v15rc1/v15b4) shadowbuild fails when using src from symlink Alvaro Herrera 06:38
Re: v15rc2(/v15rc1/v15b4) shadowbuild fails when using src from symlink Tom Lane 06:51
Re: [BUG] Crash of logical replica with trigger. Michael Paquier 07:24
Re: [BUG] Crash of logical replica with trigger. Masahiko Sawada 08:19
Re: [BUG] Crash of logical replica with trigger. Michael Paquier 08:40
Re: v15rc2(/v15rc1/v15b4) shadowbuild fails when using src from symlink Frank van Vugt 11:42
Re: BUG #17623: WHERE should be evaluated after FROM clause when operators may throw Stamatis Zampetakis 16:06
BUG #17629: PostgreSQL repository not working on RHEL 8.6 PG Bug reporting form 23:39

Oct. 9, 2022

Thread Author Time
BUG #17630: pg_dump error PG Bug reporting form 09:22
Re: BUG #17630: pg_dump error Christophe Pettus 22:20
Re: BUG #17630: pg_dump error Tom Lane 22:53
Default framing option RANGE adds cost for no gain to some window functions Erwin Brandstetter 23:45

Oct. 10, 2022

Thread Author Time
Re: Default framing option RANGE adds cost for no gain to some window functions David Rowley 04:21
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records Simon Riggs 12:24
BUG #17631: Prepare + Merge fails to identify parameter types PG Bug reporting form 17:14
Re: BUG #17631: Prepare + Merge fails to identify parameter types Tom Lane 20:53

Oct. 11, 2022

Thread Author Time
BUG #17632: a potential bug of memory leak PG Bug reporting form 02:33
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records Kyotaro Horiguchi 06:48
Re: BUG #17632: a potential bug of memory leak Japin Li 09:12
BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. PG Bug reporting form 09:27
Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. Richard Guo 10:05
Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. Richard Guo 12:09
Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. 📎 Japin Li 12:29
Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. Richard Guo 13:16
BUG #17634: Inconsistent view_definition in information_schema.views PG Bug reporting form 13:32
Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. Japin Li 14:35
Re: BUG #17634: Inconsistent view_definition in information_schema.views Tom Lane 14:58
Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. Tom Lane 15:07
Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. 📎 Tom Lane 15:37
RE: BUG #17634: Inconsistent view_definition in information_schema.views Blum, Kimber 15:57
Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error. 📎 Japin Li 16:16
BUG #17635: The behavior of quote_ident differs from what the doc specifies PG Bug reporting form 18:28
Re: BUG #17635: The behavior of quote_ident differs from what the doc specifies Tom Lane 19:51

Oct. 12, 2022

Thread Author Time
BUG #17636: terminating connection because of crash of another server process PG Bug reporting form 11:22

Oct. 13, 2022

Thread Author Time
BUG #17637: case-when branches taken even if they dont match, raising errors PG Bug reporting form 02:30
Re: BUG #17637: case-when branches taken even if they dont match, raising errors Richard Guo 11:30
Re: BUG #17637: case-when branches taken even if they dont match, raising errors Tom Lane 14:26
Re: Default framing option RANGE adds cost for no gain to some window functions Erwin Brandstetter 15:22
BUG #17638: Versioning Policy page appears incorrect PG Bug reporting form 16:10
Re: BUG #17638: Versioning Policy page appears incorrect Magnus Hagander 17:50
BUG #17639: Failed to download packages: python3-humanize-3.13.1-42.rhel8.noarch: Cannot download, all mirrors w PG Bug reporting form 18:10
Re: BUG #17637: case-when branches taken even if they dont match, raising errors Facundo Etchezar 20:11

Oct. 14, 2022

Thread Author Time
BUG #17640: fork off the requested timeline before the switchpoint. PG Bug reporting form 05:21
Re: BUG #17637: case-when branches taken even if they dont match, raising errors David G. Johnston 13:28

Oct. 15, 2022

Thread Author Time
Re: BUG #17640: fork off the requested timeline before the switchpoint. Michael Paquier 02:47
BUG #17641: postgresql service persistently restarts because "could not open shared memory segment" PG Bug reporting form 18:31

Oct. 16, 2022

Thread Author Time
Re: BUG #17641: postgresql service persistently restarts because "could not open shared memory segment" Thomas Munro 03:31
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. Amit Kapila 05:05
BUG #17644: EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST PG Bug reporting form 16:50
Re: BUG #17641: postgresql service persistently restarts because "could not open shared memory segment" Thomas Munro 21:05
Re: BUG #17641: postgresql service persistently restarts because "could not open shared memory segment" Andres Freund 21:11
Re: BUG #17644: EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST Tom Lane 23:21
BUG #17645: Strange queries that stuck in database system PG Bug reporting form 23:43

Oct. 17, 2022

Thread Author Time
Re: BUG #17637: case-when branches taken even if they dont match, raising errors Facundo Etchezar 01:14
Re: BUG #17636: terminating connection because of crash of another server process Julien Rouhaud 03:49
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. Kyotaro Horiguchi 06:53
Re: BUG #17645: Strange queries that stuck in database system Julien Rouhaud 08:15
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. hubert depesz lubaczewski 09:13
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. hubert depesz lubaczewski 09:14
BUG #17646: create rule named "_RETURN" will cause pg core PG Bug reporting form 12:03
Re: BUG #17646: create rule named "_RETURN" will cause pg core Tom Lane 14:17
BUG #17647: 12.12 package has difference on ubuntu 18.04 PG Bug reporting form 14:18
Re: BUG #17646: create rule named "_RETURN" will cause pg core Ilya Anfimov 14:33
Re: BUG #17646: create rule named "_RETURN" will cause pg core Ilya Anfimov 14:38
Re: BUG #17646: create rule named "_RETURN" will cause pg core Tom Lane 14:41
Re: BUG #17646: create rule named "_RETURN" will cause pg core Ilya Anfimov 15:15

Oct. 18, 2022

Thread Author Time
Aw: BUG #17647: 12.12 package has difference on ubuntu 18.04 📎 Mike Fröhner 08:19
BUG #17649: With libpg5 15.0 psql 10.22 uses HOME variable instead of uid and /etc/passwd to select .pgpass file PG Bug reporting form 09:17
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. Amit Kapila 11:21
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. Amit Kapila 11:27
Re: Aw: BUG #17647: 12.12 package has difference on ubuntu 18.04 Julien Rouhaud 12:44
BUG #17650: For the sixth time, the clipping function in the 120 partition table planning stage fails PG Bug reporting form 13:11
Re:  BUG #17647: 12.12 package has difference on ubuntu 18.04 Julien Rouhaud 13:25
Re: BUG #17649: With libpg5 15.0 psql 10.22 uses HOME variable instead of uid and /etc/passwd to select .pgpass file Julien Rouhaud 13:29
Re: BUG #17650: For the sixth time, the clipping function in the 120 partition table planning stage fails Julien Rouhaud 13:50
Re: BUG #17650: For the sixth time, the clipping function in the 120 partition table planning stage fails Tom Lane 14:05
Aw: Re:  BUG #17647: 12.12 package has difference on ubuntu 18.04 Mike Fröhner 18:13
Re: Aw: Re:  BUG #17647: 12.12 package has difference on ubuntu 18.04 Tom Lane 21:07

Oct. 19, 2022

Thread Author Time
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. Kyotaro Horiguchi 02:00
Re: BUG #17650: For the sixth time, the clipping function in the 120 partition table planning stage fails Andy Fan 02:21
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. Amit Kapila 09:46
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. hubert depesz lubaczewski 10:02
BUG #17651: Possible optimization for sort on not nullable field (indexed) PG Bug reporting form 10:16
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. hubert depesz lubaczewski 10:20
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. Amit Kapila 10:44
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. hubert depesz lubaczewski 11:09
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. hubert depesz lubaczewski 11:11
Re: BUG #17651: Possible optimization for sort on not nullable field (indexed) Julien Rouhaud 12:51
Documentation error Ian R. Campbell 13:57
BUG #17652: Performance degradation after migrating from v13.4 to v14.4 PG Bug reporting form 16:11
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Jeff Janes 17:09
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Michael Guissine 17:30
BUG #17653: Bad handling of NUMERIC data type using ODBC driver version 13.2 PG Bug reporting form 18:18
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Andres Freund 18:46
Re: BUG #17624: Creating database is non-ending execution. Andres Freund 18:47
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 📎 Jeff Janes 19:00
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Michael Guissine 19:32
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Michael Guissine 19:44
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Andres Freund 20:12
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Peter Geoghegan 20:20
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Andres Freund 20:35
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Michael Guissine 22:30

Oct. 20, 2022

Thread Author Time
Re: Documentation error Richard Guo 03:32
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Jeff Janes 05:03
Re: WAL segments removed from primary despite the fact that logical replication slot needs it. hubert depesz lubaczewski 11:55
BUG #17655: crash postgres by query PG Bug reporting form 14:16
Re: BUG #17655: crash postgres by query Julien Rouhaud 14:50
BUG #17657: Documentation links color PG Bug reporting form 14:57
Re: BUG #17655: crash postgres by query Tom Lane 14:57
BUG #17658: Download release 15 without success PG Bug reporting form 15:06
Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 Michael Guissine 19:29

Oct. 21, 2022

Thread Author Time
Re: Documentation error Richard Guo 01:05
BUG #17659: error in rpmbuild when compiling psql PG Bug reporting form 15:49
Delete from table where id in (bugged query) - fully remove all data without any notice. Kostya M 19:06
Re: Delete from table where id in (bugged query) - fully remove all data without any notice. Pantelis Theodosiou 21:08
Re: Delete from table where id in (bugged query) - fully remove all data without any notice. Pantelis Theodosiou 23:22

Oct. 22, 2022

Thread Author Time
BUG #17660: JSONPATH issue using like_regex followed by the && operator PG Bug reporting form 11:55
Re: BUG #17660: JSONPATH issue using like_regex followed by the && operator Tom Lane 13:48
BUG #17661: Nothing provides 'libselinux.so.1(LIBSELINUX_1.0)(64bit) PG Bug reporting form 14:31

Oct. 23, 2022

Thread Author Time
Re: BUG #17660: JSONPATH issue using like_regex followed by the && operator Shahar Belizon 07:56
Re: BUG #17660: JSONPATH issue using like_regex followed by the && operator Tom Lane 15:31

Oct. 24, 2022

Thread Author Time
BUG #17662: Error on UPDATE with () PG Bug reporting form 17:04

Oct. 25, 2022

Thread Author Time
Re: BUG #17662: Error on UPDATE with () Tom Lane 14:13

Oct. 26, 2022

Thread Author Time
generated columns bug, see inconsistent data 📎 Jeff Janes 00:58
Re: generated columns bug, see inconsistent data Tom Lane 01:35
BUG #17663: Connect to the database through jdbc, call the stored procedure containing the rollback statement, PG Bug reporting form 08:59
BUG #17664: The subsctring() function with the char() text type does not work correctly PG Bug reporting form 09:00

Oct. 27, 2022

Thread Author Time
BUG #17665: pg_stat_statements useless with variable number of parameters in IN close PG Bug reporting form 10:42
BUG #17666: Unexpected shutdown PG Bug reporting form 11:37
Re: BUG #17664: The subsctring() function with the char() text type does not work correctly David G. Johnston 12:31
BUG #17667: to_char is used to collect statistics by week PG Bug reporting form 12:43
Re: BUG #17665: pg_stat_statements useless with variable number of parameters in IN close Julien Rouhaud 12:58
Re: BUG #17667: to_char is used to collect statistics by week Japin Li 12:59
Re: BUG #17666: Unexpected shutdown Tom Lane 13:22
BUG #17668: Query normalization generates multiple queryId:s for calls to the same procedure PG Bug reporting form 13:49
Re: BUG #17668: Query normalization generates multiple queryId:s for calls to the same procedure Julien Rouhaud 16:08
PostrgreSQL 15 installation 📎 Παναγιώτης Ρουσάλης 18:02
Re: BUG #17668: Query normalization generates multiple queryId:s for calls to the same procedure Tom Lane 18:28
BUG #17669: Invalid TOAST pointer in PL/pgSQL variable PG Bug reporting form 19:45

Oct. 28, 2022

Thread Author Time
Re: BUG #17668: Query normalization generates multiple queryId:s for calls to the same procedure Julien Rouhaud 01:28
Re: BUG #17668: Query normalization generates multiple queryId:s for calls to the same procedure Marcus Kempe 04:48
Re: BUG #17668: Query normalization generates multiple queryId:s for calls to the same procedure Alexey Ermakov 07:42
BUG #17670: Logical Replication data may be lost on the subscription under certain scenarios PG Bug reporting form 07:48
Re: BUG #17669: Invalid TOAST pointer in PL/pgSQL variable Tom Lane 13:43
Re: BUG #17669: Invalid TOAST pointer in PL/pgSQL variable Sergey Shinderuk 14:16
Re: BUG #17670: Logical Replication data may be lost on the subscription under certain scenarios Japin Li 14:36

Oct. 30, 2022

Thread Author Time
Re: BUG #17670: Logical Replication data may be lost on the subscription under certain scenarios Dilip Kumar 06:39
Problem with Avg function and Money type in PostgreSQL 15 Erki Eessaar 10:15
Re: BUG #17670: Logical Replication data may be lost on the subscription under certain scenarios Japin Li 13:52
Memory leak on subquery as scalar operand Lauri Laanmets 17:13
Re: Problem with Avg function and Money type in PostgreSQL 15 Tom Lane 17:57
Re: Problem with Avg function and Money type in PostgreSQL 15 Erki Eessaar 19:10

Oct. 31, 2022

Thread Author Time
BUG #17671: Query returns unexpected result PG Bug reporting form 05:15
BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility PG Bug reporting form 07:36
BUG #17673: Regression tests failed with llvm 11+ when using address sanitizers PG Bug reporting form 08:42
Re: BUG #17670: Logical Replication data may be lost on the subscription under certain scenarios Dilip Kumar 08:53
Re: BUG #17671: Query returns unexpected result Kieran McCusker 10:07
Re: BUG #17671: Query returns unexpected result Japin Li 10:40
Re: BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility Christoph Berg 12:18
Re: Memory leak on subquery as scalar operand Tom Lane 13:40
Re: Memory leak on subquery as scalar operand Lauri Laanmets 14:16
Strange sort node/explain result 📎 Gunnar "Nick" Bluth 14:20
Re: Strange sort node/explain result David Rowley 20:40
Re: Memory leak on subquery as scalar operand David Rowley 23:20

Browse Archives

Prev | Next