1 PostgreSQL 6.1.1 Mon Jul 22 18:04:49 EDT 1997
2 -------------------------------------------------------------
4 This release does NOT require a dump/restore for those running 6.1.
6 Changes in this release
7 -----------------------
8 fix for SET with options (Thomas)
9 allow pg_dump/pg_dumpall to preserve ownership of all tables/objects(Bruce)
10 new psql \connect option allows changing usernames without chaning databases
11 fix for initdb --debug option(Yoshihiko Ichikawa))
12 lextest cleanup(Bruce)
14 fix date/time month boundary arithmetic(Thomas)
15 fix timezone daylight handling for some ports(Thomas, Bruce, Tatsuo)
16 timestamp overhauled to use standard functions(Thomas)
17 other code cleanup in date/time routines(Thomas)
18 psql's \d now case-insensitive(Bruce)
19 psql's backslash commands can now have trailing semicolon(Bruce)
20 fix memory leak in psql when using \g(Bruce)
21 major fix for endian handling of communication to server(Thomas, Tatsuo)
22 Fix for Solaris assembler and include files(Yoshihiko Ichikawa)
23 allow underscores in usernames(Bruce)
24 pg_dumpall now returns proper status, portability fix(Bruce)
27 PostgreSQL 6.1 Sun Jun 8 14:41:13 EDT 1997
28 -------------------------------------------------------------
30 A dump/restore is required for those wishing to migrate data from
31 previous releases of PostgreSQL.
35 packet length checking in library routines
36 lock manager priority patch
37 check for under/over flow of float8(Bruce)
38 multi-table join fix(Vadim)
39 SIGPIPE crash fix(Darren)
40 large object fixes(Sven)
41 allow btree indexes to handle NULLs(Vadim)
42 timezone fixes(D'Arcy)
43 select SUM(x) can return NULL on no rows(Thomas)
44 internal optimizer, executor bug fixes(Vadim)
45 fix problem where inner loop in < or <= has no rows(Vadim)
46 prevent re-commuting join index clauses(Vadim)
47 fix join clauses for multiple tables(Vadim)
48 fix hash, hashjoin for arrays(Vadim)
49 fix btree for abstime type(Vadim)
50 large object fixes(Raymond)
51 fix buffer leak in hash indices (Vadim)
52 fix rtree for use in inner scan (Vadim)
53 fix gist for use in inner scan, cleanups (Vadim, Andrea)
54 avoid unnecessary local buffers allocation (Vadim, Massimo)
55 fix local buffers leak in transaction aborts (Vadim)
56 fix file manager memmory leaks, cleanups (Vadim, Massimo)
57 fix storage manager memmory leaks (Vadim)
58 fix btree duplicates handling (Vadim)
59 fix deleted tuples re-incarnation caused by vacuum (Vadim)
60 fix SELECT varchar()/char() INTO TABLE made zero-length fields(Bruce)
61 many psql, pg_dump, and libpq memory leaks fixed using Purify (Igor)
65 attribute optimization statistics(Bruce)
66 much faster new btree bulk load code(Paul)
67 BTREE UNIQUE added to bulk load code(Vadim)
68 new lock debug code(Massimo)
69 massive changes to libpg++(Leo)
70 new GEQO optimizer speeds table multi-table optimization(Martin)
71 new WARN message for non-unique insert into unique key(Marc)
72 update x=-3, no spaces, now valid(Bruce)
73 remove case-sensitive identifier handling(Bruce,Thomas,Dan)
74 debug backend now pretty-prints tree(Darren)
75 new Oracle character functions(Edmund)
76 new plaintext password functions(Dan)
77 no such class or insufficient privilege changed to distinct messages(Dan)
78 new ANSI timestamp function(Dan)
79 new ANSI Time and Date types (Thomas)
80 move large chunks of data in backend(Martin)
81 multi-column btree indexes(Vadim)
82 new SET var TO value command(Martin)
83 update transaction status on reads(Dan)
84 new locale settings for character types(Oleg)
85 new SEQUENCE serial number generator(Vadim)
86 GROUP BY function now possible(Vadim)
87 re-organize regression test(Thomas,Marc)
88 new optimizer operation weights(Vadim)
89 new psql \z grant/permit option(Marc)
90 new MONEY data type(D'Arcy,Thomas)
91 tcp socket communication speed improved(Vadim)
92 new VACUUM option for attribute statistics, and for certain columns (Vadim)
93 many geometric type improvements(Thomas,Keith)
94 additional regression tests(Thomas)
95 new datestyle variable(Thomas,Vadim,Martin)
96 more comparison operators for sorting types(Thomas)
97 new conversion functions(Thomas)
98 new more compact btree format(Vadim)
99 allow pg_dumpall to preserve database ownership(Bruce)
100 new SET GEQO=# and R_PLANS variable(Vadim)
101 old (!GEQO) optimizer can use right-sided plans (Vadim)
102 typechecking improvement in SQL parser(Bruce)
103 new SET, SHOW, RESET commands(Thomas,Vadim)
104 new \connect database USER option
105 new destroydb -i option (Igor)
106 new \dt and \di psql commands (Darren)
107 SELECT "\n" now escapes newline (A. Duursma)
108 new geometry conversion functions from old format (Thomas)
112 new configuration script(Marc)
113 readline configuration option added(Marc)
114 OS-specific configuration options removed(Marc)
115 new OS-specific template files(Marc)
116 no more need to edit Makefile.global(Marc)
117 re-arrange include files(Marc)
118 nextstep patches (Gregor Hoffleit)
119 removed WIN32-specific code(Bruce)
120 removed postmaster -e option, now only postgres -e option (Bruce)
121 merge duplicate library code in front/backends(Martin)
122 now works with eBones, international Kerberos(Jun)
123 more shared library support
124 c++ include file cleanup(Bruce)
125 warn about buggy flex(Bruce)
126 DG-UX, Ultrix, Irix, AIX portability fixes
127 PostgreSQL 6.0 Wed Jan 29 00:19:54 EST 1997
128 -------------------------------------------------------------
130 A dump/restore is required for those wishing to migrate data from
131 previous releases of PostgreSQL.
135 ALTER TABLE bug - running postgress process needs to re-read table definition
136 Allow vacuum to be run on one table or entire database(Bruce)
138 Fix array over-runs of memory writes(Kurt)
139 Fix elusive btree range/non-range bug(Dan)
140 Fix for hash indexes on some types like time and date
141 Fix for pg_log size explosion
142 Fix permissions on lo_export()(Bruce)
143 Fix unitialized reads of memory(Kurt)
144 Fixed ALTER TABLE ... char(3) bug(Bruce)
145 Fixed a few small memory leaks
146 Fixed EXPLAIN handling of options and changed full_path option name
147 Fixed output of group acl permissions
148 Memory leaks (hunt and destroy with tools like Purify(Kurt)
149 Minor improvements to rules system
151 New asserts for run-checking
152 Overhauled parser/analyze code to properly report errors and increase speed
153 Pg_dump -d now handles NULL's properly(Bruce)
154 Prevent SELECT NULL from crashing server (Bruce)
155 Properly report errors when INSERT ... SELECT columns did not match
156 Properly report errors when insert column names were not correct
157 Psql \g filename now works(Bruce)
158 Psql fixed problem with multiple statements on one line with multiple outputs
159 Removed duplicate system oid's
160 SELECT * INTO TABLE . GROUP/ORDER BY gives unlink error if table exists(Bruce)
161 Several fixes for queries that crashed the backend
162 Starting quote in insert string errors(Bruce)
163 Submiting an empty query now returns empty status, not just " " query(Bruce)
167 Add EXPLAIN manual page(Bruce)
168 Add UNIQUE index capability(Dan)
169 Add hostname/user level access control rather than just hostname and user
170 Add synonym of != for <>(Bruce)
171 Allow "select oid,* from table"
172 Allow BY,ORDER BY to specify columns by number, or by non-alias table.column(Bruce)
173 Allow COPY from the frontend(Bryan)
174 Allow GROUP BY to use alias column name(Bruce)
175 Allow actual compression, not just reuse on the same page(Vadim)
176 Allow installation-configuration option to auto-add all local users(Bryan)
177 Allow libpq to distinguish between text value '' and null(Bruce)
178 Allow non-postgres users with createdb privs to destroydb's
179 Allow restriction on who can create C functions(Bryan)
180 Allow restriction on who can do backend COPY(Bryan)
181 Can shrink tables, pg_time and pg_log(Vadim & Erich)
182 Change debug level 2 to print queries only, changed debug heading layout(Bruce)
183 Change default decimal constant representation from float4 to float8(Bruce)
184 European date format now set when postmaster is started
185 Execute lowercase function names if not found with exact case
186 Fixes for aggregate/GROUP processing, allow 'select sum(func(x),sum(x+y) from z'
187 Gist now included in the distrubution(Marc)
188 Idend authentication of local users(Bryan)
189 Implement BETWEEN qualifier(Bruce)
190 Implement IN qualifier(Bruce)
191 Libpq has PQgetisnull()(Bruce)
193 New options to initdb(Bryan)
194 Pg_dump allow dump of oid's(Bruce)
195 Pg_dump create indexes after tables are loaded for speed(Bruce)
196 Pg_dumpall dumps all databases, and the user table
197 Pginterface additions for NULL values(Bruce)
198 Prevent postmaster from being run as root
199 Psql \h and \? is now readable(Bruce)
200 Psql allow backslashed, semicolons anywhere on the line(Bruce)
201 Psql changed command prompt for lines in query or in quotes(Bruce)
202 Psql char(3) now displays as (bp)char in \d output(Bruce)
203 Psql return code now more accurate(Bryan?)
204 Psql updated help syntax(Bruce)
205 Re-visit and fix vacuum(Vadim)
206 Reduce size of regression diffs, remove timezone name difference(Bruce)
207 Remove compile-time parameters to enable binary distributions(Bryan)
208 Reverse meaning of HBA masks(Bryan)
209 Secure Authentication of local users(Bryan)
210 Speed up vacuum(Vadim)
211 Vacuum now had VERBOSE option(Bruce)
215 All functions now have prototypes that are compared against the calls
216 Allow asserts to be disabled easly from Makefile.global(Bruce)
217 Change oid constants used in code to #define names
218 Decoupled sparc and solaris defines(Kurt)
219 Gcc -Wall compiles cleanly with warnings only from unfixable constructs
220 Major include file reorganization/reduction(Marc)
221 Make now stops on compile failure(Bryan)
222 Makefile restructuring(Bryan, Marc)
223 Merge bsdi_2_1 to bsdi(Bruce)
224 Monitor program removed
225 Name change from Postgres95 to PostgreSQL
226 New config.h file(Marc, Bryan)
227 PG_VERSION now set to 6.0 and used by postmaster
228 Portability additions, including Ultrix, DG/UX, AIX, and Solaris
229 Reduced the number of #define's, centeralized #define's
230 Remove duplicate OIDS in system tables(Dan)
231 Remove duplicate system catalog info or report mismatches(Dan)
232 Removed many os-specific #define's
233 Restructured object file generation/location(Bryan, Marc)
234 Restructured port-specific file locations(Bryan, Marc)
235 Unused/uninialized variables corrected
239 -------------------------------------------------------------
241 Sorry, we stopped keeping track of changes from 1.02 to 1.09. Some of
242 the changes listed in 6.0 were actually included in the 1.02.1 to 1.09
246 Postgres95 1.02 Thu Aug 1 18:00:00 EDT 1996
247 -------------------------------------------------------------
249 Source code maintainenance and development
250 * worldwide team of volunteers
251 * the source tree now in CVS at ftp.ki.net
252 * developers mailing list - pg95-dev@ki.net
255 * psql (and underlying libpq library) now has many more options for
256 formatting output, including HTML
257 * pg_dump now output the schema and/or the data, with many fixes to
258 enhance completeness.
259 * psql used in place of monitor in administration shell scripts.
260 monitor to be depreciated in next release.
261 * date/time functions enhanced
262 * NULL insert/update/comparison fixed/enhanced
263 * TCL/TK lib and shell fixed to work with both tck7.4/tk4.0 and tcl7.5/tk4.1
265 Bug Fixes (almost too numerous to mention)
268 * check for NULL pointer before dereferencing
272 * added SolarisX86 port
273 * added BSDI 2.1 port
276 Contributors (appologies to any missed)
277 * Kurt J. Lidl <lidl@va.pubnix.com>
278 (missed in first run, but no less important)
279 * Erich Stamberger <eberger@gewi.kfunigraz.ac.at>
280 * Jason Wright <jason@shiloh.vnet.net>
281 * Cees de Groot <C.deGroot@inter.NL.net>
282 * ernst.molitor@uni-bonn.de
283 * michael.siebenborn@ae3.Hypo.DE (Michael Siebenborn (6929))
284 * Brian E. Gallew <geek+@cmu.edu>
285 * Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>
286 * Adam Sussman <myddryn@vidya.com>
287 * Chris Dunlop <chris@onthe.net.au>
288 * Marc G. Fournier <scrappy@ki.net>
289 * Dan McGuirk <mcguirk@indirect.com>
290 * Dr_George_D_Detlefsen <drgeorge@ilt.com>
291 * Erich Stamberger <eberger@gewi.kfunigraz.ac.at>
292 * Massimo Dal Zotto <dz@cs.unitn.it>
293 * Randy Kunkee <kunkee@Starbase.NeoSoft.COM>
294 * Rick Weldon <rick@wisetech.com>
295 * Thomas van Reimersdahl <reimersd@dali.techinfo.rwth-aachen.de>
296 * david bennett <dave@bensoft.com>
297 * ernst.molitor@uni-bonn.de
298 * Julian Assange <proff@suburbia.net>
299 * Bruce Momjian <maillist@candle.pha.pa.us>
300 * Paul "Shag" Walmsley <ccshag@cclabs.missouri.edu>
301 * "Alistair G. Crooks" <azcb0@sde.uts.amdahl.com>
303 Postgres95 1.01 Fri Feb 23 18:20:36 PST 1996
304 -------------------------------------------------------------
306 * 1.01 is backwards compatible with 1.0 database provided the user
307 follow the steps outlined in the MIGRATION_from_1.0_to_1.01 file.
308 If those steps are not taken, 1.01 is not compatible with 1.0 database.
311 * added PQdisplayTuples() to libpq and changed monitor and psql to use it
312 * added NeXT port (requires SysVIPC implementation)
313 * added CAST .. AS ... syntax
314 * added ASC and DESC keywords
315 * added 'internal' as a possible language for CREATE FUNCTION
316 internal functions are C functions which have been statically linked
317 into the postgres backend.
318 * a new type "name" has been added for system identifiers (table names,
319 attribute names, etc.) This replaces the old char16 type. The
320 of name is set by the NAMEDATALEN #define in src/Makefile.global
321 * a readable reference manual that describes the query language.
322 * added host-based access control. A configuration file ($PGDATA/pg_hba)
323 is used to hold the configuration data. If host-based access control
324 is not desired, comment out HBA=1 in src/Makefile.global.
325 * changed regex handling to be uniform use of Henry Spencer's regex code
326 regardless of platform. The regex code is included in the distribution
327 * added functions and operators for case-insensitive regular expressions.
328 The operators are ~* and !~*.
329 * pg_dump uses COPY instead of SELECT loop for better performance
332 * fixed an optimizer bug that was causing core dumps when
333 functions calls were used in comparisons in the WHERE clause
334 * changed all uses of getuid to geteuid so that effective uids are used
335 * psql now returns non-zero status on errors when using -c
336 * applied public patches 1-14
338 Postgres95 1.0 Tue Sep 5 11:24:11 PDT 1995
339 -------------------------------------------------------------
342 * The copyright of Postgres 1.0 has been loosened to be freely modifiable
343 and modifiable for any purpose. Please read the COPYRIGHT file.
344 Thanks to Professor Michael Stonebraker for making this possible.
347 * date formats have to be MM-DD-YYYY (or DD-MM-YYYY if you're using
348 EUROPEAN STYLE). This follows SQL-92 specs.
349 * "delimiters" is now a keyword
352 * sql LIKE syntax has been added
353 * copy command now takes an optional USING DELIMITER specification.
354 delimiters can be any single-character string.
355 * IRIX 5.3 port has been added.
356 Thanks to Paul Walmsley (ccshag@everest.cclabs.missouri.edu) and others.
357 * updated pg_dump to work with new libpq
358 * \d has been added psql
359 Thanks to Keith Parks (emkxp01@mtcc.demon.co.uk)
360 * regexp performance for architectures that use POSIX regex has been
361 improved due to caching of precompiled patterns.
362 Thanks to Alistair Crooks (agc@uts.amdahl.com)
363 * a new version of libpq++
364 Thanks to William Wanders (wwanders@sci.kun.nl)
367 * arbitrary userids can be specified in the createuser script
368 * \c to connect to other databases in psql now works.
369 * bad pg_proc entry for float4inc() is fixed
370 * users with usecreatedb field set can now create databases without
371 having to be usesuper
372 * remove access control entries when the entry no longer has any
374 * fixed non-portable datetimes implementation
375 * added kerberos flags to the src/backend/Makefile
376 * libpq now works with kerberos
377 * typographic errors in the user manual have been corrected.
378 * btrees with multiple index never worked, now we tell you they don't
379 work when you try to use them
382 Postgres95 Beta 0.03 Fri Jul 21 14:49:31 PDT 1995
383 ------------------------------------------------------
384 Incompatible changes:
385 * BETA-0.3 IS INCOMPATIBLE WITH DATABASES CREATED WITH PREVIOUS VERSIONS
386 (due to system catalog changes and indexing structure changes).
387 * double-quote (") is deprecated as a quoting character for string literals;
388 you need to convert them to single quotes (').
389 * name of aggregates (eg. int4sum) are renamed in accordance with the
390 SQL standard (eg. sum).
391 * CHANGE ACL syntax is replaced by GRANT/REVOKE syntax.
392 * float literals (eg. 3.14) are now of type float4 (instead of float8 in
393 previous releases); you might have to do typecasting if you depend on it
394 being of type float8. If you neglect to do the typecasting and you assign
395 a float literal to a field of type float8, you may get incorrect values
397 * LIBPQ has been totally revamped so that frontend applications
398 can connect to multiple backends
399 * the usesysid field in pg_user has been changed from int2 to int4 to
400 allow wider range of Unix user ids.
401 * the netbsd/freebsd/bsd o/s ports have been consolidated into a
402 single BSD44_derived port. (thanks to Alistair Crooks)
404 SQL standard-compliance (the following details changes that makes postgres95
405 more compliant to the SQL-92 standard):
406 * the following SQL types are now built-in: smallint, int(eger), float, real,
407 char(N), varchar(N), date and time.
409 The following are aliases to existing postgres types:
412 float, real -> float4
413 char(N) and varchar(N) are implemented as truncated text types. In
414 addition, char(N) does blank-padding.
415 * single-quote (') is used for quoting string literals; '' (in addition to
416 \') is supported as means of inserting a single quote in a string
417 * SQL standard aggregate names (MAX, MIN, AVG, SUM, COUNT) are used
418 (Also, aggregates can now be overloaded, i.e. you can define your
419 own MAX aggregate to take in a user-defined type.)
420 * CHANGE ACL removed. GRANT/REVOKE syntax added.
421 - Privileges can be given to a group using the "GROUP" keyword.
423 GRANT SELECT ON foobar TO GROUP my_group;
424 The keyword 'PUBLIC' is also supported to mean all users.
426 Privileges can only be granted or revoked to one user or group
429 "WITH GRANT OPTION" is not supported. Only class owners can change
431 - The default access control is to to grant users readonly access.
432 You must explicitly grant insert/update access to users. To change
433 this, modify the line in
434 src/backend/utils/acl.h
435 that defines ACL_WORLD_DEFAULT
438 * the bug where aggregates of empty tables were not run has been fixed. Now,
439 aggregates run on empty tables will return the initial conditions of the
440 aggregates. Thus, COUNT of an empty table will now properly return 0.
441 MAX/MIN of an empty table will return a tuple of value NULL.
442 * allow the use of \; inside the monitor
443 * the LISTEN/NOTIFY asynchronous notification mechanism now work
444 * NOTIFY in rule action bodies now work
445 * hash indices work, and access methods in general should perform better.
446 creation of large btree indices should be much faster. (thanks to Paul
449 Other changes and enhancements:
450 * addition of an EXPLAIN statement used for explaining the query execution
451 plan (eg. "EXPLAIN SELECT * FROM EMP" prints out the execution plan for
453 * WARN and NOTICE messages no longer have timestamps on them. To turn on
454 timestamps of error messages, uncomment the line in
455 src/backend/utils/elog.h:
456 /* define ELOG_TIMESTAMPS */
457 * On an access control violation, the message
458 "Either no such class or insufficient privilege"
459 will be given. This is the same message that is returned when
460 a class is not found. This dissuades non-privileged users from
461 guessing the existence of privileged classes.
462 * some additional system catalog changes have been made that are not
466 * The -oid option has been added to the "pg_result" tcl command.
467 pg_result -oid returns oid of the last tuple inserted. If the
468 last command was not an INSERT, then pg_result -oid returns "".
469 * the large object interface is available as pg_lo* tcl commands:
470 pg_lo_open, pg_lo_close, pg_lo_creat, etc.
472 Portability enhancements and New Ports:
473 * flex/lex problems have been cleared up. Now, you should be able to use
474 flex instead of lex on any platforms. We no longer make assumptions of
475 what lexer you use based on the platform you use.
476 * The Linux-ELF port is now supported. Various configuration have been
477 tested: The following configuration is known to work:
478 kernel 1.2.10, gcc 2.6.3, libc 4.7.2, flex 2.5.2, bison 1.24
479 with everything in ELF format,
482 * ipcclean added to the distribution
483 ipcclean usually does not need to be run, but if your backend crashes
484 and leaves shared memory segments hanging around, ipcclean will
485 clean them up for you.
488 * the user manual has been revised and libpq documentation added.
490 Postgres95 Beta 0.02 (Thu May 25 16:54:46 PDT 1995)
491 ------------------------------------------------------
492 Incompatible changes:
493 * The SQL statement for creating a database is 'CREATE DATABASE' instead
494 of 'CREATEDB'. Similarly, dropping a database is 'DROP DATABASE' instead
495 of 'DESTROYDB'. However, the names of the executables 'createdb' and
496 'destroydb' remain the same.
499 * pgperl - a Perl (4.036) interface to Postgres95
500 * pg_dump - a utility for dumping out a postgres database into a
501 script file containing query commands. The script files are in a ASCII
502 format and can be used to reconstruct the database, even on other
503 machines and other architectures. (Also good for converting
504 a Postgres 4.2 database to Postgres95 database.)
506 The following ports have been incorporated into postgres95-beta-0.02:
507 * the NetBSD port by Alistair Crooks
508 * the AIX port by Mike Tung
509 * the Windows NT port by Jon Forrest (more stuff but not done yet)
510 * the Linux ELF port by Brian Gallew
512 The following bugs have been fixed in postgres95-beta-0.02:
513 * new lines not escaped in COPY OUT and problem with COPY OUT when first
515 * cannot type return to use the default user id in createuser
516 * SELECT DISTINCT on big tables crashes
517 * Linux installation problems
518 * monitor doesn't allow use of 'localhost' as PGHOST
519 * psql core dumps when doing \c or \l
520 * the "pgtclsh" target missing from src/bin/pgtclsh/Makefile
521 * libpgtcl has a hard-wired default port number
522 * SELECT DISTINCT INTO TABLE hangs
523 * CREATE TYPE doesn't accept 'variable' as the internallength
524 * wrong result using more than 1 aggregate in a SELECT
526 Postgres95 Beta 0.01 (Mon May 1 19:03:10 PDT 1995)
527 ------------------------------------------------------
projects / postgresql / blob