@@ -6,7 +6,7 @@ previous releases of PostgreSQL.
66
77Bug Fixes
88---------
9- Fix problems with pg_dump foriheritance , sequences, archive tables(Bruce)
9+ Fix problems with pg_dump forinheritance , sequences, archive tables(Bruce)
1010Fix compile errors on overflow due to shifts, unsigned, and bad prototypes
1111 from Solaris, (Diab Jerius)
1212Fix bugs in line arithmetic which resulted in bad intersection
@@ -21,6 +21,7 @@ Fix very old bug which made tuples changed/inserted by a commnd
2121updated tuples, etc).(Vadim)
2222Fix for SELECT null, 'fail' FROM pg_am (Patrick)
2323SELECT NULL as EMPTY_FIELD now allowed(Patrick)
24+ Remove un-needed signal stuff from contrib/pginterface
2425
2526Enhancements
2627------------
@@ -31,25 +32,19 @@ Add distance() routines for circle-polygon, polygon-polygon(Thomas)
3132Check explicitly for points and polygons contained within polygons
3233using an axis-crossing algorithm. (Thomas)
3334Add routine to convert circle-box(Thomas)
34- Merge conflicting operators for different geometric data types
35- (the point type especially had operators which were
36- weirdly dissimilar from the other types)(Thomas)
35+ Merge conflicting operators for different geometric data types(Thomas)
3736Replace distance operator "<===>" with "<->"(Thomas)
3837Replace "above" operator "!^" with ">^"
3938and "below" operator "!|" with "<^"(Thomas)
4039Add routines for text trimming on both ends, substring, and string position(Thomas)
41- Add new operators and functions for geometric types(Thomas)
4240Add text concatenation operator and function(Thomas)
4341Add text trim function for SQL92 support(Thomas)
4442Added conversion routines circle(box) and poly(circle)(Thomas)
45- Use better routines from geometry library(Thomas)
4643Allow use parameters in target list having aggregates in functions(Vadim)
47- Allow internal sorts to be stored in memory rather than in files(Bruce)
44+ Allow internal sorts to be stored in memory rather than in files(Bruce & Vadim )
4845Added JDBC driver as an interface(Adrian & Peter)
4946Reduce open() calls(Bruce)
5047NOT NULL implementation (Robson Paniago de Miranda).
51- CHECK/DEFAULT syntax(Vadim)
52- Syntax for [CONSTRAINT name] CHECK ...(Vadim)
5348Allow functions and operators on internally-identical types to succeed(Bruce)
5449Speed up backend startup after profiling analysis(Bruce)
5550pg_password utility
@@ -65,20 +60,21 @@ Modify definitions of operators to remove some restrictions on characters
6560Fix for psql pager when no tty(Bruce)
6661Add // comments(Bruce)
6762New entab utility(Bruce)
68- New system relations to store DEFAULT/ CHECK expressions (Vadim)
69- Store CHECK infos on CREATE TABLE(Vadim )
63+ CHECK/DEFAULT constraints implemented (Vadim)
64+ CHECK/DEFAULT syntax additions(Thomas )
7065Default GEQO parameter is now 8(Bruce)
7166Define DOUBLE PRECISION, INTERVAL, CHARACTER, and
7267CHARACTER VARYING (SQL-92)(Thomas)
7368Define EXTRACT(), POSITION(), SUBSTRING(), and TRIM() (SQL-92)(Thomas)
69+ Inline frequently called functions for performance(Bruce)
7470
7571Source Tree Changes
7672-------------------
7773HPUX 10 patches (Vladimir Turin)
7874Added SCO support, (Daniel Harris)
7975mkLinux patches (Tatsuo Ishii)
8076Change box terminology from "length" to "width"(Thomas)
81- Deprecate temporary unstored slope fields(Thomas)
77+ Deprecate temporary unstored slope fields in geometric code (Thomas)
8278Remove restart instructions from INSTALL(Bruce)
8379Look in /usr/ucb first for install(Bruce)
8480Fix c++ copy example code(Thomas)