master
tests: Restrict pg_locks queries in advisory_locks.sql to current database
Revert "Add GROUP BY ALL".
SQL Property Graph Queries (SQL/PGQ)
Extend ALTER OPERATOR to allow setting more optimization attributes.
Improve the names generated for indexes on expressions.
Support INCLUDE'd columns in 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
Improve EXPLAIN's display of window functions.
Set query ID in parallel workers for vacuum, BRIN and btree
BRIN bloom indexes
Show index search count in EXPLAIN ANALYZE, take 2.
Add _bt_set_startikey row compare test coverage.
Keep track of what RTIs a Result node is scanning.
Rework pg_input_error_message(), now renamed pg_input_error_info()
Clean up ancient test style
Cover additional errors and corner conditions in repack.c
Fix mishandling of leading '\' in nondeterministic LIKE.
Fix tests for non-ICU build
Fix calculating length of match to localized month/weekday names
Run UTF8-requiring collation tests by default
Fix LIKE/regex optimization for indexscan with exact-match pattern.
Fix unintentional behavior change from 5a38104.
Support C.UTF-8 locale in the new builtin collation provider.
Include error location in errors from ComputeIndexAttrs().
Windows support in pg_import_system_collations
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 inherited CHECK constraints from being weakened
Remove MULE_INTERNAL encoding.
Teach psql to skip in-line COPY ... FROM STDIN data after a failure.
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
Add some tests for encoding conversion in COPY TO/FROM
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
Provide more-specific error details/hints for function lookup failures.
Rename create_function_N test scripts for clarity.
Issue a NOTICE if a created function depends on any temp objects.
Further improve the names generated for indexes on expressions.
Rearrange core regression tests to reduce cross-script dependencies.
Report duplicate property and label names with a proper error
doc: Clarify that empty COMMENT string removes the comment.
psql: Tighten heuristics for BEGIN/END within CREATE SCHEMA.
Add a parse location field to struct FunctionParameter.
Message style fixes
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)
Reduce messages about implicit indexes and sequences to DEBUG1.
Show more-intuitive titles for psql commands \dt, \di, etc.
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
Fix out-of-bound reads with ascii() for invalid multibyte characters
Code coverage for most pg_mblen* calls.
Improve error message for duplicate labels when creating an enum type.
Implement Self-Join Elimination
Handle element label and label property objects in object address functions
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
Fix unlikely incremental tuple deform bug with missing attrs
Avoid depending on post-UPDATE row order in float4/float8 tests.
Avoid RETURNING side effects for FOR PORTION OF leftovers.
psql: Make \d+ inheritance tables list formatting consistent with other objects
Fire fast-path FK batches inside the deferred trigger loop
Fix ALTER COLUMN ... DROP EXPRESSION with subpartitions
Whole-row fixes for ALTER COLUMN SET EXPRESSION
EXPLAIN: Always use two fractional digits for row counts.
Fix GiST index-only scan column alignment issue.
Disallow aggregates, window functions, and SRFs in GRAPH_TABLE COLUMNS
Prohibit GRANT ... ON TABLE on a property graph
Add an enable_groupagg GUC parameter
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
Prevent satisfies_hash_partition from crashing with VARIADIC NULL.
Add some regression tests for missing DDL patterns
Consider startup cost as a figure of merit for partial paths.
In transformIndexStmt, transform index expressions in INCLUDING.
Support for INCLUDE attributes in GiST indexes
Fix restore of partitions with exclusion constraints
Improve test coverage of network address functions
Paper over regression failures in infinite_recurse() on PPC64 Linux.
Fix typos in comments.
psql: Make \d+ partition list formatting consistent with other objects
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
Fix incorrect Result node flattening logic
Improve hash join's handling of tuples with null join keys.
Allow json{b}_strip_nulls to remove null array elements
Fix JSON error reporting for many cases of erroneous string values.
Allow Unicode escapes in any server encoding, not only UTF-8.
Fix jsonpath .decimal() to honor silent mode
Add additional jsonpath string methods
Message wording improvements
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.
Unify some more messages
Put tests of md5() function into separate test file
Allow tests to pass in OpenSSL FIPS mode (rest)
Add regression expected-files for older OpenSSL in FIPS mode.
Discount the metapage when estimating number of index pages visited.
Assign each subquery a unique name prior to planning it.
instrumentation: Standardize ticks to nanosecond conversion method
Remove pg_replication_origin's TOAST table.
Fix missing money overflow checks for INT64_MIN / -1
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
Standardize LSN formatting by zero padding
Improve the accuracy of numeric power() for integer exponents.
Prevent mis-encoding of "trailing junk after numeric literal" errors.
pg_dump: avoid assuming how long pg_proc.protrftypes can be.
Add ssup_datum_uint32_cmp for comparing OIDs
Improve portability of test with oid8 comparison function
Add min() and max() aggregate support for uuid.
Fix assertion failure in generate_orderedappend_paths()
Fix infer_arbiter_index for partitioned tables
Correctly calculate "MCV frequency" for a unique column.
Take into account default_tablespace during MERGE/SPLIT PARTITION(S)
Fix issue with RANGE's DEFAULT partition pruning
Deprecate MD5 passwords.
Add missing serial commas
Improve error messages of input functions for pg_dependencies and pg_ndistinct
Stabilize plancache test against on-access VM setting
Avoid collation lookup failure when considering a "char" column.
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
Skip prepared_xacts test if max_prepared_transactions < 2
Check for USAGE privilege on the composite type in ALTER TABLE OF.
Make crosstabview honor boolean/null display settings
psql: Fix issues with deferred errors in pipelines
Fix errmsg grammar for publication membership
Add date and timestamp variants of random(min, max).
Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE.
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 RLS checks for FOR PORTION OF leftover rows
Fix data checksum progress counter initialization
Remove AIX support
Establish conventions about global object names used in regression tests.
Fix test case from a8ccf4e
Add a bunch of new error location reports to parse-analysis error messages. There are still some weak spots around JOIN USING and relation alias lists, but most errors reported within backend/parser/ now have locations.
Remove gratuitous uses of deprecated SELECT INTO
Add text-vs-name cross-type operators, and unify name_ops with text_ops.
Change error message for sequence validate_relation_kind()
Avoid loss of code coverage with unlogged-index test cases.
Fix deparsing of JSON_ARRAY(subquery) with a FORMAT clause
Make JSON_TABLE generated path names avoid collisions
Enforce RETURNING typmod on SQL/JSON DEFAULT behavior expressions
Restrict pg_stat_io entries for data checksum processes
Preserve the owner of extended statistics rebuilt by ALTER TABLE.
Fix multirange type handling in pg_restore_attribute_stats()
Add more tests for relation statistics with rewrites
Fix truncation rules for base64 encoding
When changing owner of a subscription, do not throw an error.
Fix nullability check for a sub-select's upper-level Vars
Get rid of the "new" and "old" entries in a view's rangetable.
Move contrib/spi testing from core regression tests to contrib/spi.
Tighten tid input parsing with strtoul() to reject empty fields
Add parallelism support for TID Range Scans
Improve tests of date_trunc() with infinity and unsupported units
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()
Disallow set-returning functions within window OVER clauses.
Perform radix sort on SortTuples with pass-by-value Datums
Introduce xid8-based functions to replace txid_XXX.
Record range constructor functions in pg_range
Refactor some code around ALTER TABLE [NO] INHERIT
Fix off-by-one with NFC recomposition for Hangul U+11A7 (TBASE)
Add SQL functions for Unicode normalization
Forbid FOR PORTION OF on views with INSTEAD OF triggers
Support UUIDv6 in uuid_extract_timestamp().
Cleanup VACUUM option processing error messages
Don't overlook indexes during parallel VACUUM.
Fix COUNT's logic for window run condition support
Propagate stadistinct through GROUP BY/DISTINCT in subqueries and CTEs
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.
Remove error message hints mentioning configure options