PostgreSQL 11 Open Items

== Open Issues ==
NOTE: Please add new open items to the bottom of the list.
== Decisions to Recheck Mid-Beta ==
* reconsider jit=on default shortly before release
** Resolved: we'll disable it for v11
** Fixed in: 
== Older Bugs ==
=== Live issues ===
* IsInParallelMode() check in set_config_option is wrong (was: WARNING in parallel index creation)
* pg_dump misses public role on schema public
* Default values in partition tables don't work as expected and allow NOT NULL violation
* Breakage in plpgsql composite-variable handling
* test_pg_dump missing cleanup actions
* 9.4 and reproducible "ERROR: could not read block 0 in file..."
=== Fixed issues ===
* Allocation done in critical section when initializing WAL
** Fixed in: 
* Parallel query can fail on machines with strict alignment rules
** Fixed in: 
* pg_constraint.conincluding is useless.
** Fixed in: 
* Parallel CREATE INDEX doesn't have relmapper.c state propogated when reindexing mapped catalog relations during VACUUM FULL.
** Fixed in: 
* Failed index build can corrupt relcache contents
** Fixed in: 
* Fix slot's xmin advancement and subxact's lost snapshots in decoding
** Fixed in: 
* SHOW ALL does not honor pg_read_all_settings membership
** Fixed in: 
* postgres_fdw: Oddity in pushing down inherited UPDATE/DELETE joins to remote servers
** Fixed in: 
* Continued WAL record can prevent standby from startup
** Fixed in: 
* FinishPreparedTransaction missing HOLD_INTERRUPTS section
** Fixed in: 
* PANIC during crash recovery of a recently promoted standby
** Fixed in: 
* Replication status in logical replication
** Fixed in: 
* LLVM jit and window functions on a temporary table
** Turned out to be an older bug independent of JIT Report
** Fixed in: 
* LLVM jit and matview
** Fixed in: 
* "could not read block" buildfarm failures
** Bug identified, two prototype patches exist, discussion ongoing
** Fixed in: 
* Intermittent pg_ctl failures on Windows
** Fixed in: 
* Hash index misses call to PageSetChecksumInplace() for empty pages
** Fixed in: 
* EXPLAIN ANALYZE has wrong timings for JIT when parallelism is in use
** Fixed in: 
* Sequence owner not updated when owning table is foreign
** Fixed in: 
* Hot standby server with archive_mode=on keeps initial WAL segment
** Fixed in: 
* out-of-order XID insertion in KnownAssignedXids
** Fixed in: 
* Restore CurrentUserId only if 'prevUser' is valid when abort transaction
** Fixed in: 
* Fixes for missing schema qualifications
** Fixed in: 
== Non-bugs ==
* Supporting tls-server-end-point as SCRAM channel binding for OpenSSL 1.0.0 and 1.0.1
* Deal with BEFORE ROW triggers in partitioned tables in some way
* SCRAM with channel binding downgrade attack
** Other thread
** patch exists
** Channel binding has been removed from the list of major features. A more generic solution involving as well downgrades like scram -> md5 need to be designed and thought about.
* Stored procedures and out parameters
== Resolved Issues ==
=== resolved before RC1 ===
* Transaction timestamps and procedures yield inconsistent result
** Fixed in 
* Segfault when creating partition with a primary key and sql_drop trigger exists
** Fixed in 
* Multiple primary keys attaching partition
** Fixed in 
* Assertion failure with ALTER TABLE ATTACH PARTITION with log_min_messages >= DEBUG1
** Fixed in 
* pg_upgrade failed with ERROR: null relpartbound for relation 18159 error.
** Fixed in 
=== resolved before 11beta4 ===
* "ERROR: cache lookup failed for constraint" when ALTERING column referenced by fkey of a partitioned table
** Fixed in 
* Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.
** Fixed in 
* Memory leak with CALL to Procedure with COMMIT
** Fixed in 
* Preexisting use of the word "procedure" in user docs has the potential to confuse
** Fixed in , , 
* Fix hints on CREATE PROCEDURE errors
** Fixed in 
* Error during run-time pruning
** Fixed in 
=== resolved before 11beta3 ===
* Explain buffers wrong counter with parallel plans
** reported as a possible defect in commit 01edb5c7fc3bcf6aea15f2b3be36189b52ad9d1a
** Fixed in 
* Runtime partition pruning does not handle UNION ALL parents correctly
** Fixed in 
* Advance replication slot patch broke detection of nonexistant output plugins
** Broken in 
** Fixed in 
* memory leaks in COPY FROM on partitioned table
** Fixed in: 
* partition pruning failure
** Fixed in: 
* unnamed POSIX semaphores are slow
** Fixed in: 
* wrong query result with jit_above_cost=0
** Fixed in: 
* Fix calculations on WAL recycling
** Fixed in 
* Fix error message when trying to alter statistics on included column
** Fixed in 
* partition pruning doesn't work with IS NULL clause in multikey range partition case
** Fixed in 
* Cannot dump foreign key constraints on partitioned table
** Fixed in 
* 
** Fixed in 
* 
** David Rowley reports that the first bad commit is reported (Adapt to LLVM 7+ Orc API changes.)
** Amit Langote believes based on the core dump that the problem may be in ) (Do execGrouping.c via expression eval machinery, take two.)
** Fixed in 
* 
** Fixed in 
* Portability concerns over pq_sendbyte?
** Fixed in 
* Non-reserved replication slots and slot advancing
** Fixed in 
* Failed assertion in GROUPS mode of window function in current HEAD
** Fixed in 
* Concurrency bug in UPDATE of partition-key
** Fixed in 
* Failed assertion due to procedure created with SECURITY DEFINER option
** Fixed in 
* Problem with tupdesc in jsonb_to_recordset
** Fixed in 
* assert in nested SQL procedure call in current HEAD see also
** Fixed in 
* crash/assert caused by parameter type changes
** Fixed in 
=== resolved before 11beta2 ===
* Fast default feature fails in pg_upgrade
** Fixed in: with fixup 
* JSONB PL/Perl transform bugs
** Fixed in: 
* pg_replication_slot_advance may cause assertion failures with incorrect LSN values
** Fix committed in f731cfa94c00164814625d5753d376a4a7c43fff
* Needless additional partition check in INSERT
** Fixed in: 
* pg_resetwal fails with relative path to data dir
** Bug fix: 
* Parallel Hash: invalid DSA memory alloc request size 1073741824
** Bug fix: 
* pg_replication_slot_advance to return NULL instead of 0/0 if slot not advanced
** Bug fix: 
* pg_config.h.win32 missing a set of flags from pg_config.h.in added in v11 development
** Fixed in: 
* Partitioning with temp tables is broken
** Fixed in: 
* Server crash during parallel append path generation
** Fixed in: 
* Partition-wise aggregation asserts out
** Fixed in: 
* Performance regression with PostgreSQL 11 and partitioning
** Fixed in: 
* Error during partition index rename
** Fixed in: 
=== resolved before 11beta1 ===
* Indexes on partitioned tables and foreign partitions
** appears to be a bug in 8b08f7d4 (Local partitioned indexes)
** Fixed in: 
* \d doesn't show partitioned tables' foreign key
** Fixed in: 
* Memory leaks with _SPI_stack handling in TopMemoryContext
** Regression caused by commit 8561e48.
** Fixed in: 
* Oddity in tuple routing for foreign partitions
** Fixed in: 
* Corrupted btree index on HEAD because of covering indexes
** Fixed in: 
* Decide if we want a GUC to disable partition pruning
** Fixed in: 
* Fix partition pruning for the cases where partition key is of array, enum, record, or range type
** Patch exists
** Bug fix: 
* Run-time pruning and Parallel Append don't work properly together
** Patch exists
** Bug fixes: 
* expand_tuple segfaults
** coverage report shows it's completely untested, too
** Bug fix: 
** Add coverage: 
* Handling of whole-row vars in ON CONFLICT on partitioned tables
** Bug fix: 
* relispartition for index partitions
** Bug fix: 
* failure to validate default partition's constraint when attaching after4dba331cb3
** Patch exists
** Bug fix: 
* Failed assertion on pfree() via perform_pruning_combine_step
** Original commit: 
** Bug fix: 
* Parallel index workers don't have activity set
** Original commit: 
** Bug fix: 
* check_ssl_key_file_permissions should be in be-secure-common.c
** Original commit: 
** Patch exists
** Bug fix: 
* Missing break statement after transformCallStmt in transformStmt
** Original commit: 
** Bug fix: 
* Parallel index creation does not properly clean up after error
** Original commit: 
** Bug fix: 
* pg_proc.prokind change means we need server-version-dependent tab completion in psql
** Proposed patch
* "make -j 4 install" broken after running configure
** Bug fix: 
* OpenTransientFile() should be paired with CloseTransientFile() rather than close()
** Bug fix: 
* Fix pg_rewind which can be run as root user
** Bug fix: 
* Fix for pg_stat_activity putting client hostaddr into appname field
** Bug fix: and 
* Missing support of named convention for procedures
** Bug fix: 
* Gotchas about pg_verify_checksums
* pg_verify_checksums does not check after all-zero'd pages
* Typos from the original patch
* Fixes for the documentation
* Repeated crashes in GENERATED ... AS IDENTITY tests
** Bug fix: 
** Bug fix: 
* Partitions with bool partition keys
* wrong memory context used in FmgrInfo's contained in PartitionKey
** Bug fix (HEAD): 
** Bug fix (PG 10): 
* BGWORKER_BYPASS_ALLOWCONN used nowhere (infra part of on-line checksum switcher)
** Bug fix: 
** Bug fix: 
* Failed assertion in create_gather_path
** Bug fix: 
* Cold welcoming message when installing anything because of LLVM bitcode stuff
* jitflags in _outPlannedStmt and _readPlannedStmt treated as bool type
** Bug fix: 
* wal_consistency_checking reports an inconsistency on master branch
** Bug fix: 
* Refreshing findoidjoins for v11
** Bug fix: 
* Crash with partition pruning with handling of ArrayCoerceExpr
** Bug fix: 
* Local partitioned indexes and pageinspect
** Bug fix: 
* breakage calling a procedure with a toasted parameter
** Bug fix: 
== Important Dates ==
Current schedule:
* feature freeze: 8th of April 2018
* beta1: 24th of May 2018
* beta2: 28th of June 2018
* beta3: 9th of August 2018
* beta4: 20th of September 2018
* rc1: 11th of October 2018
* ga: 18th of October 2018
Category:Open_Items