Thread: 6.5 Features list
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, Pennsylvania19026
> 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
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 justGOSUB without RETURN.
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
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
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!
> 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, Pennsylvania19026