11====================================================
22TODO list (FAQ) for PostgreSQL
33====================================================
4- last updated:Mon Sep 29 22:45:43 EDT 1997
4+ last updated:Thu Oct 2 14:08:20 EDT 1997
55
66current maintainer:Bruce Momjian (maillist@candle.pha.pa.us)
77
@@ -165,6 +165,7 @@ PORTABILITY
165165---------------------------------------------------------------------------
166166
167167 CHANGES IN THE 6.2 RELEASE
168+
168169Bug Fixes
169170---------
170171Fix 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
181182Fix for SELECT null, 'fail' FROM pg_am (Patrick)
182183SELECT NULL as EMPTY_FIELD now allowed(Patrick)
183184Remove un-needed signal stuff from contrib/pginterface
185+ Fix OR (where x <> 1 or x isnull didn't return tuples with x NULL) (Vadim)
186+ Fix time_cmp function (Vadim)
187+ Fix handling of functions with non-attribute first argument in
188+ WHERE clauses (Vadim)
189+ Fix GROUP BY when order of entries is different from order
190+ in target list (Vadim)
191+ Fix pg_dump for aggregates without sfunc1 (Vadim)
184192
185193Enhancements
186194------------
@@ -190,7 +198,8 @@ Added JDBC driver as an interface(Adrian & Peter)
190198pg_password utility
191199Return number of tuples inserted/affected by INSERT/UPDATE/DELETE etc.(Vadim)
192200Triggers implemented with CREATE TRIGGER (SQL3)(Vadim)
193- SPI (Server Programming Interface) implemented to support triggers(Vadim)
201+ SPI (Server Programming Interface) allows execution of queries inside
202+ C-functions (Vadim)
194203NOT NULL implemented (SQL92)(Robson Paniago de Miranda)
195204Include reserved words for string handling, outer joins, and unions(Thomas)
196205Implement extended comments ("/* ... */") using exclusive states(Thomas)
@@ -226,6 +235,10 @@ Reduce open() calls(Bruce)
226235psql: Add PAGER for \h and \?,\C fix
227236Fix for psql pager when no tty(Bruce)
228237New entab utility(Bruce)
238+ General trigger functions for referential integrity (Vadim)
239+ General trigger functions for time travel (Vadim)
240+ General trigger functions for AUTOINCREMENT/IDENTITY feature (Vadim)
241+ MOVE implementation (Vadim)
229242
230243Source Tree Changes
231244-------------------
@@ -260,3 +273,4 @@ Add comments syntax regression test(Thomas)
260273Add PGINDENT and support program(Bruce)
261274Massive commit to run PGINDENT on all *.c and *.h files(Bruce)
262275Files moved to /src/tools directory(Bruce)
276+ SPI and Trigger programming guides (Vadim & D'Arcy)