PostgreSQL 15.2 ソフトウェア情報交換

What's new in this version:

Fixed:
- Fix for partitioned tables to correctly update GENERATED columns in child tables if the GENERATED column does not exist in the parent table or the child generated column has different dependencies than the parent
- Fix an issue with bulk insertions on foreign tables that could lead to logical inconsistencies, for example, a BEFORE ROW trigger may not process rows that should be available
- Fix for jsonb subscripting that come directly from a text column in a table
- Fix issue to allow column lists longer than 100 when using logical replication
- Fix for statistics collection to correctly handle when a relation changes type (e.g. a table is converted to a view)
- Fix deadlock between DROP DATABASE and logical replication worker process
- Fix small session-lifespan memory leak when CREATE SUBSCRIPTION fails its connection attempt
- Fix the default logical replication plug-in, pgoutput, to not send columns that are not listed in a table's replication column list
- Fix possible corruption of very large tablespace map files in pg_basebackup
- Fix the psql commands sf and ef to handle SQL-language functions that have SQL-standard function bodies (i.e. BEGIN ATOMIC)
- Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA
- Fix the seg extension to not crash or print garbage if an input number has more than 127 digits
- Several fixes for the MERGE command

- Allow a WITH RECURSIVE ... CYCLE query to access its SET output column
- Reject uses of undefined variables in jsonpath existence checks
- Honor updated values of checkpoint_completion_target on reload
- Log the correct ending timestamp in recovery_target_xid mode
- Prevent "wrong tuple length" failure at the end of VACUUM
- Avoid an immediate commit after ANALYZE when using query pipelining
- Several fixes to the query planner, including one that provides more opportunities for using memoization with partitionwise joins
- Ensure full text search queries can be cancelled while performing phrase matches
- Performance improvement for replicas with hot_standby enabled that are processing SELECT queries
- Several fixes for logical decoding that improve its stability and bloat handling
- Remove a harmless warning from pg_dump in --if-exists mode when the public schema has a non-default owner
- Update the pageinspect extension to mark its disk-accessing functions as PARALLEL RESTRICTED