Here is the list.  It is up-to-date as of Monday.  Let me know if I have
missed anything, or attributed something incorrectly to someone.

I will shortly add some descriptive text to the release.

---------------------------------------------------------------------------

Add "vacuumdb" utility
Fix text<->float8 and text<->float4 conversion functions(Tom)
Fix for creating tables with mixed-case constraints(Billy)
Speed up libpq by allocating memory better(Tom)
EXPLAIN all indices used(Tom)
Improve port matching(Tom)
Portability fixes for SunOS
Change exp()/pow() behavior to generate error on underflow/overflow(Jan)
Implement CASE expression(Thomas)
Fix bug in pg_dump -z
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(Constantin)
Fix problems in the muti-byte code(Tatsuo)
Fix case where executor evaluates functions twice(Tatsuo)
Memory overrun cleanups(Tatsuo)
Fix for lo_import crash(Tatsuo)
Adjust handling of data type names to suppress double quotes(Thomas)
Add routines for single-byte "char" type(Thomas)
Improved substr() function(Thomas)
Use type coersion for matching columns and DEFAULT(Thomas)
Add CASE statement support(Thomas)
Improved multi-byte handling(Tatsuo)
Add NT/Win32 backend port and enable dynamic loading(Magnus and Horak Daniel)
Multi-version concurrency control/MVCC(Vadim)
New Serialized mode(Vadim)
Upgrade to Pygress(D'Arcy)
New SET TRANSACTION ISOLATION LEVEL(Vadim)
New LOCK TABLE IN ... MODE(Vadim)
New port to Cobalt Qube(Mips) running Linux(Tatsuo)
Fix deadlock so it only checks once after one second of sleep(Bruce)
Port to NetBSD/m68k(Mr. Mutsuki Nakajima)
Port to NetBSD/sun3(Mr. Mutsuki Nakajima)
Update odbc version
New NUMERIC data type(Jan)
New SELECT FOR UPDATE(Vadim)
Handle "NaN" and "Infinity" for input values(Jan)
Better 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)
Fixes for aggregates and PL/pgsql(Hiroshi)
Speedup of row output routines(Tom)
JDBC improvements(Peter)
Fix for subquery crash(Vadim)
New READ COMMITTED isolation level(Vadim)
New TEMP tables/indexes(Bruce)
Prevent sorting of result is already sorted(Jan)
Fix for libpq function PQfnumber and case-insensitive names(Bahman Rafatjoo)
Fix for large object write-into-middle, remove extra block(Tatsuo)
New memory allocation optimization(Jan)
Allow psql to do \p\g(Bruce)
Allow multiple rule actions(Jan)
Fix for pg_dump -d or -D and  quote special characters in INSERT
Added LIMIT/OFFSET functionality(Jan)
Removed CURRENT keyword for rule queries(Jan)
Improve optimizer when joining a large number of tables(Bruce)
Addition of Stefan Simkovics' Master's Thesis to docs(Stefan)
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)
Repair serious problems with dynahash(Tom)
Fix INET/CIDR portability problems
Fix problem with selectivity error in ALTER TABLE ADD COLUMN(Bruce)
Fix executor so mergejoin of different column types works(Tom)
GEQO default now 11 tables because of optimizer speedups(Tom)
Fix for Alpha OR selectivity bug
Fix OR index selectivity problem(Bruce)
Allow btree/hash index on the int8 type(Ryan)
Allow Var = NULL for MS-SQL portability(Michael)
Fix so \d shows proper length for char()/varchar()(Ryan)
Fix tutorial code(Clark)
Improve destroyuser checking(Oliver)
Fix for Kerberos(Rodney McDuff)
Modify contrib check_primary_key() so either "automatic" or "dependent"(Anand)
Allow psql \d on a view show query(Ryan)
Speedup for LIKE(Bruce)
Fix for dropping database while dirty buffers(Bruce)
Fix so sequence nextval() can be case-sensitive(Bruce)
Fix for tcl/tk configuration(Vince)
STOP:  1999/03/15

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 18 Mar 1999 22:39:40 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
6.5 Features list
> Fix case where executor evaluates functions twice(Tatsuo)

I don't think above was done by me. Maybe Hirosi?

>Port to NetBSD/macppc(Toshimi Aoki)

Also could you add above?

BTW, I'm going to add a new Cyrillic support to the multi-byte support
next week (around 3/23-3/35) if this is not too late. Yes, I know we
already have the rcode support. But it seems to have some difficulties
with on-the-fly encoding conversion.  (Oleg, is this explanation
correct?)

Anyway, the new Cyrillic support will not kill existing rcode support. 
In another word, users can choose whatever Cyrillic support they like.
---
Tatsuo Ishii



Fri, 19 Mar 1999 23:05:52 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: [HACKERS] 6.5 Features list 
Hi!

On Fri, 19 Mar 1999, Tatsuo Ishii wrote:
> BTW, I'm going to add a new Cyrillic support to the multi-byte support
> next week (around 3/23-3/35) if this is not too late. Yes, I know we
> already have the rcode support. But it seems to have some difficulties
> with on-the-fly encoding conversion.  (Oleg, is this explanation
> correct?)

   RECODE has no difficulties - it just does not allow to choose what
encoding a client want to get. RECODE chooses client encoding by client IP
address, what is very unflexible.

> Anyway, the new Cyrillic support will not kill existing rcode support. 
> In another word, users can choose whatever Cyrillic support they like.

   I think new cyrillic support makes RECODE obsolete. Somewhere in the
future we should remove RECODE, I think.

> ---
> Tatsuo Ishii

Oleg.
---- 
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.


Fri, 19 Mar 1999 17:18:10 +0300 (MSK)
Oleg Broytmann <phd@sun.med.ru>
Re: [HACKERS] 6.5 Features list 
On Fri, 19 Mar 1999, Tatsuo Ishii wrote:

> Date: Fri, 19 Mar 1999 23:05:52 +0900
> From: Tatsuo Ishii <t-ishii@sra.co.jp>
> To: Bruce Momjian <maillist@candle.pha.pa.us>
> Cc: PostgreSQL-development <hackers@postgreSQL.org>
> Subject: Re: [HACKERS] 6.5 Features list 
> 
> > Fix case where executor evaluates functions twice(Tatsuo)
> 
> I don't think above was done by me. Maybe Hirosi?
> 
> >Port to NetBSD/macppc(Toshimi Aoki)
> 
> Also could you add above?
> 
> BTW, I'm going to add a new Cyrillic support to the multi-byte support
> next week (around 3/23-3/35) if this is not too late. Yes, I know we
> already have the rcode support. But it seems to have some difficulties
> with on-the-fly encoding conversion.  (Oleg, is this explanation
> correct?)

Here is Oleg Bartunov not Oleg Broytman :-) Several months ago we discussed
cyrillic support with mb code, but I was too busy and thanks to Oleg Broytmann
who kindly agreed to communnicate with you.  Short question:
Will ALTER TABLE has support for changing of encoding for existing
data ?
Not really difficulties but your mb support is an elegant and flexible way to
do on-fly encoding support. rcode requires some fixed pre-configuration
based on host/net  definitions.


> 
> Anyway, the new Cyrillic support will not kill existing rcode support. 
> In another word, users can choose whatever Cyrillic support they like.

rcode IMHO could be removed from  the source if mb will works ok.

	Best regards,
		Oleg

> ---
> Tatsuo Ishii
> 
> 
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Fri, 19 Mar 1999 18:15:59 +0300 (MSK)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] 6.5 Features list 
Hi,

> Here is Oleg Bartunov not Oleg Broytman :-)

Wao. Is Oleg a pupular first name?

> Several months ago we discussed
> cyrillic support with mb code, but I was too busy and thanks to Oleg Broytmann
> who kindly agreed to communnicate with you.  Short question:
> Will ALTER TABLE has support for changing of encoding for existing
> data ?

No. The backend encoding can be defined for each database but not for
each table. To have a different encoding for each table, we need an
encoding/chaset attribute in the pg_class table. Someday I would try
this (probably with support for NATIONAL CHARACTER).

Is this a serious issue for you?

> Not really difficulties but your mb support is an elegant and flexible way to
> do on-fly encoding support. rcode requires some fixed pre-configuration
> based on host/net  definitions.

Thanks for choosing MB support.

BTW, mb(multi-byte support) may not be a suitable naming, since
cyrillic is definitely a single byte encoding:-)
---
Tatsuo Ishii

Sat, 20 Mar 1999 11:04:24 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: [HACKERS] 6.5 Features list 
On Thu, Mar 18, 1999 at 10:39:40PM -0500, Bruce Momjian wrote:
> Here is the list.  It is up-to-date as of Monday.  Let me know if I have
> missed anything, or attributed something incorrectly to someone.
> ...

I think I forgot to submit the ecpg changes list. Hopefully I'm not too late
for this. Here we go:

Added the following commands:
	- exec sql whenever sqlwarning
	- exec sql prepare
	- exec sql execute
	- exec sql deallocate prepare
	- exec sql type
	- exec sql var
	- exec sql free
	- exec sql declare statement
Added ECPGstatus() function.
Added support for different connections in one program.
Added support for unions.
Added auto-allocating for host arrays.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!

Sat, 20 Mar 1999 20:19:47 +0100
Michael Meskes <meskes@postgresql.org>
Re: [HACKERS] 6.5 Features list
> On Thu, Mar 18, 1999 at 10:39:40PM -0500, Bruce Momjian wrote:
> > Here is the list.  It is up-to-date as of Monday.  Let me know if I have
> > missed anything, or attributed something incorrectly to someone.
> > ...
> 
> I think I forgot to submit the ecpg changes list. Hopefully I'm not too late
> for this. Here we go:

Added this:

	Ecpg fixes/features, see src/interfaces/ecpg/ChangeLog file(Michael)
	Jdbc fixes/features, see src/interfaces/jdbc/CHANGELOG(Peter)

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sat, 20 Mar 1999 21:07:30 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] 6.5 Features list