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.
Avoid orphaned objects dependencies
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.
Make row compares robust during nbtree array scans.
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
Consider opfamily and collation when removing redundant GROUP BY columns
Fix tests for non-ICU build
Include error location in errors from ComputeIndexAttrs().
Run UTF8-requiring collation tests by default
Fix INITCAP() word boundaries for PG_UNICODE_FAST.
Support C.UTF-8 locale in the new builtin collation provider.
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 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
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.
doc: Clarify that empty COMMENT string removes the comment.
Rearrange core regression tests to reduce cross-script dependencies.
Handle element label and label property objects in object address functions
Support more object types within CREATE SCHEMA.
psql: Make \d+ partition list formatting consistent with other objects
Fix attnum remapping in generateClonedExtStatsStmt()
Add a parse location field to struct FunctionParameter.
Don't try to re-order the subcommands of CREATE SCHEMA.
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
Code coverage for most pg_mblen* calls.
Improve error message for duplicate labels when creating an enum type.
Implement Self-Join Elimination
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
psql: Make \d+ inheritance tables list formatting consistent with other objects
Fix RI fast-path for domain-typed FK columns
Add tuple deformation test for virtual generated columns
EXPLAIN: Always use two fractional digits for row counts.
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
Add some regression tests for missing DDL patterns
Consider startup cost as a figure of merit for partial paths.
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.
Fix typos in comments.
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
Fix JSON error reporting for many cases of erroneous string values.
Allow Unicode escapes in any server encoding, not only UTF-8.
Exercise parallel GIN builds in regression tests
Fix jsonpath .split_part() 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.
Add overflow checks to money type.
Check CREATE privilege on multirange type schema in CREATE TYPE.
Fix typo in MVCC test comment
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.
Improve portability of test with oid8 comparison function
Add tid_block() and tid_offset() accessor functions
Fix assertion failure in generate_orderedappend_paths()
Fix infer_arbiter_index for partitioned tables
Correctly calculate "MCV frequency" for a unique column.
Create TOAST table for partitions made by MERGE/SPLIT PARTITION
Strip PlaceHolderVars from partition pruning operands
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
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
Skip prepared_xacts test if max_prepared_transactions < 2
Require UPDATE permission on FOR PORTION OF column
psql: Fix expanded aligned output
Change return type of EXTRACT to numeric
psql: Fix issues with deferred errors in pipelines
Use schema-qualified names in EXCEPT clause error messages.
Add date and timestamp variants of random(min, max).
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.
Add pg_stat_autovacuum_scores system view.
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
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()
IS JSON/JSON(): Protect against expressions uncoercible to text
Reword recent error messages: "should" -> "must"
Constistent naming for datacheckusms processes
Split CREATE STATISTICS error reasons out into errdetails
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
Get rid of the "new" and "old" entries in a view's rangetable.
Move contrib/spi testing from core regression tests to contrib/spi.
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()
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
Fix estimate_array_length error with set-operation array coercions
Fix FOR PORTION OF with non-updatable view columns
Fix UUID sortability tests in base32hex encoding.
Cleanup VACUUM option processing error messages
Don't overlook indexes during parallel VACUUM.
Fix error message typo.
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.
Remove error message hints mentioning configure options