A dump/restore is required for those wishing to migrate data from previous releases of PostgreSQL.
This migration requires a complete dump of the 1.09 database and a restore of the database in 6.0.
Those migrating from earlier 1.* releases should first upgrade to 1.09 because the COPY output format was improved from the 1.02 release.
Bug Fixes---------ALTER TABLE bug - running postgress process needs to re-read table definitionAllow vacuum to be run on one table or entire database(Bruce)Array fixesFix array over-runs of memory writes(Kurt)Fix elusive btree range/non-range bug(Dan)Fix for hash indexes on some types like time and dateFix for pg_log size explosionFix permissions on lo_export()(Bruce)Fix unitialized reads of memory(Kurt)Fixed ALTER TABLE ... char(3) bug(Bruce)Fixed a few small memory leaksFixed EXPLAIN handling of options and changed full_path option nameFixed output of group acl privilegesMemory leaks (hunt and destroy with tools like Purify(Kurt)Minor improvements to rules systemNOTIFY fixesNew asserts for run-checkingOverhauled parser/analyze code to properly report errors and increase speedPg_dump -d now handles NULL's properly(Bruce)Prevent SELECT NULL from crashing server (Bruce)Properly report errors when INSERT ... SELECT columns did not matchProperly report errors when insert column names were not correctpsql \g filename now works(Bruce)psql fixed problem with multiple statements on one line with multiple outputsRemoved duplicate system OIDsSELECT * INTO TABLE . GROUP/ORDER BY gives unlink error if table exists(Bruce)Several fixes for queries that crashed the backendStarting quote in insert string errors(Bruce)Submitting an empty query now returns empty status, not just " " query(Bruce)Enhancements------------Add EXPLAIN manual page(Bruce)Add UNIQUE index capability(Dan)Add hostname/user level access control rather than just hostname and userAdd synonym of != for <>(Bruce)Allow "select oid,* from table"Allow BY,ORDER BY to specify columns by number, or by non-alias table.column(Bruce)Allow COPY from the frontend(Bryan)Allow GROUP BY to use alias column name(Bruce)Allow actual compression, not just reuse on the same page(Vadim)Allow installation-configuration option to auto-add all local users(Bryan)Allow libpq to distinguish between text value '' and null(Bruce)Allow non-postgres users with createdb privs to destroydb'sAllow restriction on who can create C functions(Bryan)Allow restriction on who can do backend COPY(Bryan)Can shrink tables, pg_time and pg_log(Vadim & Erich)Change debug level 2 to print queries only, changed debug heading layout(Bruce)Change default decimal constant representation from float4 to float8(Bruce)European date format now set when postmaster is startedExecute lowercase function names if not found with exact caseFixes for aggregate/GROUP processing, allow 'select sum(func(x),sum(x+y) from z'Gist now included in the distrubution(Marc)Idend authentication of local users(Bryan)Implement BETWEEN qualifier(Bruce)Implement IN qualifier(Bruce)libpq has PQgetisnull()(Bruce)libpq++ improvementsNew options to initdb(Bryan)Pg_dump allow dump of OIDs(Bruce)Pg_dump create indexes after tables are loaded for speed(Bruce)Pg_dumpall dumps all databases, and the user tablePginterface additions for NULL values(Bruce)Prevent postmaster from being run as rootpsql \h and \? is now readable(Bruce)psql allow backslashed, semicolons anywhere on the line(Bruce)psql changed command prompt for lines in query or in quotes(Bruce)psql char(3) now displays as (bp)char in \d output(Bruce)psql return code now more accurate(Bryan?)psql updated help syntax(Bruce)Re-visit and fix vacuum(Vadim)Reduce size of regression diffs, remove timezone name difference(Bruce)Remove compile-time parameters to enable binary distributions(Bryan)Reverse meaning of HBA masks(Bryan)Secure Authentication of local users(Bryan)Speed up vacuum(Vadim)Vacuum now had VERBOSE option(Bruce)Source tree changes-------------------All functions now have prototypes that are compared against the callsAllow asserts to be disabled easly from Makefile.global(Bruce)Change oid constants used in code to #define namesDecoupled sparc and solaris defines(Kurt)Gcc -Wall compiles cleanly with warnings only from unfixable constructsMajor include file reorganization/reduction(Marc)Make now stops on compile failure(Bryan)Makefile restructuring(Bryan, Marc)Merge bsdi_2_1 to bsdi(Bruce)Monitor program removedName change from Postgres95 to PostgreSQLNew config.h file(Marc, Bryan)PG_VERSION now set to 6.0 and used by postmasterPortability additions, including Ultrix, DG/UX, AIX, and SolarisReduced the number of #define's, centeralized #define'sRemove duplicate OIDS in system tables(Dan)Remove duplicate system catalog info or report mismatches(Dan)Removed many os-specific #define'sRestructured object file generation/location(Bryan, Marc)Restructured port-specific file locations(Bryan, Marc)Unused/uninialized variables corrected
