Received: from candle.pha.pa.us (pgman@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA50938; Sat, 8 Apr 2000 18:04:26 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id SAA19867; Sat, 8 Apr 2000 18:03:53 -0400 (EDT) From: Bruce Momjian Message-Id: <200004082203.SAA19867@candle.pha.pa.us> Subject: Open documentation items for 7.0 To: PostgreSQL-development , PostgreSQL-documentation Date: Sat, 8 Apr 2000 18:03:53 -0400 (EDT) X-Mailer: ELM [version 2.4ME+ PL72 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/22 Thanks to Tom Lane, we now have a list of documentation updates needed for 7.0. Can people submit patches or comment on these so we can get this list emptied? --------------------------------------------------------------------------- > Add SET FSYNC and SHOW PG_OPTIONS commands(Massimo) Are any of these documented. We now have a sample file. Is that enough? > Add CmdTuples() to libpq++(Vince) > New CREATE CONSTRAINT TRIGGER and SET CONSTRAINTS commands(Jan) > 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) Nees more work. > Allow WHERE restriction on ctid (physical heap location) (Hiroshi) Not documented; not quite sure where to put it, either. > Add ecpg EXEC SQL IFDEF, EXEC SQL IFNDEF, EXEC SQL ELSE, EXEC SQL ELIF > and EXEC SQL ENDIF directives ecpg.sgml? > Add pg_ctl script to control backend startup (Tatsuo) > Add postmaster.opts.default file to store startup flags (Tatsuo) > and postmaster.pid file In progress as part of pg_ctl. > Updated user interfaces on initdb, initlocation, pg_dump, ipcclean (Peter E) initlocation and pg_dump man pages still need to be updated; not sure about ipcclean. > Add ALTER TABLE ... ADD FOREIGN KEY (Stephan Szabo) > 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) Not documented. Not sure we want to seeing as they are mostly disabled. > New libpq functions PQsetClientEncoding(), PQclientEncoding() (Tatsuo) Documented, but only in README.mb. Is that OK? > New lztext data type for compressed text fields Not documented. I think we want to document it, no? > New C-routines to implement a BIT and BIT VARYING type in /contrib > (Adriaan Joubert) Not documented. New for 7.0. > Make ISO date style (2000-02-16 09:33) the default (Thomas) Updated set man page. Not sure where else this goes. > Add NATIONAL CHAR [ VARYING ] > Improved TRANSLATE() function Only mentioned in Table 5-4, which hardly gives room to explain... -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026