Skip site navigation (1) Skip section navigation (2)

Doc updates

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Cc: PostgreSQL-documentation <docs(at)postgreSQL(dot)org>
Subject: Doc updates
Date: 2000-04-05 17:30:39
Message-ID: 200004051730.NAA05290@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
OK, can someone confirm which items still need to be done to update the
documentation?

I can't imagine they are all done, and I don't think we can release 7.0
without them all being done.

---------------------------------------------------------------------------


Remove ':' and ';' operators
Add TRUNCATE command to quickly truncate relation (Mike Mascari)
Add SET FSYNC and SHOW PG_OPTIONS commands(Massimo)
Improve CREATE FUNCTION to allow type conversion specification
        (Bernie Frankpitt)
Add CmdTuples() to libpq++(Vince)
New CREATE CONSTRAINT TRIGGER and SET CONSTRAINTS commands(Jan)
Allow CREATE FUNCTION WITH clause to be used for all language types
configure --enable-debug adds -g (Peter E)
configure --disable-debug removes -g (Peter E)
First real FOREIGN KEY constraint trigger functionality (Jan)
Add FOREIGN KEY ... MATCH FULL ... ON DELETE CASCADE (Jan)
Add FOREIGN KEY ... MATCH  referential actions (Don Baccus)
Allow WHERE restriction on ctid (physical heap location) (Hiroshi)
Move pginterface from contrib to interface directory, rename to pgeasy (Bruce)
Add Oracle's COMMENT ON command (Mike Mascari yahoo.
libpq's PQsetNoticeProcessor function now returns previous hook(Peter E)
Prevent PQsetNoticeProcessor from being set to NULL (Peter E)
Added psql LastOid variable to return last inserted oid (Peter E)
New libpq functions to allow asynchronous connections: PQconnectStart(),
   PQconnectPoll(), PQresetStart(), PQresetPoll(), PQsetenvStart(),
   PQsetenvPoll(), PQsetenvAbort (Ewan Mellor)
New libpq PQsetenv() function (Ewan Mellor)
create/alter user extension (Peter E)
New postmaster.pid and postmaster.opts under $PGDATA (Tatsuo)
New scripts for create/drop user/db (Peter E)
Major psql overhaul(Peter E)
Add const to libpq interface(Peter E)
New libpq function PQoidValue (Peter E)
Add aggregate(DISTINCT ...) (Tom)
Allow flag to control COPY input/output of NULLs (Peter E)
Add CREATE/ALTER/DROP GROUP (Peter E)
All administration scripts now support --long options (Peter E, Karel)
Vacuumdb script now supports --alldb option (Peter E)
Add ecpg EXEC SQL IFDEF, EXEC SQL IFNDEF, EXEC SQL ELSE, EXEC SQL ELIF
        and EXEC SQL ENDIF directives
Add pg_ctl script to control backend startup (Tatsuo)
Add postmaster.opts.default file to store startup flags (Tatsuo)
Allow --with-mb=SQL_ASCII
Add initdb --enable-multibyte option (Peter E)
Updated user interfaces on initdb, initlocation, pg_dump, ipcclean
(Peter E)
New plperl internal programming language (Mark Hollomon)
Add Oracle's to_char(), to_date(), to_datetime(), to_timestamp(), to_number()
        conversion functions (Karel Zak zf.jcu.cz>)
Add SELECT DISTINCT ON (expr [, expr ...]) targetlist ... (Tom)
Add ALTER TABLE ... ADD FOREIGN KEY (Stephan Szabo)
Add SESSION_USER as SQL92 keyword, same as CURRENT_USER (Thomas)
Implement column aliases (aka correlation names) and more join syntax
(Thomas)
Allow queries like SELECT a FROM t1 tx (a) (Thomas)
Allow queries like SELECT * FROM t1 NATURAL JOIN t2 (Thomas)
Implement REINDEX command (Hiroshi)
Accept ALL in aggregate function SUM(ALL col) (Tom)
Allow PQrequestCancel() to terminate when in waiting-for-lock state (Hiroshi)
New libpq functions PQsetClientEncoding(), PQclientEncoding() (Tatsuo)
Make libpq's PQconndefaults() thread-safe (Tom)
New lztext data type for compressed text fields
New C-routines to implement a BIT and BIT VARYING type in /contrib
        (Adriaan Joubert)
Make ISO date style (2000-02-16 09:33) the default (Thomas)
Add NATIONAL CHAR [ VARYING ]
New TIME WITH TIME ZONE type (Thomas)
Add round(), sqrt(), cbrt(), pow()
Rename NUMERIC power() to pow()
Improved TRANSLATE() function
Add Linux ARM.
Update for QNX (Kardos, Dr. Andreas)
Internally change datetime and timespan into timestamp and interval (Thomas)
configure --with-mb now deprecated (Tatsuo)
NetBSD fixes Johnny C. Lam stat.cmu.edu>
Fixes for Alpha compiles
New multibyte encodings

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Responses

pgsql-docs by date

Next:From: Tatsuo IshiiDate: 2000-04-06 01:58:06
Subject: Re: [HACKERS] Doc updates
Previous:From: Bruce MomjianDate: 2000-03-31 11:41:10
Subject: Function tables from my book

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-04-05 19:38:00
Subject: 7.1 items
Previous:From: Kovacs Zoltan SandorDate: 2000-04-05 15:17:46
Subject: Re: refint doesn't work well with BDE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group