From 531685c20ce4a2467c73701bfb56f7a1817e2f71 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 14 Nov 2003 17:54:16 +0000 Subject: [PATCH] Update FAQ and TODO for 7.4. --- doc/FAQ | 10 +++++----- doc/TODO | 12 +++++++++--- doc/src/FAQ/FAQ.html | 11 ++++++----- 3 files changed, 20 insertions(+), 13 deletions(-) diff --git a/doc/FAQ b/doc/FAQ index bec9455b98..8fb7ee498c 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Wed Oct 29 15:19:43 EST 2003 + Last updated: Mon Nov 10 17:47:25 EST 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -244,9 +244,9 @@ http://www.PostgreSQL.org - There is also an IRC channel on EFNet and OpenProjects, channel - #PostgreSQL. I use the Unix command irc -c '#PostgreSQL' "$USER" - irc.phoenix.net. + There is also an IRC channel on EFNet and Freenode, channel + #PostgreSQL. You can use the Unix command irc -c '#PostgreSQL' "$USER" + irc.phoenix.net. or irc -c '#PostgreSQL' "$USER" irc.freenode.net. A list of commercial support companies is available at http://techdocs.postgresql.org/companies.php. @@ -349,7 +349,7 @@ Web page comparing PostgreSQL to MySQL at http://openacs.org/philosophy/why-not-mysql.html Also, MySQL is is a company that distributes its products via open source, not - an open source development community ilke PostgreSQL. + an open source development community like PostgreSQL. Reliability We realize that a DBMS must be reliable, or it is worthless. We diff --git a/doc/TODO b/doc/TODO index c9b84308ac..2644ab7341 100644 --- a/doc/TODO +++ b/doc/TODO @@ -1,6 +1,6 @@ TODO list for PostgreSQL ======================== -Last updated: Sun Oct 26 00:43:53 EDT 2003 +Last updated: Tue Nov 11 23:10:40 EST 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -206,6 +206,12 @@ Commands (Christopher) * Add optional textual message to NOTIFY * Allow more ISOLATION LEVELS to be accepted, but issue a warning for them +* Allow CREATE TABLE foo (f1 INT CHECK (f1 > 0) CHECK (f1 < 10)) to work + by searching for non-conflicting constraint names, and prefix with table name +* Use more reliable method for CREATE DATABASE to get a consistent copy of db +* Have psql \dn show only visible schemas using current_schemas() +* Have psql '\i ~/' actually load files it displays from home dir +* Ignore temporary tables from other session when processing inheritance * ALTER @@ -395,7 +401,7 @@ Fsync Cache ===== * Shared catalog cache, reduce lseek()'s by caching table size in shared area -* Add free-behind capability for large sequential scans (Bruce) +* Add free-behind capability for large sequential scans (fadvise) * Consider use of open/fcntl(O_DIRECT) to minimize OS caching * Make blind writes go through the file descriptor cache * Cache last known per-tuple offsets to speed long tuple access @@ -516,7 +522,7 @@ Source Code * Acquire lock on a relation before building a relcache entry for it * Research interaction of setitimer() and sleep() used by statement_timeout * Add checks for fclose() failure -* Change CVS $Id: TODO,v 1.1161 2003/10/26 04:43:55 momjian Exp $ to $PostgreSQL: pgsql/doc/TODO,v 1.1161 2003/10/26 04:43:55 momjian Exp $ +* Change CVS $Id: TODO,v 1.1161.2.1 2003/11/14 17:54:15 momjian Exp $ to $PostgreSQL: pgsql/doc/TODO,v 1.1161.2.1 2003/11/14 17:54:15 momjian Exp $ * Exit postmaster if postgresql.conf can not be opened * Rename /scripts directory because they are all C programs now * Allow the regression tests to start postmaster with -i so the tests diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index b01bbef36e..c785c2eb7c 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Wed Oct 29 15:19:43 EST 2003

+

Last updated: Mon Nov 10 17:47:25 EST 2003

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -316,9 +316,10 @@ http://www.PostgreSQL.org -

There is also an IRC channel on EFNet and OpenProjects, - channel #PostgreSQL. I use the Unix command irc -c - '#PostgreSQL' "$USER" irc.phoenix.net.

+

There is also an IRC channel on EFNet and Freenode, + channel #PostgreSQL. You can use the Unix command irc -c + '#PostgreSQL' "$USER" irc.phoenix.net. or irc -c + '#PostgreSQL' "$USER" irc.freenode.net.

A list of commercial support companies is available at http://techdocs.postgresql.org/companies.php.

@@ -446,7 +447,7 @@ MySQL at http://openacs.org/philosophy/why-not-mysql.html Also, MySQL is is a company that distributes its products via open source, not an - open source development community ilke PostgreSQL.
+ open source development community like PostgreSQL.

-- 2.50.1