pgsql: C11 alignas instead of unions -- extended alignments

2025-11-23 Thread Peter Eisentraut
C11 alignas instead of unions -- extended alignments This replaces some uses of pg_attribute_aligned() with the standard alignas() for cases where extended alignment (larger than max_align_t) is required. This patch stipulates that all supported compilers must support alignments up to PG_IO_ALIGN

pgsql: pg_buffercache: Add pg_buffercache_os_pages

2025-11-23 Thread Michael Paquier
pg_buffercache: Add pg_buffercache_os_pages ba2a3c2302f has added a way to check if a buffer is spread across multiple pages with some NUMA information, via a new view pg_buffercache_numa that depends on pg_buffercache_numa_pages(), a SQL function. These can only be queried when support for libnu

pgsql: Fix incorrect IndexOptInfo header comment

2025-11-23 Thread David Rowley
Fix incorrect IndexOptInfo header comment The comment incorrectly indicated that indexcollations[] stored collations for both key columns and INCLUDE columns, but in reality it only has elements for the key columns. canreturn[] didn't get a mention, so add that while we're here. Author: Junwang

pgsql: Fix incorrect IndexOptInfo header comment

2025-11-23 Thread David Rowley
Fix incorrect IndexOptInfo header comment The comment incorrectly indicated that indexcollations[] stored collations for both key columns and INCLUDE columns, but in reality it only has elements for the key columns. canreturn[] didn't get a mention, so add that while we're here. Author: Junwang

pgsql: Fix incorrect IndexOptInfo header comment

2025-11-23 Thread David Rowley
Fix incorrect IndexOptInfo header comment The comment incorrectly indicated that indexcollations[] stored collations for both key columns and INCLUDE columns, but in reality it only has elements for the key columns. canreturn[] didn't get a mention, so add that while we're here. Author: Junwang

pgsql: Fix incorrect IndexOptInfo header comment

2025-11-23 Thread David Rowley
Fix incorrect IndexOptInfo header comment The comment incorrectly indicated that indexcollations[] stored collations for both key columns and INCLUDE columns, but in reality it only has elements for the key columns. canreturn[] didn't get a mention, so add that while we're here. Author: Junwang

pgsql: Fix incorrect IndexOptInfo header comment

2025-11-23 Thread David Rowley
Fix incorrect IndexOptInfo header comment The comment incorrectly indicated that indexcollations[] stored collations for both key columns and INCLUDE columns, but in reality it only has elements for the key columns. canreturn[] didn't get a mention, so add that while we're here. Author: Junwang

pgsql: Fix incorrect IndexOptInfo header comment

2025-11-23 Thread David Rowley
Fix incorrect IndexOptInfo header comment The comment incorrectly indicated that indexcollations[] stored collations for both key columns and INCLUDE columns, but in reality it only has elements for the key columns. canreturn[] didn't get a mention, so add that while we're here. Author: Junwang

pgsql: Issue a NOTICE if a created function depends on any temp objects

2025-11-23 Thread Tom Lane
Issue a NOTICE if a created function depends on any temp objects. We don't have an official concept of temporary functions. (You can make one explicitly in pg_temp, but then you have to explicitly schema-qualify it on every call.) However, until now we were quite laissez-faire about whether a no

pgsql: psql: Improve tab-completion for PREPARE.

2025-11-23 Thread Fujii Masao
psql: Improve tab-completion for PREPARE. This commit enhances tab-completion for PREPARE xx AS to also suggest MERGE INTO, VALUES, WITH, and TABLE. Author: Haruna Miwa Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/ty7p286mb5466b859bd6c5be64e961878f1...@ty7p286mb5466.jpnp286.prod.ou