Open documentation items for 7.0

Started by Bruce Momjianabout 26 years ago2 messagesdocs
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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
#2Peter Eisentraut
peter_e@gmx.net
In reply to: Bruce Momjian (#1)
Re: Open documentation items for 7.0

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