Thread: Open documentation items for 7.0

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

Bruce Momjian writes:

> > 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.

initlocation is up to date, I don't see what could be missing. The only
change to ipcclean was that it now works on Linux, which it never did
before.

> > New C-routines to implement a BIT and BIT VARYING type in /contrib
> >         (Adriaan Joubert)
>
> Not documented.  New for 7.0.

I don't think there's a lot to document as it doesn't work at all. See
also separate rant.

> > Make ISO date style (2000-02-16 09:33) the default (Thomas)
>
> Updated set man page.  Not sure where else this goes.

datatype.sgml, but that's already up to speed.

> > Add NATIONAL CHAR [ VARYING ]

Not here:

peter=# create table t2 (x national character(10));
CREATE
peter=# \d t2
           Table "t2"
 Attribute |   Type   | Modifier
-----------+----------+----------
 x         | char(10) |

peter=# insert into t2 values (n'fooz');
ERROR:  Unable to locate type name 'n' in catalog


Hmm, I can add parsing support for non-existing datatypes by the dozen!
:-/ Openly admitting "I can't do this" is always better than silently
doing something else.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden