]> granicus.if.org Git - postgresql/log
postgresql
23 years agoThis hasn't been used for anything for a long time...
Tom Lane [Fri, 9 Feb 2001 19:26:45 +0000 (19:26 +0000)]
This hasn't been used for anything for a long time...

23 years agoLarge object manual updates.
Bruce Momjian [Fri, 9 Feb 2001 19:24:09 +0000 (19:24 +0000)]
Large object manual updates.

23 years agoRemove link to dead subdirectory 'linux'.
Tom Lane [Fri, 9 Feb 2001 18:42:35 +0000 (18:42 +0000)]
Remove link to dead subdirectory 'linux'.

23 years agoMention NetBSD
Bruce Momjian [Fri, 9 Feb 2001 17:55:48 +0000 (17:55 +0000)]
Mention NetBSD

23 years agoRemove pg_service mention.
Bruce Momjian [Fri, 9 Feb 2001 17:53:44 +0000 (17:53 +0000)]
Remove pg_service mention.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 9 Feb 2001 17:37:49 +0000 (17:37 +0000)]
Update TODO list.

23 years agoWhen updating a tuple containing compressed-in-line fields, do not
Tom Lane [Fri, 9 Feb 2001 17:30:03 +0000 (17:30 +0000)]
When updating a tuple containing compressed-in-line fields, do not
decompress the existing fields unnecessarily.

23 years agoAdd -g as synonmym for --globals-only in pg_dumpall. Add info about
Bruce Momjian [Fri, 9 Feb 2001 17:16:57 +0000 (17:16 +0000)]
Add -g as synonmym for --globals-only in pg_dumpall.  Add info about
-c,--clean option to manual page.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:22:22 +0000 (15:22 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:20:54 +0000 (15:20 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:15:09 +0000 (15:15 +0000)]
Update TODO list.

23 years agoI have deleted the include of termios.h in include/port/qnx4.h.
Bruce Momjian [Fri, 9 Feb 2001 15:13:49 +0000 (15:13 +0000)]
I have deleted the include of termios.h in include/port/qnx4.h.
Then I recompiled pgsql and I have compiled a program with ecpg.

I have removed the termios.h, and the ECHO hack.

Thanks
Maurizio

23 years agoChange SELECT to not trigger "BEGIN" in not autocommit mode.
Hiroshi Inoue [Fri, 9 Feb 2001 06:03:14 +0000 (06:03 +0000)]
Change SELECT to not trigger "BEGIN" in not autocommit mode.

23 years agoplpgsql's private copy of xlateSqlType was out of sync. Again. This
Tom Lane [Fri, 9 Feb 2001 03:26:28 +0000 (03:26 +0000)]
plpgsql's private copy of xlateSqlType was out of sync.  Again.  This
is clearly not maintainable, so dike it out in favor of calling the real
version in the backend's gram.y.

23 years agoDocument PL/TclU language variant, and do some minor copy-editing.
Tom Lane [Fri, 9 Feb 2001 03:06:38 +0000 (03:06 +0000)]
Document PL/TclU language variant, and do some minor copy-editing.

23 years agoRestructure discussion of PL installation to emphasize createlang as the
Tom Lane [Fri, 9 Feb 2001 02:20:52 +0000 (02:20 +0000)]
Restructure discussion of PL installation to emphasize createlang as the
recommended install procedure, rather than mentioning it as an afterthought.

23 years agoRemove no-longer-needed mklang script; now superseded by createlang.
Tom Lane [Fri, 9 Feb 2001 01:05:42 +0000 (01:05 +0000)]
Remove no-longer-needed mklang script; now superseded by createlang.

23 years agoEXECUTE of a SELECT ... INTO now draws a 'not implemented' error,
Tom Lane [Fri, 9 Feb 2001 00:14:26 +0000 (00:14 +0000)]
EXECUTE of a SELECT ... INTO now draws a 'not implemented' error,
rather than executing the INTO clause with non-plpgsql semantics
as it was doing for the last few weeks/months.  This keeps our options
open for making it do the right plpgsql-ish thing in future without
creating a backwards compatibility problem.  There is no loss of
functionality since people can get the same behavior with CREATE TABLE AS.

23 years agoRemove outdated contrib/linux start scripts. Beat some sense into
Peter Eisentraut [Thu, 8 Feb 2001 19:53:33 +0000 (19:53 +0000)]
Remove outdated contrib/linux start scripts.  Beat some sense into
contrib/init.d start script.  Place into more aptly named directory.  Maybe
we could add scripts for other platforms here later.

23 years agoMake -w the default for shut down, add -W option to specify no wait.
Peter Eisentraut [Thu, 8 Feb 2001 19:39:24 +0000 (19:39 +0000)]
Make -w the default for shut down, add -W option to specify no wait.
Add -l option to name log file.  Set umask to 077.
Proper file descriptor redirection to allow postmaster to detach from
shell's process group.
Add -s option to turn off informational messages.

23 years agoUPdate file from Patrick.
Bruce Momjian [Thu, 8 Feb 2001 04:57:24 +0000 (04:57 +0000)]
UPdate file from Patrick.

23 years agoFix a misuse of 'char *' declaration.
Hiroshi Inoue [Thu, 8 Feb 2001 01:54:29 +0000 (01:54 +0000)]
Fix a misuse of 'char *' declaration.

23 years agoWhen launching a child backend, take care to close file descriptors for
Tom Lane [Thu, 8 Feb 2001 00:35:10 +0000 (00:35 +0000)]
When launching a child backend, take care to close file descriptors for
any other client connections that may exist (which would only happen if
another client is currently in the authentication cycle).  This avoids
wastage of open descriptors in a child.  It might also explain peculiar
behaviors like not closing connections when expected, since the kernel
will probably not signal EOF as long as some other backend is randomly
holding open a reference to the connection, even if the client went away
long since ...

23 years agoFixBTree flag still exists and may be used to turn
Vadim B. Mikheev [Wed, 7 Feb 2001 23:36:22 +0000 (23:36 +0000)]
FixBTree flag still exists and may be used to turn
runtime recovery OFF.

23 years agoRuntime btree recovery is now ON by default.
Vadim B. Mikheev [Wed, 7 Feb 2001 23:35:33 +0000 (23:35 +0000)]
Runtime btree recovery is now ON by default.

23 years agoMacro for btree runtime fix.
Vadim B. Mikheev [Wed, 7 Feb 2001 23:34:18 +0000 (23:34 +0000)]
Macro for btree runtime fix.

23 years agoRepair postmaster memory leakage during password authentication.
Tom Lane [Wed, 7 Feb 2001 23:31:38 +0000 (23:31 +0000)]
Repair postmaster memory leakage during password authentication.

23 years agoRedo pgaccess' queries about views so that they will work in both 7.1
Tom Lane [Wed, 7 Feb 2001 21:30:12 +0000 (21:30 +0000)]
Redo pgaccess' queries about views so that they will work in both 7.1
and prior releases --- rely on pg_views view instead of direct access
to pg_class and pg_rewrite.

23 years agoNot sure why this work script was in the repository ... but it doesn't
Tom Lane [Wed, 7 Feb 2001 21:25:55 +0000 (21:25 +0000)]
Not sure why this work script was in the repository ... but it doesn't
belong ...

23 years agoMinor copy-editing.
Tom Lane [Wed, 7 Feb 2001 20:46:55 +0000 (20:46 +0000)]
Minor copy-editing.

23 years agoUse explicit path to libpgtcl.so, instead of relying on LD_LIBRARY_PATH
Tom Lane [Wed, 7 Feb 2001 20:30:20 +0000 (20:30 +0000)]
Use explicit path to libpgtcl.so, instead of relying on LD_LIBRARY_PATH
or local equivalent.  Also, honor --with-pgport configure option for
default port number, and allow PGPORT environment variable to override
this.

23 years agoMake DEF_PGPORT available to Makefiles, so it can be substituted into
Tom Lane [Wed, 7 Feb 2001 20:13:27 +0000 (20:13 +0000)]
Make DEF_PGPORT available to Makefiles, so it can be substituted into
scripts like pgaccess.

23 years agoActually, it looks like DEF_PGPORT belongs over in config.h.win32 for
Tom Lane [Wed, 7 Feb 2001 20:00:08 +0000 (20:00 +0000)]
Actually, it looks like DEF_PGPORT belongs over in config.h.win32 for
the Windows build...

23 years agoRemove broken (and unnecessary) definition of DEF_PGPORT.
Tom Lane [Wed, 7 Feb 2001 19:30:22 +0000 (19:30 +0000)]
Remove broken (and unnecessary) definition of DEF_PGPORT.

23 years agoOnly pass the -L* portions of LDFLAGS to the Python build environment.
Peter Eisentraut [Wed, 7 Feb 2001 18:22:10 +0000 (18:22 +0000)]
Only pass the -L* portions of LDFLAGS to the Python build environment.
Other flags can have unpredictable effects when Python uses different
commands to build than we do.

23 years agoNeed to specify DYNAMIC_PATH flag to shl_load, else HPUX's dld will not
Tom Lane [Wed, 7 Feb 2001 17:59:58 +0000 (17:59 +0000)]
Need to specify DYNAMIC_PATH flag to shl_load, else HPUX's dld will not
honor library search path that we so carefully installed into the
executable ...

23 years agoUpdate FAQ.
Bruce Momjian [Wed, 7 Feb 2001 16:33:32 +0000 (16:33 +0000)]
Update FAQ.

23 years agoUpdate FAQ.
Bruce Momjian [Wed, 7 Feb 2001 16:32:47 +0000 (16:32 +0000)]
Update FAQ.

23 years agoSome updates prior to retrieving a fresh cvs copy:
Peter Mount [Wed, 7 Feb 2001 09:13:20 +0000 (09:13 +0000)]
Some updates prior to retrieving a fresh cvs copy:

Tue Feb 06 19:00:00 GMT 2001 peter@retep.org.uk
        - Completed first two TestCase's for the test suite. JUnit is now
          recognised by ant.

23 years agoAdd java.
Bruce Momjian [Wed, 7 Feb 2001 04:50:55 +0000 (04:50 +0000)]
Add java.

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 7 Feb 2001 04:50:50 +0000 (04:50 +0000)]
Update TODO list.

23 years agoAdd item.
Bruce Momjian [Wed, 7 Feb 2001 04:48:27 +0000 (04:48 +0000)]
Add item.

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 7 Feb 2001 00:52:56 +0000 (00:52 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 7 Feb 2001 00:52:42 +0000 (00:52 +0000)]
Update TODO list.

23 years agocleaned up.
Bruce Momjian [Tue, 6 Feb 2001 21:38:43 +0000 (21:38 +0000)]
cleaned up.

23 years agoMake it clearer.
Bruce Momjian [Tue, 6 Feb 2001 21:37:55 +0000 (21:37 +0000)]
Make it clearer.

23 years agoOnly use termcap xor [n]curses, depending on what readline needs. Solaris
Peter Eisentraut [Tue, 6 Feb 2001 19:20:16 +0000 (19:20 +0000)]
Only use termcap xor [n]curses, depending on what readline needs.  Solaris
has problems when linking with both.

23 years agoWell, learned the hard way...
Bruce Momjian [Tue, 6 Feb 2001 18:05:13 +0000 (18:05 +0000)]
Well, learned the hard way...

Marko Kreen

23 years agoAdd.
Bruce Momjian [Tue, 6 Feb 2001 18:02:25 +0000 (18:02 +0000)]
Add.

23 years agoUpdate /contrib and TODO.detail.
Bruce Momjian [Tue, 6 Feb 2001 17:47:48 +0000 (17:47 +0000)]
Update /contrib and TODO.detail.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 6 Feb 2001 17:42:37 +0000 (17:42 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 6 Feb 2001 17:42:18 +0000 (17:42 +0000)]
Update TODO list.

23 years agoIf the first argument is --version or --help, skip the root check.
Peter Eisentraut [Tue, 6 Feb 2001 17:00:01 +0000 (17:00 +0000)]
If the first argument is --version or --help, skip the root check.

23 years agoPageAddItem in overwrite mode: must *NOT* check itemid' flag if
Vadim B. Mikheev [Tue, 6 Feb 2001 06:24:00 +0000 (06:24 +0000)]
PageAddItem in overwrite mode: must *NOT* check itemid' flag if
OffsetNumber == MaxOffsetNumber + 1 - there may be garbage there!

23 years agoUpdate FAQ.
Bruce Momjian [Tue, 6 Feb 2001 04:28:50 +0000 (04:28 +0000)]
Update FAQ.

23 years agoImproved version handling introduced by Dave Page.
Hiroshi Inoue [Tue, 6 Feb 2001 02:21:12 +0000 (02:21 +0000)]
Improved version handling introduced by Dave Page.
The driver version is 07.01.0002 now.
1) initialized pg_version by DSN's protocol info
   so that we could always use pg_version info
   once a connection is established (pg_version()
   didn't exist before 6.4). PROTOCOL_XX() macros
   are removed(except from connection.[ch]).
2) provided a few macros to encapsulate connection's
   version info and replaced existent comparison
   stuff by those macros.
3) change SQLTables() so that 7.1 servers could show
   views.

In addtion, the following patch from Dave Page is applied.

  This patch fixes a bug in SQLGetInfo for SQL_DBMS_VER which corrupted the
  driver version string. The driver version number has also been incremented
  to 07.01.0002.

  Regards, Dave. <<odbc.diff>>

23 years agoNow that I look at it, PQoidValue() ain't quite right either.
Tom Lane [Tue, 6 Feb 2001 02:02:27 +0000 (02:02 +0000)]
Now that I look at it, PQoidValue() ain't quite right either.

23 years agoRepair PQoidStatus() bug reported by darcy@druid.net.
Tom Lane [Tue, 6 Feb 2001 02:00:09 +0000 (02:00 +0000)]
Repair PQoidStatus() bug reported by darcy@druid.net.

23 years agoOut-of-bounds memory allocation request sizes should be treated as just
Tom Lane [Tue, 6 Feb 2001 01:53:53 +0000 (01:53 +0000)]
Out-of-bounds memory allocation request sizes should be treated as just
elog(ERROR) not an Assert trap, since we've downgraded out-of-memory to
elog(ERROR) not a fatal error.  Also, change the hard boundary from 256Mb
to 1Gb, just so that anyone who's actually got that much memory to spare
can play with TOAST objects approaching a gigabyte.

23 years agoDocument BETWEEN.
Peter Eisentraut [Mon, 5 Feb 2001 19:21:45 +0000 (19:21 +0000)]
Document BETWEEN.

23 years agoUpdate FAQ.
Bruce Momjian [Mon, 5 Feb 2001 17:37:44 +0000 (17:37 +0000)]
Update FAQ.

23 years agoDump/display 'timestamp' as 'timestamp with time zone', to make room for a
Peter Eisentraut [Mon, 5 Feb 2001 17:35:04 +0000 (17:35 +0000)]
Dump/display 'timestamp' as 'timestamp with time zone', to make room for a
future 'timestamp without time zone', which SQL claims is equivalent to
plain 'timestamp'.

23 years agoMove PL docs to programmer's guide, "storage" chapter to admin guide,
Peter Eisentraut [Sun, 4 Feb 2001 15:28:18 +0000 (15:28 +0000)]
Move PL docs to programmer's guide, "storage" chapter to admin guide,
clean up some things in the affected areas.

23 years agoCheck for -lresolv.
Peter Eisentraut [Sun, 4 Feb 2001 14:09:33 +0000 (14:09 +0000)]
Check for -lresolv.

23 years agoPass LDFLAGS along with LIBS to the Python build stuff, especially to pick
Peter Eisentraut [Sun, 4 Feb 2001 13:21:46 +0000 (13:21 +0000)]
Pass LDFLAGS along with LIBS to the Python build stuff, especially to pick
up -L options.

23 years agoMust run jadetex three times to get correct page numbers. Add support for
Peter Eisentraut [Sun, 4 Feb 2001 12:23:11 +0000 (12:23 +0000)]
Must run jadetex three times to get correct page numbers.  Add support for
pdfjadetex.

23 years agoWhen making xrefs to refsects, the linkend should point to the refsect and
Peter Eisentraut [Sun, 4 Feb 2001 12:18:08 +0000 (12:18 +0000)]
When making xrefs to refsects, the linkend should point to the refsect and
the endterm to the title element, not both to the title.  At least
docbook2man prefers it that way.

23 years agoRe-add Peter E's changes.
Bruce Momjian [Sat, 3 Feb 2001 21:50:45 +0000 (21:50 +0000)]
Re-add Peter E's changes.

23 years agoFix inappropriate attempt to push down qual clauses into a view that
Tom Lane [Sat, 3 Feb 2001 21:17:52 +0000 (21:17 +0000)]
Fix inappropriate attempt to push down qual clauses into a view that
has UNION/INTERSECT/EXCEPT operations.  Per bug report from Ferrier.

23 years agoUse elog() instead of exit() for fatal scanner errors.
Peter Eisentraut [Sat, 3 Feb 2001 20:13:05 +0000 (20:13 +0000)]
Use elog() instead of exit() for fatal scanner errors.

23 years agoImproved wording, from Albert REINER <areiner@tph.tuwien.ac.at>.
Peter Eisentraut [Sat, 3 Feb 2001 19:09:46 +0000 (19:09 +0000)]
Improved wording, from Albert REINER <areiner@tph.tuwien.ac.at>.

23 years agoUpdate, polish, consistencify preface/intro sections.
Peter Eisentraut [Sat, 3 Feb 2001 19:03:27 +0000 (19:03 +0000)]
Update, polish, consistencify preface/intro sections.

23 years agoChange description.
Bruce Momjian [Sat, 3 Feb 2001 04:13:22 +0000 (04:13 +0000)]
Change description.

23 years agoRuntime tree recovery is implemented, just testing is left -:)
Vadim B. Mikheev [Fri, 2 Feb 2001 19:49:15 +0000 (19:49 +0000)]
Runtime tree recovery is implemented, just testing is left -:)

23 years agoApply patches for QNX from Maurizio
Bruce Momjian [Fri, 2 Feb 2001 18:21:59 +0000 (18:21 +0000)]
Apply patches for QNX from Maurizio

23 years agoA patch for the GROUP BY/HAVING example. p.date should be s.date.
Bruce Momjian [Thu, 1 Feb 2001 19:13:47 +0000 (19:13 +0000)]
A patch for the GROUP BY/HAVING example.  p.date should be s.date.

Robert B. Easter

23 years ago Please replace with the one attached to this email message. The
Bruce Momjian [Thu, 1 Feb 2001 18:31:10 +0000 (18:31 +0000)]
    Please replace with the one attached to this email message. The
previous version depended on the below patch, this one does not. It is
also a bit cleaner and has a few more helpful comments.

Ryan Kirkpatrick

23 years agoApplied two bug fixes by Christof Petig.
Michael Meskes [Wed, 31 Jan 2001 16:12:34 +0000 (16:12 +0000)]
Applied two bug fixes by Christof Petig.

23 years agoWed Jan 31 08:46:00 GMT 2001 peter@retep.org.uk
Peter Mount [Wed, 31 Jan 2001 09:23:45 +0000 (09:23 +0000)]
Wed Jan 31 08:46:00 GMT 2001 peter@retep.org.uk
        - Some minor additions to Statement to make our own extensions more
          portable.
        - Statement.close() will now call ResultSet.close() rather than just
          dissasociating with it.

23 years agoTue Jan 30 22:24:00 GMT 2001 peter@retep.org.uk
Peter Mount [Wed, 31 Jan 2001 08:26:02 +0000 (08:26 +0000)]
Tue Jan 30 22:24:00 GMT 2001 peter@retep.org.uk
        - Fixed bug where Statement.setMaxRows() was a global setting. Now
          limited to just itself.
        - Changed LargeObject.read(byte[],int,int) to return the actual number
          of bytes read (used to be void).
        - LargeObject now supports InputStream's!
        - PreparedStatement.setBinaryStream() now works!
        - ResultSet.getBinaryStream() now returns an InputStream that doesn't
          copy the blob into memory first!
        - Connection.isClosed() now tests to see if the connection is still alive
          rather than if it thinks it's alive.

23 years agoCouple additional functions to fix tree at runtime.
Vadim B. Mikheev [Wed, 31 Jan 2001 01:08:36 +0000 (01:08 +0000)]
Couple additional functions to fix tree at runtime.
Need in one more function to handle "my bits moved..."
case. FixBTree is still FALSE.

23 years agoUpdate /contrib README and add init.d from Ryan.
Bruce Momjian [Tue, 30 Jan 2001 17:37:49 +0000 (17:37 +0000)]
Update /contrib README and add init.d from Ryan.

23 years agoUpdate HISTORY/release with current changes.
Bruce Momjian [Mon, 29 Jan 2001 18:58:45 +0000 (18:58 +0000)]
Update HISTORY/release with current changes.

23 years agoUpdate TODO list.
Bruce Momjian [Mon, 29 Jan 2001 17:57:41 +0000 (17:57 +0000)]
Update TODO list.

23 years agoRemove unused TODO.detail functions.
Bruce Momjian [Mon, 29 Jan 2001 17:57:26 +0000 (17:57 +0000)]
Remove unused TODO.detail functions.

23 years agoRemove subquery.
Bruce Momjian [Mon, 29 Jan 2001 17:52:47 +0000 (17:52 +0000)]
Remove subquery.

23 years agoUpdate TODO list.
Bruce Momjian [Mon, 29 Jan 2001 17:50:26 +0000 (17:50 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Mon, 29 Jan 2001 17:48:11 +0000 (17:48 +0000)]
Update TODO list.

23 years agoUpdate to PyGreSQL-3.1
Bruce Momjian [Mon, 29 Jan 2001 16:27:48 +0000 (16:27 +0000)]
Update to PyGreSQL-3.1

23 years agoCall _bt_fixroot() from _bt_insertonpg.
Vadim B. Mikheev [Mon, 29 Jan 2001 07:28:17 +0000 (07:28 +0000)]
Call _bt_fixroot() from _bt_insertonpg.

23 years agoupdate configure to beta4
Marc G. Fournier [Mon, 29 Jan 2001 02:52:30 +0000 (02:52 +0000)]
update configure to beta4

Install a ChangeLog file from beta3->beta4

23 years agoUpdate FAQ.
Bruce Momjian [Mon, 29 Jan 2001 01:23:36 +0000 (01:23 +0000)]
Update FAQ.

23 years agoClean up handling of tuple descriptors so that result-tuple descriptors
Tom Lane [Mon, 29 Jan 2001 00:39:20 +0000 (00:39 +0000)]
Clean up handling of tuple descriptors so that result-tuple descriptors
allocated by plan nodes are not leaked at end of query.  This doesn't
really matter for normal queries, but it sure does for queries invoked
repetitively inside SQL functions.  Clean up some other grotty code
associated with tupdescs, and fix a few other memory leaks exposed by
tests with simple SQL functions.

23 years agoThe following patch is required for successful compilation on Irix.
Bruce Momjian [Mon, 29 Jan 2001 00:11:41 +0000 (00:11 +0000)]
The following patch is required for successful compilation on Irix.

Robert E. Bruccole

23 years agoUpdate FAQ.
Bruce Momjian [Sun, 28 Jan 2001 17:43:54 +0000 (17:43 +0000)]
Update FAQ.

23 years agoUpdate FAQ.
Bruce Momjian [Sun, 28 Jan 2001 17:42:12 +0000 (17:42 +0000)]
Update FAQ.

23 years agoUpdate FAQ.
Bruce Momjian [Sun, 28 Jan 2001 17:39:44 +0000 (17:39 +0000)]
Update FAQ.

23 years agoUpdate TODO list.
Bruce Momjian [Sun, 28 Jan 2001 15:42:42 +0000 (15:42 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Sun, 28 Jan 2001 15:41:58 +0000 (15:41 +0000)]
Update TODO list.

23 years agoUpdate FAQ.
Bruce Momjian [Sun, 28 Jan 2001 15:18:45 +0000 (15:18 +0000)]
Update FAQ.