aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorVadim B. Mikheev <vadim4o@yahoo.com>1997-10-02 18:17:56 +0000
committerVadim B. Mikheev <vadim4o@yahoo.com>1997-10-02 18:17:56 +0000
commit4b74ca2d5795936b3e65da46a05d1ede75decc1e (patch)
treec9dc0ad837706bd633961ab27ec5dd8b0b4d1a35
parent91eb34e9ebaf7a00e4681297e447dab1b78eaea8 (diff)
downloadpostgresql-4b74ca2d5795936b3e65da46a05d1ede75decc1e.tar.gz
postgresql-4b74ca2d5795936b3e65da46a05d1ede75decc1e.zip
Updates for release
-rw-r--r--doc/FAQ17
-rw-r--r--doc/TODO18
2 files changed, 26 insertions, 9 deletions
diff --git a/doc/FAQ b/doc/FAQ
index 0ae1f29391a..8a2fe2c454f 100644
--- a/doc/FAQ
+++ b/doc/FAQ
@@ -1,7 +1,7 @@
Frequently Asked Questions (FAQ) for PostgreSQL
- Last updated: Mon Sep 29 22:45:58 EDT 1997
+ Last updated: Thu Oct 2 14:08:20 EDT 1997
Version: 6.2
Current maintainer: Bruce Momjian (maillist@candle.pha.pa.us)
@@ -241,12 +241,10 @@ Section 1: General Questions
1.6) Latest release of PostgreSQL
- The latest release of PostgreSQL is version 6.1.1, which was released
- on July 22, 1997. For information about what is new in 6.1.1, see our
+ The latest release of PostgreSQL is version 6.2, which was released
+ on October 2, 1997. For information about what is new in 6.2, see our
TODO list on our WWW page.
- We expect a 6.2 release at the end of September.
-
1.7) Is there a commercial version of PostgreSQL?
Illustra Information Technology (a wholly owned subsidiary of Informix
@@ -288,9 +286,11 @@ Section 1: General Questions
libpq, and then an install while the postmaster is temporarily
stopped.
+ Upgrading to 6.2 requires a dump and restore from previous releases.
+
Those ugrading from versions earlier than 1.09 must upgrade to 1.09
first without a dump/reload, then dump the data from 1.09, and then
- load it into 6.1.1.
+ load it into 6.2.
1.11) Are there ODBC drivers for PostgreSQL?
@@ -645,6 +645,9 @@ BYTEA bytea variable-length array of bytes
could select the same new id. This statement should be performed
within a transaction.
+ Yet another way is to use general trigger function autoinc()
+ from contrib/spi/autoinc.c
+
3.16) What are the pg_psort.XXX files in my database directory?
They are temporary sort files generated by the query executor. For
@@ -694,7 +697,7 @@ BYTEA bytea variable-length array of bytes
In 6.0, once a table is vacuumed, the creation time of a row may be
incorrect, causing time-traval to fail.
- The time-travel feature will be removed in 7.0.
+ The time-travel feature will be removed in 6.3.
3.20) What is an oid? What is a tid?
diff --git a/doc/TODO b/doc/TODO
index bd3564cc2b5..51f893d66ab 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -1,7 +1,7 @@
====================================================
TODO list (FAQ) for PostgreSQL
====================================================
-last updated: Mon Sep 29 22:45:43 EDT 1997
+last updated: Thu Oct 2 14:08:20 EDT 1997
current maintainer: Bruce Momjian (maillist@candle.pha.pa.us)
@@ -165,6 +165,7 @@ PORTABILITY
---------------------------------------------------------------------------
CHANGES IN THE 6.2 RELEASE
+
Bug Fixes
---------
Fix problems with pg_dump for inheritance, sequences, archive tables(Bruce)
@@ -181,6 +182,13 @@ Fix very old bug which made tuples changed/inserted by a commnd
Fix for SELECT null, 'fail' FROM pg_am (Patrick)
SELECT NULL as EMPTY_FIELD now allowed(Patrick)
Remove un-needed signal stuff from contrib/pginterface
+Fix OR (where x <> 1 or x isnull didn't return tuples with x NULL) (Vadim)
+Fix time_cmp function (Vadim)
+Fix handling of functions with non-attribute first argument in
+ WHERE clauses (Vadim)
+Fix GROUP BY when order of entries is different from order
+ in target list (Vadim)
+Fix pg_dump for aggregates without sfunc1 (Vadim)
Enhancements
------------
@@ -190,7 +198,8 @@ Added JDBC driver as an interface(Adrian & Peter)
pg_password utility
Return number of tuples inserted/affected by INSERT/UPDATE/DELETE etc.(Vadim)
Triggers implemented with CREATE TRIGGER (SQL3)(Vadim)
-SPI (Server Programming Interface) implemented to support triggers(Vadim)
+SPI (Server Programming Interface) allows execution of queries inside
+ C-functions (Vadim)
NOT NULL implemented (SQL92)(Robson Paniago de Miranda)
Include reserved words for string handling, outer joins, and unions(Thomas)
Implement extended comments ("/* ... */") using exclusive states(Thomas)
@@ -226,6 +235,10 @@ Reduce open() calls(Bruce)
psql: Add PAGER for \h and \?,\C fix
Fix for psql pager when no tty(Bruce)
New entab utility(Bruce)
+General trigger functions for referential integrity (Vadim)
+General trigger functions for time travel (Vadim)
+General trigger functions for AUTOINCREMENT/IDENTITY feature (Vadim)
+MOVE implementation (Vadim)
Source Tree Changes
-------------------
@@ -260,3 +273,4 @@ Add comments syntax regression test(Thomas)
Add PGINDENT and support program(Bruce)
Massive commit to run PGINDENT on all *.c and *.h files(Bruce)
Files moved to /src/tools directory(Bruce)
+SPI and Trigger programming guides (Vadim & D'Arcy)