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.
Teach psql to skip in-line COPY ... FROM STDIN data after a failure.
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
Add _bt_set_startikey row compare test coverage.
Fix NULLIF()'s handling of read-write expanded objects.
Clean up ancient test style
Cover additional errors and corner conditions in repack.c
Fix mishandling of leading '\' in nondeterministic LIKE.
Fix calculating length of match to localized month/weekday names
Fix LIKE/regex optimization for indexscan with exact-match pattern.
Fix unintentional behavior change from 5a38104.
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 inherited CHECK constraints from being weakened
Remove MULE_INTERNAL encoding.
Fix wrong assertion and poor error messages in "COPY (query) TO".
Apply encoding conversion in COPY TO FORMAT JSON
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.
Further improve the names generated for indexes on expressions.
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.
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.
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
Fix out-of-bound reads with ascii() for invalid multibyte characters
Improve error message for duplicate labels when creating an enum type.
Implement Self-Join Elimination
Code coverage for most pg_mblen* calls.
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.
Fix dependency on FDW's connection function.
Fire fast-path FK batches inside the deferred trigger loop
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.
Avoid loss of code coverage with unlogged-index test cases.
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.
Tighten parsing of datetime input.
Add some regression tests for missing DDL patterns
Consider explicit incremental sort for Append and MergeAppend
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.
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
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 jsonpath .decimal() 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.
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
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
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
Build in some knowledge about foreign-key relationships in the catalogs.
Fix incorrect declarations of variadic pg_get_*_ddl() functions.
Fix assertion failure in generate_orderedappend_paths()
Fix infer_arbiter_index for partitioned tables
Take into account default_tablespace during MERGE/SPLIT PARTITION(S)
Fix issue with RANGE's DEFAULT partition pruning
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
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
Make crosstabview honor boolean/null display settings
psql: Fix issues with deferred errors in pipelines
Don't show tables redundantly when their schema is published.
Add date and timestamp variants of random(min, max).
Fix type-checking of RECORD-returning functions in FROM, redux.
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
Add pg_constraint rows for not-null constraints
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.
Disallow renaming a rule to "_RETURN".
Remove AIX support
Establish conventions about global object names used in regression tests.
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.
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
Add system view pg_stat_kind_info
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
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.
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
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()
Disallow set-returning functions within window OVER clauses.
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)
Forbid FOR PORTION OF on views with INSTEAD OF triggers
Add hint about not qualifying UPDATE...SET target with relation name.
Support UUIDv6 in uuid_extract_timestamp().
Add SQL test for TOAST value allocations on rewrite
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.