pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Open documentation items for 7.0 2+ messages / 2 participants [nested] [flat]
* Open documentation items for 7.0 @ 2000-04-08 22:03 Bruce Momjian <pgman@candle.pha.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Bruce Momjian @ 2000-04-08 22:03 UTC (permalink / raw) To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>; PostgreSQL-documentation <docs@postgreSQL.org> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Open documentation items for 7.0 @ 2000-04-09 18:34 Peter Eisentraut <peter_e@gmx.net> parent: Bruce Momjian <pgman@candle.pha.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2000-04-09 18:34 UTC (permalink / raw) To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>; PostgreSQL-documentation <docs@postgresql.org> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-04-09 18:34 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-04-08 22:03 Open documentation items for 7.0 Bruce Momjian <pgman@candle.pha.pa.us> 2000-04-09 18:34 ` Peter Eisentraut <peter_e@gmx.net>
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