@@ -13,7 +13,7 @@ <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1313< P > Last updated: Sat Jan 29 23:25:05 EST 2005</ P >
1414
1515< P > Current maintainer: Bruce Momjian (< A href =
16- "mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ A > )< BR >
16+ "mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ A > )
1717</ P >
1818
1919< P > The most recent version of this document can be viewed at< A href =
@@ -620,16 +620,17 @@ <H4><A name="3.4">3.4</A>) What debugging features are
620620
621621< P > If< I > postmaster</ I > is running, start< I > psql</ I > in one
622622 window, then find the< SMALL > PID</ SMALL > of the< I > postgres</ I >
623- process used by< I > psql</ I > using< pre > SELECT pg_backend_pid()</ pre > .
623+ process used by< I > psql</ I > using< CODE > SELECT pg_backend_pid()</ CODE > .
624624 Use a debugger to attach to the< I > postgres</ I > < SMALL > PID</ SMALL > .
625625 You can set breakpoints in the debugger and issue queries from
626+
626627< I > psql</ I > . If you are debugging< I > postgres</ I > startup, you can
627628 set PGOPTIONS="-W n", then start< I > psql</ I > . This will cause startup
628629 to delay for< I > n</ I > seconds so you can attach to the process with
629630 the debugger, set any breakpoints, and continue through the startup
630631 sequence.</ P >
631632
632- < P > There are several< pre > log_*</ pre > server configuration variables
633+ < P > There are several< CODE > log_*</ CODE > server configuration variables
633634 that enable printing of process statistics which can be very useful
634635 for debugging and performance measurements.</ P >
635636
@@ -897,8 +898,8 @@ <H4><A name="4.6">4.6</A>) Why are my queries slow? Why don't they
897898< LI > The default< I > C</ I > locale must be used during
898899< i > initdb</ i > because it is not possible to know the next-greater
899900 character in a non-C locale. You can create a special
900- < PRE > text_pattern_ops</ PRE > index for such cases that work only
901- for< PRE > LIKE</ PRE > indexing.
901+ < CODE > text_pattern_ops</ CODE > index for such cases that work only
902+ for< SMALL > LIKE</ SMALL > indexing.
902903</ LI >
903904</ UL >
904905
@@ -1064,8 +1065,8 @@ <H4><A name="4.12">4.12</A>) What is an <SMALL>OID</SMALL>? What is
10641065 internal system tables together.</ P >
10651066
10661067< P > To uniquely number columns in user tables, it is best to use
1067- < SMALL > SERIAL</ > rather than O< SMALL > ID</ SMALL > s because
1068- < SMALL > SERIAL< SMALL > sequences are unique only within a single
1068+ < SMALL > SERIAL</ SMALL > rather than O< SMALL > ID</ SMALL > s because
1069+ < SMALL > SERIAL</ SMALL > sequences are unique only within a single
10691070 table. and are therefore less likely to overflow.
10701071< SMALL > SERIAL8</ SMALL > is available for storing eight-byte sequence
10711072 values.</ P >
@@ -1149,8 +1150,7 @@ <H4><A name="4.17">4.17</A>) How do I create a column that will
11491150
11501151< P > Use< I > CURRENT_TIMESTAMP</ I > :</ P >
11511152< PRE >
1152- < CODE > CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP );
1153- </ CODE >
1153+ CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP );
11541154</ PRE >
11551155
11561156< H4 > < A name ="4.18 "> 4.18</ A > ) How do I perform an outer join?</ H4 >