PostgreSQL 9.0 Open Items

== Project Planning ==
* 9.0.0 was released at 20 September 2010
* First commit fest for 9.1 began 15 July 2010
== Issues ==
Remaining issues were moved to PostgreSQL 9.1 Open Items.
= Resolved Issues =
* Hot Standby needs to fully support VACUUM FULL
* BUG #5236: Aparent bug in ecpg
** rhaas says: fixed by mmeskes
* AbortOutOfAnyTransaction within ProcessInterrupts is *utterly* unsafe
* Archive recovery broken on EXEC_BACKEND (win32)
* Poor handling of error cases for deferrable unique constraints
* Replace ALTER TABLE ... SET STATISTICS DISTINCT with a general attribute-options facility
* pg_listener entries deleted under heavy NOTIFY load only on Windows
* B-tree dead page removal not safe with read-only transactions
* Bogus handling of relcache init files during HS replay
* Large object ownership and permissions are dumped incorrectly
* Fix pg_hba.conf handling of "@"
* Fix GSS crash
* incorrect exit code from psql with single transaction + violation of deferred FK constraint
* Duplicative display of exclusion constraints in psql \d
* 
* : , 
* : 
* Redefine smart shutdown in standby mode?
* Add the GUC parameter to specify the maximum number of log file segments held in pg_xlog directory to send to the standby server. Which is useful to avoid disk full in the primary.
* Starting recovery connections from a shutdown checkpoint
* Walreceiver and dblink are not interruptible on win32. - related thread
* Document changes to situations where WAL-logging can be skipped.
* Standalone backends run StartupXLOG in an incorrect environment
* Fix walsender to not assume template1 exists
* Improve behavior of SUSET GUC variables added by loadable modules
* Fix to_char('L') (localization) on Win32 when the operating system character encoding does not match the database encoding ,.
* don't allow walsender to consume superuser_reserved_connection slots, or during shutdown
** latest patch 2010-04-21
* Tuning of KnownAssignedXids module
* clarify HS error message when WAL settings are no good
** rhaas says: issue should be addressed by Heikki's WAL-level patch
* Documentation overflows TeX capacity while building PDFs
* 
* 
* Doc update for Hot Standby - PMState
* - 
* Type Mismatch Error in Set Returning Functions - change in user exposed behavior between versions
** 
== Resolved after Beta1 ==
* ERROR: btree index keys must be ordered by attribute - resolved commit
* - fixed by 
* 
* 
* Assertion failure in walreceiver - fixed
* HS/SR and smart shutdown - fixed
* - was Fuji-san's patch applied after ?
* 
* - someone got there first
* Smart shutdown gets stuck - patch to fix from Fuji Masao, associated test 
* (no action required)
* (no consensus on a better name)
* - done
* (it's there now)
* Add SIGCHLD catch to psql
* 
* 
* - 
* - Resolved? Simon thinks yes.
* - Simon says this is resolved
* - suggestion was to just document we'd need to remove the sanity check if we ever did add support for such a case (<>), 
* 
* 
* 
** tgl thinks we should leave that there for awhile, though I agree it's likely that the final decision will be "no change".
* 
** the machine ran out of disk space, but we would like to find out exactly what happened because UpdateControlFile should always update in place.
* 
* - patch being reviewed, 
* - 
* - 
== Resolved after Beta2 ==
* Standby instead of "slave" in documentation - 
* - 
* , 
* 
* 
* should we rename restartpoint_command to archive_cleanup_command? - 
* 
** proposed patch from Fujii Masao
* 
** 
* 
* 
** rhaas says: moving this back from the long-term issues bucket; this is a new issue in 9.0
** rhaas says: 
* 
** 
* 
* Now reverted.
* Mention in the incompatibilities section of the 9.0 release notes.
* 
* on Windows
* 
* 
* 
* 
* 
* 
== Resolved after Beta3 ==
* 
* 
* 
* 
* 
* 
== Resolved after Beta4 ==
* 
* RecordTransactionCommit does not respect wal_level GUC
* trace_recovery_messages inconsistency
* 
* 
== Resolved after RC1 ==
* pg_subtrans keeps bloating up in the standby
* 
* 
== Resolved in newer versions ==
* 
** Reduce the memory requirement for large ispell dictionaries
* - for SE-PostgreSQL integration in 9.1.
** New module contrib/sepgsql, an SE-Linux integration for PostgreSQL
= Long-term issues =
These items are not 9.0-specific or brand new features for 9.1.
They should be fixed or integrated eventually, but not for now.
== Known bugs and limitations ==
* COPY statements with paths containing non-ASCII characters under WinXP
** Todo#Miscellaneous Other: Deal with encoding issues for filenames in the server filesystem
* 
** , but still has some problems.
** 
* , patch included.
* It seems the consensus on this thread is that this won't get fixed for now, because it's a small issue
* Weird page allocation pattern
* Streaming replication and pg_xlogfile_name() - just throw an error in 9.0. better solution planned in 9.1.
* infinite repeat of 
** rhaas says: to the extent that there's an issue here, it seems we don't know what to do about it
* 
** rhaas says: should fix this for 9.1
== New features ==
* 
* Alternative return value for pg_cancel_backend
* - planned for 9.1. contrib module version is in github.
* 
* 
* 
* 
== Other issues ==
* CVS filtering of DOS newlines - git can solve the issue with "git config core.autocrlf input".
* 
** Not our bug, but we needed to communicate to third-party authors.
* 
** rhaas says: It would be nice to fix this, but we don't know how to investigate it, and it's not a release blocker.
* 
** tgl says: apparently just pilot error
** sriggs says: yes, user panic, not code PANIC
Category:PostgreSQL 9.0
Category:Open_Items