Fixes for aggregates and PL/pgsql(Hiroshi)Fix for subquery crash(Vadim)Fix for libpq function PQfnumber and case-insensitive names(Bahman Rafatjoo)Fix for large object write-in-middle, no extra block, memory consumption(Tatsuo)Fix for pg_dump -d or -D and  quote special characters in INSERTRepair serious problems with dynahash(Tom)Fix INET/CIDR portability problemsFix problem with selectivity error in ALTER TABLE ADD COLUMN(Bruce)Fix executor so mergejoin of different column types works(Tom)Fix for Alpha OR selectivity bugFix OR index selectivity problem(Bruce)Fix so \d shows proper length for char()/varchar()(Ryan)Fix tutorial code(Clark)Improve destroyuser checking(Oliver)Fix for Kerberos(Rodney McDuff)Fix for dropping database while dirty buffers(Bruce)Fix so sequence nextval() can be case-sensitive(Bruce)Fix !!= operatorDrop buffers before destroying database files(Bruce)Fix case where executor evaluates functions twice(Tatsuo)Allow sequence nextval actions to be case-sensitive(Bruce)Fix optimizer indexing not working for negative numbers(Bruce)Fix for memory leak in executor with fjIsNullFix for aggregate memory leaks(Erik Riedel)Allow username containing a dash GRANT permissionsCleanup of NULL in inet typesClean up system爐able bugs(Tom)Fix problems of PAGER and \? command(Masaaki Sakaida)Reduce default multi-segment file size limit to 1GB(Peter)Fix for dumping of CREATE OPERATOR(Tom)Fix for backward scanning of cursors(Hiroshi Inoue)Fix for COPY FROM STDIN when using \i(Tom)Fix for subselect is compared inside an expression(Jan)Fix handling of error reporting while returning rows(Tom)Fix problems with reference to array types(Tom,Jan)Prevent UPDATE SET oid(Jan)Fix pg_dump so -t option can handle case-sensitive tablenamesFixes for GROUP BY in special cases(Tom, Jan)Fix for memory leak in failed queries(Tom)DEFAULT now supports mixed-case identifiers(Tom)Fix for multi-segment uses of DROP/RENAME table, indexes(Ole Gjerde)Disable use of pg_dump with both -o and -d options(Bruce)Allow pg_dump to properly dump GROUP permissions(Bruce)Fix GROUP BY in INSERT INTO table SELECT * FROM table2(Jan)Fix for computations in views(Jan)Fix for aggregates on array indexes(Tom)Fix for DEFAULT handles single quotes in value requiring too many quotesFix security problem with non-super users importing/exporting large objects(Tom)Rollback of transaction that creates table cleaned up properly(Tom)Fix to allow long table and column names to generate proper serial names(Tom)Enhancements------------Add "vacuumdb" utilitySpeed up libpq by allocating memory better(Tom)EXPLAIN all indices used(Tom)Implement CASE, COALESCE, NULLIF  expression(Thomas)New pg_dump table output format(Constantin)Add string min()/max() functions(Thomas)Extend new type coersion techniques to aggregates(Thomas)New moddatetime contrib(Terry)Update to pgaccess 0.96(Constantin)Add routines for single-byte "char" type(Thomas)Improved substr() function(Thomas)Improved multi-byte handling(Tatsuo)Multi-version concurrency control/MVCC(Vadim)New Serialized mode(Vadim)Fix for tables over 2gigs(Peter)New SET TRANSACTION ISOLATION LEVEL(Vadim)New LOCK TABLE IN ... MODE(Vadim)Update ODBC driver(Byron)New NUMERIC data type(Jan)New SELECT FOR UPDATE(Vadim)Handle "NaN" and "Infinity" for input values(Jan)Improved date/year handling(Thomas)Improved handling of backend connections(Magnus)New options ELOG_TIMESTAMPS and USE_SYSLOG options for log files(Massimo)New TCL_ARRAYS option(Massimo)New INTERSECT and EXCEPT(Stefan)New pg_index.indisprimary for primary key tracking(D'Arcy)New pg_dump option to allow dropping of tables before creation(Brook)Speedup of row output routines(Tom)New READ COMMITTED isolation level(Vadim)New TEMP tables/indexes(Bruce)Prevent sorting if result is already sorted(Jan)New memory allocation optimization(Jan)Allow psql to do \p\g(Bruce)Allow multiple rule actions(Jan)Added LIMIT/OFFSET functionality(Jan)Improve optimizer when joining a large number of tables(Bruce)New intro to SQL from S. Simkovics' Master's Thesis (Stefan, Thomas)New intro to backend processing from S. Simkovics' Master's Thesis (Stefan)Improved int8 support(Ryan Bradetich, Thomas, Tom)New routines to convert between int8 and text/varchar types(Thomas)New bushy plans, where meta-tables are joined(Bruce)Enable right-hand queries by default(Bruce)Allow reliable maximum number of backends to be set at configure time      (--with-maxbackends and postmaster switch (-N backends))(Tom)GEQO default now 10 tables because of optimizer speedups(Tom)Allow NULL=Var for MS-SQL portability(Michael, Bruce)Modify contrib check_primary_key() so either "automatic" or "dependent"(Anand)Allow psql \d on a view show query(Ryan)Speedup for LIKE(Bruce)Ecpg fixes/features, see src/interfaces/ecpg/ChangeLog file(Michael)JDBC fixes/features, see src/interfaces/jdbc/CHANGELOG(Peter)Make % operator have precedence like /(Bruce)Add new postgres -O option to allow system table structure changes(Bruce)Update contrib/pginterface/findoidjoins script(Tom)Major speedup in vacuum of deleted rows with indexes(Vadim) Allow non-SQL functions to run different versions based on arguments(Tom)Add -E option that shows actual queries sent by \dt and friends(Masaaki Sakaida)Add version number in startup banners for psql(Masaaki Sakaida)New contrib/vacuumlo removes large objects not referenced(Peter)New initialization for table sizes so non-vacuumed tables perform better(Tom)Improve error messages when a connection is rejected(Tom)Support for arrays of char() and varchar() fields(Massimo)Overhaul of hash code to increase reliability and performance(Tom)Update to PyGreSQL 2.4(D'Arcy)Changed debug options so -d4 and -d5 produce different node displays(Jan)New pg_options: pretty_plan, pretty_parse, pretty_rewritten(Jan)Better optimization statistics for system table access(Tom)Better handling of non-default block sizes(Massimo)Improve GEQO optimizer memory consumption(Tom)UNION now suppports ORDER BY of columns not in target list(Jan)Major libpq++ improvements(Vince Vielhaber)pg_dump now uses -z(ACL's) as default(Bruce)backend cache, memory speedups(Tom)have pg_dump do everything in one snapshot transaction(Vadim)fix for large object memory leakage, fix for pg_dumping(Tom)INET type now respects netmask for comparisonsMake VACUUM ANALYZE only use a readlock(Vadim)Allow VIEWs on UNIONS(Jan)pg_dump now can generate consistent snapshots on active databases(Vadim)Source Tree Changes-------------------Improve port matching(Tom)Portability fixes for SunOSAdd NT/Win32 backend port and enable dynamic loading(Magnus and Daniel Horak)New port to Cobalt Qube(Mips) running Linux(Tatsuo)Port to NetBSD/m68k(Mr. Mutsuki Nakajima)Port to NetBSD/sun3(Mr. Mutsuki Nakajima)Port to NetBSD/macppc(Toshimi Aoki)Fix for tcl/tk configuration(Vince)Removed CURRENT keyword for rule queries(Jan)NT dynamic loading now works(Daniel Horak)Add ARM32 support(Andrew McMurry)Better support for HPUX 11 and UnixwareImprove file handling to be more uniform, prevent file descriptor leak(Tom)New install commands for plpgsql(Jan)     </programlisting>    </para>   </sect2>  </sect1><sect1><title>Release 6.4.2</title><!--<docinfo><authorgroup><author><firstname>Bruce</firstname><surname>Momjian</surname></author></authorgroup><date>1999-12-20</date></docinfo>--><para>The 6.4.1 release was improperly packaged.  This also has one additionalbug fix.</para><sect2><title>Migration to v6.4.2</title><para>A dump/restore is <emphasis>not</emphasis> required for those running6.4.*.</para></sect2><sect2><title>Detailed Change List</title><para><programlisting>Fix for datetime constant problem on some platforms(Thomas)</programlisting></para></sect2></sect1><sect1><title>Release 6.4.1</title><!--<docinfo><authorgroup><author><firstname>Bruce</firstname><surname>Momjian</surname></author></authorgroup><date>1999-12-18</date></docinfo>--><para>This is basically a cleanup release for 6.4.  We have fixed a variety ofproblems reported by 6.4 users.</para><sect2><title>Migration to v6.4.1</title><para>A dump/restore is <emphasis>not</emphasis> required for those running6.4.</para></sect2><sect2><title>Detailed Change List</title><para><programlisting>Add pg_dump -N flag to force double quotes around identifiers.  This is	the default(Thomas)Fix for NOT in where clause causing crash(Bruce)EXPLAIN VERBOSE coredump fix(Vadim)Fix shared-library problems on LinuxFix test for table existance to allow mixed-case and whitespace in	the table name(Thomas)Fix a couple of pg_dump bugsConfigure matches template/.similar entries better(Tom)Change builtin function names from SPI_* to spi_*OR WHERE clause fix(Vadim)Fixes for mixed-case table names(Billy)contrib/linux/postgres.init.csh/sh fix(Thomas)libpq memory overrun fixSunOS fixes(Tom)Change exp() behavior to generate error on underflow(Thomas)pg_dump fixes for memory leak, inheritance constraints, layout changeupdate pgaccess to 0.93Fix prototype for 64-bit platformsMulti-byte fixes(Tatsuo)New ecpg man pageFix memory overruns(Tatsuo)Fix for lo_import() crash(Bruce)Better search for install program(Tom)Timezone fixes(Tom)HPUX fixes(Tom)Use implicit type coersion for matching DEFAULT values(Thomas)Add routines to help with single-byte (internal) character type(Thomas)Compilation of libpq for Win32 fixes(Magnus)Upgrade to PyGreSQL 2.2(D'Arcy)</programlisting></para></sect2></sect1><sect1><title>Release 6.4</title><!--<docinfo><authorgroup><author><firstname>Bruce</firstname><surname>Momjian</surname></author></authorgroup><date>1998-10-30</date></docinfo>--><para>There are <emphasis>many</emphasis> new features and improvements in this release.Thanks to our developers and maintainers, nearly every aspect of the systemhas received some attention since the previous release.Here is a brief, incomplete summary:<itemizedlist><listitem><para>Views and rules are now functional thanks to extensive new code in the rewrite rules system from Jan Wieck. He also wrote a chapter on itfor the <citetitle>Programmer's Guide</citetitle>.</para></listitem><listitem><para>Jan also contributed a second procedural language, PL/pgSQL, to go with theoriginal PL/pgTCL procedural language he contributed last release.</para></listitem><listitem><para>We have optional multiple-byte character set support from Tatsuo Iishito complement our existing locale support.</para></listitem><listitem><para>Client/server communications has been cleaned up, with better support forasynchronous messages and interrupts thanks to Tom Lane.</para></listitem><listitem><para>The parser will now perform automatic type coersion to match argumentsto available operators and functions, and to match columns and expressionswith target columns. This uses a generic mechanism which supportsthe type extensibility features of <productname>Postgres</productname>.There is a new chapter in the <citetitle>User's Guide</citetitle>which covers this topic.</para></listitem><listitem><para>Three new data types have been added. Two types, <type>inet</type> and <type>cidr</type>, support various formsof IP network, subnet, and machine addressing. There is now an 8-byte integertype available on some platforms. See the chapter on data typesin the <citetitle>User's Guide</citetitle> for details.A fourth type, <type>serial</type>, is now supported by the parser as anamalgam of the <type>int4</type> type, a sequence, and a unique index.</para></listitem><listitem><para>Several more <acronym>SQL92</acronym>-compatible syntax features have beenadded, including <command>INSERT DEFAULT VALUES</command></para></listitem><listitem><para>The automatic configuration and installation system has received someattention, and should be more robust for more platforms than it has everbeen.</para></listitem></itemizedlist></para><sect2><title>Migration to v6.4</title><para>A dump/restore using <application>pg_dump</application> or <application>pg_dumpall</application>is required for those wishing to migrate data from anyprevious release of <productname>Postgres</productname>.</para></sect2><sect2><title>Detailed Change List</title><para><programlisting>Bug Fixes---------Fix for a tiny memory leak in PQsetdb/PQfinish(Bryan)