diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-01-30 04:45:01 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-01-30 04:45:01 +0000 |
| commit | 790c666931e10c11e47f4460e9c749e00f28f173 (patch) | |
| tree | fdad03cd65d0b833766363adc44991b6a6969cbf | |
| parent | 60d6f49a47dbb7770509034d012db00fbb7e7823 (diff) | |
| download | postgresql-790c666931e10c11e47f4460e9c749e00f28f173.tar.gz postgresql-790c666931e10c11e47f4460e9c749e00f28f173.zip | |
Update FAQ text file.
| -rw-r--r-- | doc/FAQ | 38 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 2 |
2 files changed, 16 insertions, 24 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sat Jan 29 23:25:05 EST 2005 + Last updated: Sat Jan 29 23:44:48 EST 2005 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -481,22 +481,17 @@ may not be duplicated. If postmaster is running, start psql in one window, then find the PID - of the postgres process used by psql using -SELECT pg_backend_pid() - - . Use a debugger to attach to the postgres PID. You can set - breakpoints in the debugger and issue queries from psql. If you are - debugging postgres startup, you can set PGOPTIONS="-W n", then start - psql. This will cause startup to delay for n seconds so you can attach - to the process with the debugger, set any breakpoints, and continue - through the startup sequence. - - There are several -log_* - - server configuration variables that enable printing of process - statistics which can be very useful for debugging and performance - measurements. + of the postgres process used by psql using SELECT pg_backend_pid(). + Use a debugger to attach to the postgres PID. You can set breakpoints + in the debugger and issue queries from psql. If you are debugging + postgres startup, you can set PGOPTIONS="-W n", then start psql. This + will cause startup to delay for n seconds so you can attach to the + process with the debugger, set any breakpoints, and continue through + the startup sequence. + + There are several log_* server configuration variables that enable + printing of process statistics which can be very useful for debugging + and performance measurements. You can also compile with profiling to see what functions are taking execution time. The backend profile files will be deposited in the @@ -725,11 +720,8 @@ log_* section 4.10. * The default C locale must be used during initdb because it is not possible to know the next-greater character in a non-C locale. You - can create a special -text_pattern_ops - index for such cases that work only for -LIKE - indexing. + can create a special text_pattern_ops index for such cases that + work only for LIKE indexing. In pre-8.0 releases, indexes often can not be used unless the data types exactly match the index's column types. This is particularly @@ -919,7 +911,7 @@ BYTEA bytea variable-length byte array (null-byte safe) 4.17) How do I create a column that will default to the current time? Use CURRENT_TIMESTAMP: -CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP ); + CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP ); 4.18) How do I perform an outer join? diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index da6e3d9afc8..65fbc0446c8 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Sat Jan 29 23:25:05 EST 2005</P> + <P>Last updated: Sat Jan 29 23:44:48 EST 2005</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>) |