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: 0fdadfb0192935e0f8bec7fa5ec9dbb470d6d587

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: a86bf6057edf7bc344f1ab6ba7824b561ed9068a
• Parallel query can fail on machines with strict alignment rules
  • Fixed in: ca5ca25d08710d7f5aaf0e390aae284bc594a6da
• pg_constraint.conincluding is useless.
  • Fixed in: c076f3d74af6e4836206142446bdcc2f93e149d6
• Parallel CREATE INDEX doesn't have relmapper.c state propogated when reindexing mapped catalog relations during VACUUM FULL.
  • Fixed in: 4974d7f87e62a58e80c6524e49677cb25cc10e12
• Failed index build can corrupt relcache contents
  • Fixed in: b3f919da07540d7c968e8495482336304badcef7
• Fix slot's xmin advancement and subxact's lost snapshots in decoding
  • Fixed in: f49a80c481f74fa81
• SHOW ALL does not honor pg_read_all_settings membership
  • Fixed in: 0c8910a0cab7c1e439bf5f5850122c36359e6799
• postgres_fdw: Oddity in pushing down inherited UPDATE/DELETE joins to remote servers
  • Fixed in: 7fc7dac1a711d0dbd01d2daf6dc97d27d6c6409c
• Continued WAL record can prevent standby from startup
  • Fixed in: 0668719801838aa6a8bda330ff9b3d20097ea844
• FinishPreparedTransaction missing HOLD_INTERRUPTS section
  • Fixed in: 8f9be261f43772ccee2eae94d971bac6557cbe6a
• PANIC during crash recovery of a recently promoted standby
  • Fixed in: 3c64dcb1e35dccbfce531182fa9b9f48bec414ad
• Replication status in logical replication
  • Fixed in: 0414ac6a1eb2e457c8019c5a558bd72b37dede89
• LLVM jit and window functions on a temporary table
  • Turned out to be an older bug independent of JIT Report
  • Fixed in: ff4f88916
• LLVM jit and matview
  • Fixed in: 3acc4acd9bcbefbfaf789762950726c6208daf1b
• "could not read block" buildfarm failures
  • Bug identified, two prototype patches exist, discussion ongoing
  • Fixed in: 3acc4acd9bcbefbfaf789762950726c6208daf1b
• Intermittent pg_ctl failures on Windows
  • Fixed in: 0ba06e0bfb8cfd24ff17aca92aa72245ddd6c4d7
• Hash index misses call to PageSetChecksumInplace() for empty pages
  • Fixed in: 16e7bcfac57fc21dd2124b39132c58971e41448a
• EXPLAIN ANALYZE has wrong timings for JIT when parallelism is in use
  • Fixed in: 33001fd7a7072d483272115a9376478fdc007fb9
• Sequence owner not updated when owning table is foreign
  • Fixed in: 0320ddaf3c08ea17d616549d0e7f45239592fc76
• Hot standby server with archive_mode=on keeps initial WAL segment
  • Fixed in: 78ea8b5daab9237fd42d7a8a836c1c451765499f
• out-of-order XID insertion in KnownAssignedXids
  • Fixed in: 1df21ddb19c6e764fc9378c900515a5d642ad820
• Restore CurrentUserId only if 'prevUser' is valid when abort transaction
  • Fixed in: b4721f39505b56dd7b556aef5428a0850230ca59
• Fixes for missing schema qualifications
  • Fixed in: ee2b37ae044f34851baba69e9ba737077326414e

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 82ff0cc91d9840d1c56ca1beed58bedfde3da9a3
• Segfault when creating partition with a primary key and sql_drop trigger exists
  • Fixed in 1a852f7c1e
• Multiple primary keys attaching partition
  • Fixed in ff347f8aff
• Assertion failure with ALTER TABLE ATTACH PARTITION with log_min_messages >= DEBUG1
  • Fixed in c905b67b79
• pg_upgrade failed with ERROR: null relpartbound for relation 18159 error.
  • Fixed in 1c7f585b5c

resolved before 11beta4

• "ERROR: cache lookup failed for constraint" when ALTERING column referenced by fkey of a partitioned table
  • Fixed in 6009bad913

• Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.
  • Fixed in 7cfdc77023ad50731723e85c215a4127436ed09c

• Memory leak with CALL to Procedure with COMMIT
  • Fixed in 7a3b7bbfded3142aaa8edae2dbc88999568cc1cd

• Preexisting use of the word "procedure" in user docs has the potential to confuse
  • Fixed in b19495772e48ecd32de9a906ddf8c25e16007575, d12782898eb5979bef3c6dd0d80b93d1aaf53cac, 0a63f996e018ac508c858e87fa39cc254a5db49f

• Fix hints on CREATE PROCEDURE errors
  • Fixed in d83423db869900ffa2470826de5f8255d45ff9c6

• Error during run-time pruning
  • Fixed in 1eb9221585

resolved before 11beta3

• Explain buffers wrong counter with parallel plans
  • reported as a possible defect in commit 01edb5c7fc3bcf6aea15f2b3be36189b52ad9d1a
  • Fixed in dac7fe13bbf10c249a519d6a41c683c42c7e3312

• Runtime partition pruning does not handle UNION ALL parents correctly
  • Fixed in 1b54e91faabf3764b6786915881e514e42dccf89

• Advance replication slot patch broke detection of nonexistant output plugins
  • Broken in 9c7d06d60680c7f00d931233873dee81fdb311c6
  • Fixed in 7326a7d63801673d3569def65cb7955d6486f254

• memory leaks in COPY FROM on partitioned table
  • Fixed in: 34295b87fbbcbaf26280f53f006b20971dbad1f3

• partition pruning failure
  • Fixed in: 192d1bbf99699de76473184c57fff9ff4b4246f4

• unnamed POSIX semaphores are slow
  • Fixed in: f2db5f3bb0b5d429e9fa5b093936f8524e4192b1

• wrong query result with jit_above_cost=0
  • Fixed in: 6b4d860311e99621681f25db5db82f88348d8ea6

• Fix calculations on WAL recycling
  • Fixed in 9915735ebb

• Fix error message when trying to alter statistics on included column
  • Fixed in 802b04cb3f

• partition pruning doesn't work with IS NULL clause in multikey range partition case
  • Fixed in fb2b61a21e141843697de7982c9f6485effcd915

• Cannot dump foreign key constraints on partitioned table
  • Fixed in 2af39c39df94096ecc593f5a162947e1e994cab3

• TRUNCATE tables referenced by FKs on partitioned tables is broken
  • Fixed in 727196ced2423008bb25d7775c4e3b7fca063c8b

• Server crashed with dense_rank on partition table
  • David Rowley reports that the first bad commit is reported 4b9094eb6e14dfdbed61278ea8e51cc846e43579 (Adapt to LLVM 7+ Orc API changes.)
  • Amit Langote believes based on the core dump that the problem may be in bf6c614a2f2c58312b3be34a47e7fb7362e07bcb) (Do execGrouping.c via expression eval machinery, take two.)
  • Fixed in e60cfcefe635b90bab60e885be689700759a01c6

• Listing triggers in partitions
  • Fixed in bc87f22ef6ef1137909ed7363976c67cf1efa7da

• Portability concerns over pq_sendbyte?
  • Fixed in 42121790ca9b27e01fd0471fdac28ec4a381eaee

• Non-reserved replication slots and slot advancing
  • Fixed in 9069eb95f48c8200f8589faf7adc5e324eed25cd

• Failed assertion in GROUPS mode of window function in current HEAD
  • Fixed in ff4f8891648c804c7c126fdf438257b1e9dc7ca4

• Concurrency bug in UPDATE of partition-key
  • Fixed in 40ca70ebcc9d0bc1c02937b27c44b2766617e790

• Failed assertion due to procedure created with SECURITY DEFINER option
  • Fixed in 3804e89bd0e94fb412d3eecb2113cc97e0f7310b

• Problem with tupdesc in jsonb_to_recordset
  • Fixed in 4984784f836a061985b356c52253b5d83a0cbe65

• assert in nested SQL procedure call in current HEAD see also
  • Fixed in d89348976c51952293ffe35845c372ffa7e93b47

• crash/assert caused by parameter type changes
  • Fixed in 662d12aea1d697adc4896ff7e5d5cf398c0cd267

resolved before 11beta2

• Fast default feature fails in pg_upgrade
  • Fixed in: 2448adf29c543befbac59f1ecfbb3ef4b0d808ce with fixup 123efbccea

• JSONB PL/Perl transform bugs
  • Fixed in: e348e7ae5727 1731e3741cbbf8e0b 93b6e03ab4794

• pg_replication_slot_advance may cause assertion failures with incorrect LSN values
  • Fix committed in f731cfa94c00164814625d5753d376a4a7c43fff

• Needless additional partition check in INSERT
  • Fixed in: 5b0c7e2f75

• pg_resetwal fails with relative path to data dir
  • Bug fix: 1d96c1b91a4b7da6288ee63671a234b557ff5ccf

• Parallel Hash: invalid DSA memory alloc request size 1073741824
  • Bug fix: 86a2218eb00eb6f97898945967c5f9c95c72b4c6

• pg_replication_slot_advance to return NULL instead of 0/0 if slot not advanced
  • Bug fix: f731cfa94c00164814625d5753d376a4a7c43fff

• pg_config.h.win32 missing a set of flags from pg_config.h.in added in v11 development
  • Fixed in: bde64eb6107622e8438dd61b93afd4d1adf178b3

• Partitioning with temp tables is broken
  • Fixed in: 1c7c317cd9d1e5647454deed11b55dae764c83bf

• Server crash during parallel append path generation
  • Fixed in: 403318b71f7058ecbfb65bcc7de1eec96cd35d3f

• Partition-wise aggregation asserts out
  • Fixed in: c6f28af5d7af87d7370e5f169251d91437f100a2

• Performance regression with PostgreSQL 11 and partitioning
  • Fixed in: 7d872c91a3f9d49b56117557cdbb0c3d4c620687

• Error during partition index rename
  • Fixed in: 040da42367a5de448ddecf6ee7c09f73580a6b28

resolved before 11beta1

• Indexes on partitioned tables and foreign partitions
  • appears to be a bug in 8b08f7d4 (Local partitioned indexes)
  • Fixed in: 4eaa53727542c39cca71b80e8ff3e1f742d64452

• \d doesn't show partitioned tables' foreign key
  • Fixed in: 93316299d6a185bed0a4be5376508fe2f7e6b2d6

• Memory leaks with _SPI_stack handling in TopMemoryContext
  • Regression caused by commit 8561e48.
  • Fixed in: 30c66e77be1d890c3cca766259c0bec80bcac1b5

• Oddity in tuple routing for foreign partitions
  • Fixed in: 37a3058bc7c8224d4c0d8b36176d821636a1f90e

• Corrupted btree index on HEAD because of covering indexes
  • Fixed in: 6db4b49986be3fe59a1f6ba6fabf9852864efc3e

• Decide if we want a GUC to disable partition pruning
  • Fixed in: 055fb8d33da6ff9003e3da4b9944bdcd2e2b2a49

• Fix partition pruning for the cases where partition key is of array, enum, record, or range type
  • Patch exists
  • Bug fix: e5dcbb88a15d445e0ccb3db3194f4a122b792df6

• Run-time pruning and Parallel Append don't work properly together
  • Patch exists
  • Bug fixes: 47c91b55991883322fdbc4495ce7fe6b2166e8fe 4d0f6d3f207d b47a86f5008f2674af20dd00bc233e7b74e01bba

• expand_tuple segfaults
  • coverage report shows it's completely untested, too
  • Bug fix: 7c44c46deb495a2f3861f402d7f2109263e3d50a
  • Add coverage: b39fd897e0398a6bdc6552daa7cacdf9c0e46d7e

• Handling of whole-row vars in ON CONFLICT on partitioned tables
  • Bug fix: 158b7bc6d77948d2f474dc9f2777c87f81d1365a

• relispartition for index partitions
  • Bug fix: 9e9befac4a2228ae8a5309900645ecd8ead69f53

• failure to validate default partition's constraint when attaching after4dba331cb3
  • Patch exists
  • Bug fix: 72cf7f310c0729a331f321fad39835ac886603dc

• Failed assertion on pfree() via perform_pruning_combine_step
  • Original commit: 9fdb675fc5d2de825414e05939727de8b120ae81
  • Bug fix: 7ba6ee815dc90d4fab7226d343bf72aa28c9aa5c

• Parallel index workers don't have activity set
  • Original commit: 9da0cc35284bdbe8d442d732963303ff0e0a40bc
  • Bug fix: 7de4a1bcc56f494acbd0d6e70781df877dc8ecb5

• check_ssl_key_file_permissions should be in be-secure-common.c
  • Original commit: 8a3d9425290ff5f6434990349886afae9e1c6008
  • Patch exists
  • Bug fix: 2764d5dcfa84d240c901c20ec6e194f72d82b78a

• Missing break statement after transformCallStmt in transformStmt
  • Original commit: 76b6aa41f41db66004b1c430f17a546d4102fbe7
  • Bug fix: 13c7c65ec900a30bcddcb27f5fd138dcdbc2ca2e

• Parallel index creation does not properly clean up after error
  • Original commit: 29d58fd3adae9057c3fd502393b2f131bc96eaf9
  • Bug fix: 47cb9ca49a611fa518e1a0fe46526507c96a5612

• 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: 3b8f6e75f3c8c6d192621f21624cc8cee04ec3cb

• OpenTransientFile() should be paired with CloseTransientFile() rather than close()
  • Bug fix: 231bcd0803eb91c526d4e7522c993fa5ed71bd45

• Fix pg_rewind which can be run as root user
  • Bug fix: 5d5aeddabfe0b6b21f556c72a71e0454833d63e5

• Fix for pg_stat_activity putting client hostaddr into appname field
  • Bug fix: a820b4c32946c499a2d19846123840a0dad071b5 and 811969b218ac2e8030dfbbb05873344967461618

• Missing support of named convention for procedures
  • Bug fix: a8677e3ff6bb8ef78a9ba676faa647bba237b1c4

• 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: b1b71f16581fb5385fa9f9a663ffee271cdfaba5
  • Bug fix: 676858bcb4c4d9d2d5ee63a87dbff01085984ee0

• Partitions with bool partition keys

• wrong memory context used in FmgrInfo's contained in PartitionKey
  • Bug fix (HEAD): a4d56f583e7cff052c2699e62d867ae1c8fda4f3
  • Bug fix (PG 10): 5f11c6ec61a579d60347a5d13af7e42b17fadc56

• BGWORKER_BYPASS_ALLOWCONN used nowhere (infra part of on-line checksum switcher)
  • Bug fix: 9cad926eb876a30d58a5b39789098da83a6ef91c
  • Bug fix: 43cc4ee6340779f2a17fb5bab27355c2cb2e23a6

• Failed assertion in create_gather_path
  • Bug fix: dc1057fcd878d5c062c5c4c2b548af2be513b6ab

• Cold welcoming message when installing anything because of LLVM bitcode stuff

• jitflags in _outPlannedStmt and _readPlannedStmt treated as bool type
  • Bug fix: cfffe83ba82021a1819a656e7ec5c28fb3a99152

• wal_consistency_checking reports an inconsistency on master branch
  • Bug fix: 1667148a4dd98cea28b8b53d57dbc1eece1b0b5c

• Refreshing findoidjoins for v11
  • Bug fix: fbb99e5883d88687de4dbd832c2843f600ab3dd8

• Crash with partition pruning with handling of ArrayCoerceExpr
  • Bug fix: d758d9702e2f64f08565e18eb6cb7991efa2dc16

• Local partitioned indexes and pageinspect
  • Bug fix: bef5fcc36be3d08ec123889a0c82f5e07a63ff88

• breakage calling a procedure with a toasted parameter
  • Bug fix: 2efc924180f096070d684a712d6c162b6ae0a5e7

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