From: Bruce Momjian <pgman@candle.pha.pa.us>
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
To: PostgreSQL-documentation <docs@postgreSQL.org>
Subject: Open documentation items for 7.0
Date: Sat, 8 Apr 2000 18:03:53 -0400 (EDT)
Message-ID: <200004082203.SAA19867@candle.pha.pa.us> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: pgman@candle.pha.pa.us, pgsql-hackers@postgreSQL.org, docs@postgreSQL.org
Subject: Re: Open documentation items for 7.0
In-Reply-To: <200004082203.SAA19867@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox