1- PostgreSQL 6.2beta Sat Sep 13 21:53:27 EDT 1997
1+ PostgreSQL 6.2beta Sat Sep 27 07:20:16 PDT 1997
22-------------------------------------------------------------
33
44A dump/restore is required for those wishing to migrate data from
@@ -8,92 +8,94 @@ Bug Fixes
88---------
99Fix problems with pg_dump for inheritance, sequences, archive tables(Bruce)
1010Fix compile errors on overflow
10000
due to shifts, unsigned, and bad prototypes
11- from Solaris, (Diab Jerius)
12- Fix bugs in line arithmetic which resulted in bad intersection
13- calculations(Thomas)
14- Check explicitly for intersections at endpoints to avoid rounding
15- ugliness(Thomas)
11+ from Solaris(Diab Jerius)
12+ Fix bugs in geometric line arithmetic (bad intersection calculations)(Thomas)
13+ Check for geometric intersections at endpoints to avoid rounding ugliness(Thomas)
1614Catch non-functional delete attempts(Vadim)
1715Change time function names to be more consistent(Michael Reifenberg)
1816Check for zero divides(Michael Reifenberg)
1917Fix very old bug which made tuples changed/inserted by a commnd
20- visible to command itself (so we had multiple update of
21- updated tuples, etc). (Vadim)
18+ visible to the command itself (so we had multiple update of
19+ updated tuples, etc)(Vadim)
2220Fix for SELECT null, 'fail' FROM pg_am (Patrick)
2321SELECT NULL as EMPTY_FIELD now allowed(Patrick)
2422Remove un-needed signal stuff from contrib/pginterface
2523
2624Enhancements
2725------------
28- psql: Add PAGER for \h and \?,\C fix
26+ Default genetic optimizer GEQO parameter is now 8(Bruce)
27+ Allow use parameters in target list having aggregates in functions(Vadim)
28+ Added JDBC driver as an interface(Adrian & Peter)
29+ pg_password utility
30+ Return number of tuples inserted/affected by INSERT/UPDATE/DELETE etc.(Vadim)
31+ Triggers implemented with CREATE TRIGGER (SQL3)(Vadim)
32+ SPI (Server Programming Interface) implemented to support triggers(Vadim)
33+ NOT NULL implemented (SQL92)(Robson Paniago de Miranda)
34+ Include reserved words for string handling, outer joins, and unions(Thomas)
35+ Implement extended comments ("/* ... */") using exclusive states(Thomas)
36+ Add "//" single-line comments(Bruce)
37+ Remove some restrictions on characters in operator names(Thomas)
38+ DEFAULT and CONSTRAINT for tables implemented (SQL92)(Vadim & Thomas)
39+ Add text concatenation operator and function (SQL92)(Thomas)
40+ Support WITH TIME ZONE syntax (SQL92)(Thomas)
41+ Support INTERVAL <unit> TO <unit> syntax (SQL92)(Thomas)
42+ Define types DOUBLE PRECISION, INTERVAL, CHARACTER,
43+ and CHARACTER VARYING (SQL92)(Thomas)
44+ Define type FLOAT(p) and rudimentary DECIMAL(p,s), NUMERIC(p,s) (SQL92)(Thomas)
45+ Define EXTRACT(), POSITION(), SUBSTRING(), and TRIM() (SQL92)(Thomas)
46+ Define CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP (SQL92)(Thomas)
47+ Add syntax and warnings for UNION, HAVING, INNER and OUTER JOIN (SQL92)(Thomas)
48+ Add more reserved words, mostly for SQL92 compliance(Thomas)
2949Allow hh:mm:ss time entry for timespan/reltime types(Thomas)
3050Add center() routines for lseg, path, polygon(Thomas)
3151Add distance() routines for circle-polygon, polygon-polygon(Thomas)
3252Check explicitly for points and polygons contained within polygons
33- using an axis-crossing algorithm. (Thomas)
53+ using an axis-crossing algorithm(Thomas)
3454Add routine to convert circle-box(Thomas)
3555Merge conflicting operators for different geometric data types(Thomas)
3656Replace distance operator "<===>" with "<->"(Thomas)
37- Replace "above" operator "!^" with ">^"
38- and "below" operator "!|" with "<^"(Thomas)
57+ Replace "above" operator "!^" with ">^" and "below" operator "!|" with "<^"(Thomas)
3958Add routines for text trimming on both ends, substring, and string position(Thomas)
40- Add text concatenation operator and function(Thomas)
41- Add text trim function for SQL92 support(Thomas)
4259Added conversion routines circle(box) and poly(circle)(Thomas)
43- Allow use parameters in target list having aggregates in functions(Vadim)
4460Allow internal sorts to be stored in memory rather than in files(Bruce & Vadim)
45- Added JDBC driver as an interface(Adrian & Peter)
46- Reduce open() calls(Bruce)
47- NOT NULL implementation (Robson Paniago de Miranda).
4861Allow functions and operators on internally-identical types to succeed(Bruce)
4962Speed up backend startup after profiling analysis(Bruce)
50- pg_password utility
51- Number of tuples inserted/affected by INSERT/UPDATE/DELETE...(Vadim)
52- SPI manager(Vadim)
53- Triggers (Vadim)
54- Add detection and warnings for UNION and HAVING clauses(Thomas)
55- Add more reserved words, mostly for SQL92 compliance(Thomas)
56- Include reserved words for string handling, outer joins, and unions(Thomas)
57- Implement extended comments ("/* ... */") using exclusive states(Thomas)
58- Modify definitions of operators to remove some restrictions on characters
59- and character order(Thomas)
63+ Inline frequently called functions for performance(Bruce)
64+ Reduce open() calls(Bruce)
65+ psql: Add PAGER for \h and \?,\C fix
6066Fix for psql pager when no tty(Bruce)
61- Add // comments(Bruce)
6267New entab utility(Bruce)
63- CHECK/DEFAULT constraints implemented(Vadim)
64- CHECK/DEFAULT syntax additions(Thomas)
65- Default GEQO parameter is now 8(Bruce)
66- Define DOUBLE PRECISION, INTERVAL, CHARACTER, and
67- CHARACTER VARYING (SQL-92)(Thomas)
68- Define EXTRACT(), POSITION(), SUBSTRING(), and TRIM() (SQL-92)(Thomas)
69- Inline frequently called functions for performance(Bruce)
7068
7169Source Tree Changes
7270-------------------
7371HPUX 10 patches (Vladimir Turin)
7472Added SCO support, (Daniel Harris)
7573mkLinux patches (Tatsuo Ishii)
76- Change box terminology from "length" to "width"(Thomas)
74+ Change geometric box terminology from "length" to "width"(Thomas)
7775Deprecate temporary unstored slope fields in geometric code(Thomas)
7876Remove restart instructions from INSTALL(Bruce)
7977Look in /usr/ucb first for install(Bruce)
8078Fix c++ copy example code(Thomas)
8179Add -o to psql manual page(Bruce)
8280Prevent relname unallocated string length from being copied into database(Bruce)
8381Cleanup for NAMEDATALEN use(Bruce)
84- Fix pgproc names over 15 chars in output(Bruce)
82+ Fix pg_proc names over 15 chars in output(Bruce)
8583Add strNcpy() function(Bruce)
8684remove some (void) casts that are unnecessary(Bruce)
8785new interfaces directory(Marc)
8886Replace fopen() calls with calls to fd.c functions(Bruce)
8987Make functions static where possible(Bruce)
9088enclose unused functions in #ifdef NOT_USED(Bruce)
91- Fix for sunos4 difftime() call (Bruce)
89+ Remove call to difftime() in timestamp support to fix SunOS (Bruce & Thomas )
9290Changes for Digital Unix
9391Portability fix for pg_dumpall(Bruce)
9492Rename pg_attribute.attnvals to attdisbursion(Bruce)
95- intro/unix manual page now pgintro(Bruce)
96- built-in manual page now pgbuiltin(Bruce)
93+ "intro/unix" manual page now "pgintro"(Bruce)
94+ "built-in" manual page now "pgbuiltin"(Bruce)
95+ "drop" manual page now "drop_table"(Bruce)
96+ Add "create_trigger", "drop_trigger" manual pages(Thomas)
97+ Add constraints regression test(Vadim & Thomas)
98+ Add comments syntax regression test(Thomas)
9799Add PGINDENT and support program(Bruce)
98100Massive commit to run PGINDENT on all *.c and *.h files(Bruce)
99101Files moved to /src/tools directory(Bruce)
0 commit comments