From PostgreSQL wiki

Contents 1 Bugs 2 Planned Further work 3 Security Issues 4 At BETA time 5 Resolved Issues

Bugs

• missing need_initialization = false in reloptions code
• COPY staments with paths containing non-ASCII characters under WinXP
• BUG #5245: Full Server Certificate Chain Not Sent to client
• incorrect exit code from psql with single transaction + violation of deferred FK constraint
• Standalone backends run StartupXLOG in an incorrect environment
• Duplicative display of exclusion constraints in psql \d

Planned Further work

• Hot Standby TODO contains various items that need to be addressed for Hot Standby
• Streaming Replication TODO for v9.0 contains various items that need to be addressed.
• Improve behavior of SUSET GUC variables added by loadable modules?

Security Issues

• ALTER ROLE/DATABASE RESET ALL versus security

At BETA time

• Send out summary of new features/changes to other projects e.g. send COPY changes to ETL vendors

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