master
tests: Restrict pg_locks queries in advisory_locks.sql to current database
Improve overflow/underflow handling in regr_intercept().
SQL Property Graph Queries (SQL/PGQ)
Extend ALTER OPERATOR to allow setting more optimization attributes.
Refactor some code around ALTER TABLE [NO] INHERIT
Add support for nearest-neighbor (KNN) searches to SP-GiST
Guard against unexpected dimensions of oidvector/int2vector.
Add new function pg_notification_queue_usage.
Optimize pg_popcount() with AVX-512 instructions.
Fix bitmapheapscan incorrect recheck of NULL tuples
Add tests for int4_bool() in int.c
Rework pg_input_error_message(), now renamed pg_input_error_info()
Set query ID in parallel workers for vacuum, BRIN and btree
BRIN bloom indexes
Enable BUFFERS with EXPLAIN ANALYZE by default
Make row compares robust during nbtree array scans.
Fix NULLIF()'s handling of read-write expanded objects.
Clean up ancient test style
Cover additional errors and corner conditions in repack.c
Consider opfamily and collation when removing redundant GROUP BY columns
Remove read-only server settings lc_collate and lc_ctype
Introduce "builtin" collation provider.
Fix INITCAP() word boundaries for PG_UNICODE_FAST.
Fix collate.windows.win1252 test.
Sanitize the term "combo CID" in code comments
Implement nested block comments in the backend and in psql. Include updates for the comment.sql regression test. Implement SET SESSION CHARACTERISTICS and SET DefaultXactIsoLevel. Implement SET SESSION CHARACTERISTICS TRANSACTION COMMIT and SET AutoCommit in the parser only. Need to add code to actually do something. Implement WITHOUT TIME ZONE type qualifier. Define SCHEMA keyword, along with stubbed-out grammar. Implement "[IN|INOUT|OUT] [varname] type" function arguments in parser only; INOUT and OUT throws an elog(ERROR). Add PATH as a type-specific token, since PATH is in SQL99 to support schema resource search and resolution.
Split regression tests for TOAST compression methods into two files
Add more tests for corrupted data with pglz_decompress()
Prevent setting NO INHERIT on partitioned NOT NULL constraints
Remove MULE_INTERNAL encoding.
Fix attribute mapping for COPY TO on partitioned tables.
Fix COPY FROM ON_ERROR SET_NULL with selective column list
Fix wrong assertion and poor error messages in "COPY (query) TO".
Apply encoding conversion in COPY TO FORMAT JSON
psql: Show all query results by default
Introduce "anycompatible" family of polymorphic types.
Fix dependency of partitioned table and table AM with CREATE TABLE .. USING
Record dependencies of a cast on other casts that it requires.
Rename create_function_N test scripts for clarity.
Issue a NOTICE if a created function depends on any temp objects.
doc: Clarify that empty COMMENT string removes the comment.
Add a planner support function for starts_with().
Rearrange core regression tests to reduce cross-script dependencies.
Provide more-specific error details/hints for function lookup failures.
Fix failure with SQL-procedure polymorphic output arguments in v12.
Handle element label and label property objects in object address functions
Support more object types within CREATE SCHEMA.
Avoid name collision with NOT NULL constraints
Fix attnum remapping in generateClonedExtStatsStmt()
Add test scaffolding for soft error reporting from input functions.
Improve detection of implicitly-temporary views.
Replace tests of ALTER DATABASE RESET TABLESPACE.
Fix various overflow hazards in date and timestamp functions.
Fix incorrect return value for pg_size_pretty(bigint)
Regression tests for TOAST.
Reintroduce MAINTAIN privilege and pg_maintain predefined role.
Prevent creation of duplicate not-null constraints for domains
Introduce the 'force' option for the Drop Database command.
Fix DROP OPERATOR to reset oprcom/oprnegate links to the dropped operator.
Fix eager aggregation for semi/antijoin inner rels
Improve error message for duplicate labels when creating an enum type.
Implement Self-Join Elimination
Code coverage for most pg_mblen* calls.
Remove the flaky check in event_trigger_login regression test
Add EXPLAIN (IO) instrumentation for SeqScan
Fix incorrect logic for hashed IN / NOT IN with non-strict operators
Revert "Enable fast default for domains with non-volatile constraints"
Avoid depending on post-UPDATE row order in float4/float8 tests.
Fix FOR PORTION OF for inheritance children
Fix dependency on FDW's connection function.
Fix RI fast-path for domain-typed FK columns
Recognize functional dependency on primary keys. This allows a table's other columns to be referenced without listing them in GROUP BY, so long as the primary key column(s) are listed in GROUP BY.
Add tuple deformation test for virtual generated columns
Avoid loss of code coverage with unlogged-index test cases.
Record dependencies on graph labels and properties
Cleanup users and roles in graph_table_rls test
Support grouping-expression references and GROUPING() in subqueries.
Allow log_min_messages to be set per process type
Add data type oid8, 64-bit unsigned identifier
Add test for single-page VACUUM of hash index on INSERT
Update comments to match location of definition
Tighten parsing of datetime input.
Add some regression tests for missing DDL patterns
Consider explicit incremental sort for Append and MergeAppend
Add pg_constraint rows for not-null constraints
Support for INCLUDE attributes in GiST indexes
Allow ALTER INDEX .. ATTACH PARTITION to validate a parent index
Improve test coverage of network address functions
Paper over regression failures in infinite_recurse() on PPC64 Linux.
Add support for altering CHECK constraint enforceability
Fix typos in comments.
Make INSERT-from-multiple-VALUES-rows handle domain target columns.
Add support for INSERT ... ON CONFLICT DO SELECT.
Modernize to_char's Roman-numeral code, fixing overflow problems.
Improve handling of date_trunc() units for infinite input values
Clean up all relid fields of RestrictInfos during join removal.
Improve hash join's handling of tuples with null join keys.
Allow json{b}_strip_nulls to remove null array elements
Exercise parallel GIN builds in regression tests
Fix jsonpath .split_part() to honor silent mode
Add additional jsonpath string methods
Allow Unicode escapes in any server encoding, not only UTF-8.
Fix bugs in manipulation of large objects.
Fix deparsing FETCH FIRST <expr> ROWS WITH TIES
Fix misc typos, mostly in comments
Avoid ERROR at ON COMMIT DELETE ROWS after relhassubclass=f.
Put tests of md5() function into separate test file
Discount the metapage when estimating number of index pages visited.
Fix MERGE into a plain inheritance parent table.
instrumentation: Standardize ticks to nanosecond conversion method
Remove pg_replication_origin's TOAST table.
Add overflow checks to money type.
Check CREATE privilege on multirange type schema in CREATE TYPE.
Fix typo in MVCC test comment
Don't try to re-order the subcommands of CREATE SCHEMA.
Test PRI* macros even when we can't test NLS translation.
Introduce pg_shmem_allocations_numa view
Allow width_bucket()'s "operand" input to be NaN.
Improve the accuracy of numeric power() for integer exponents.
Fix overflow in parsing of positional parameter
Improve portability of test with oid8 comparison function
Build in some knowledge about foreign-key relationships in the catalogs.
Allow negative aggtransspace to indicate unbounded state size
Fix assertion failure in generate_orderedappend_paths()
Fix infer_arbiter_index for partitioned tables
Create TOAST table for partitions made by MERGE/SPLIT PARTITION
Strip PlaceHolderVars from partition pruning operands
Restrict password hash length.
Add input function for data type pg_dependencies
Add input function for data type pg_ndistinct
Stabilize plancache test against on-access VM setting
Short-circuit row estimation in NOT IN containing NULL consts
Force standard_conforming_strings to always be ON.
Fix UPDATE/DELETE ... WHERE CURRENT OF on a table with virtual columns.
Remove useless whitespace at end of lines
Teach planner to transform "x IS [NOT] DISTINCT FROM NULL" to a NullTest
Remove too demanding test
Add test for row-locking and multixids with prepared transactions
Require UPDATE permission on FOR PORTION OF column
psql: Fix expanded aligned output
Fix incorrect error reporting for duplicate data in \crosstabview.
psql: Fix issues with deferred errors in pipelines
psql: Improve describe footer titles for publications.
Add date and timestamp variants of random(min, max).
Fix type-checking of RECORD-returning functions in FROM, redux.
Add range_minus_multi and multirange_minus_multi functions
Add new OID alias type regdatabase.
Fix rd_firstRelfilenodeSubid for nailed relations, in parallel workers.
Allow Boolean reloptions to have ternary values
Fix parsing of parenthesised OLD/NEW in RETURNING list.
Remove WITH OIDS support, change oid catalog column visibility.
Fix "failed to find plan for subquery/CTE" errors in EXPLAIN.
Remove AIX support
Establish conventions about global object names used in regression tests.
Reordering DISTINCT keys to match input path's pathkeys
Fix test case from a8ccf4e
Make the behavior of HAVING without GROUP BY conform to the SQL spec. Formerly, if such a clause contained no aggregate functions we mistakenly treated it as equivalent to WHERE. Per spec it must cause the query to be treated as a grouped query of a single group, the same as appearance of aggregate functions would do. Also, the HAVING filter must execute after aggregate function computation even if it itself contains no aggregate functions.
Remove gratuitous uses of deprecated SELECT INTO
Add missing BUFFERS OFF in select_into regression tests
Avoid locale-dependent output in select_views regression test.
Expose sequence page LSN via pg_get_sequence_data.
IS JSON/JSON(): Protect against expressions uncoercible to text
SQL/JSON: Fix default ON ERROR behavior for JSON_TABLE
Honor passed-in database OIDs in pgstat_database.c
Add support for extended statistics on virtual generated columns.
Reject oversized MCV lists in pg_restore_extended_stats()
Add more tests for relation statistics with rewrites
Add base32hex support to encode() and decode() functions.
Avoid errors during ALTER SUBSCRIPTION.
Fix var_is_nonnullable() to handle invalid NOT NULL constraints
Add system view pg_stat_recovery
Fix some anomalies with NO SCROLL cursors.
Disallow CR and LF in database, role, and tablespace names
tests: Expand temp table tests to some pin related matters
Move contrib/spi testing from core regression tests to contrib/spi.
Add tid_block() and tid_offset() accessor functions
Add parallelism support for TID Range Scans
Improve tests of date_trunc() with infinity and unsupported units
Dodge a compiler bug affecting timetz_zone/timetz_izone.
Fix COMMIT/ROLLBACK AND CHAIN in the presence of subtransactions.
Fix use-after-free of qs in AfterTriggerEndQuery.
Fix TRUNCATE .. CASCADE on partitions
Fix typos and duplicate words
Fix overflows with ts_headline()
Fix handling of targetlist SRFs when scan/join relation is known empty.
Improve test coverage in bump.c
Introduce xid8-based functions to replace txid_XXX.
Record range constructor functions in pg_range
Add regression test for ALTER TABLE .. NO INHERIT on typed tables
Fix off-by-one with NFC recomposition for Hangul U+11A7 (TBASE)
Fix estimate_array_length error with set-operation array coercions
Fix FOR PORTION OF with non-updatable view columns
Add hint about not qualifying UPDATE...SET target with relation name.
Fix UUID sortability tests in base32hex encoding.
Add SQL test for TOAST value allocations on rewrite
Don't overlook indexes during parallel VACUUM.
Fix IGNORE NULLS nullness cache for volatile window arguments.
Avoid rewriting data-modifying CTEs more than once.
Fix WITHOUT OVERLAPS' interaction with domains.
Enable parallelism in REFRESH MATERIALIZED VIEW.
Trim regression test expected output for xml
Fix incorrect xmlschema output for types timetz and timestamptz.