From 72ad5fe15c93fefa8debb0fc8ef5c85b560ffac7 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 29 Sep 2000 20:21:34 +0000 Subject: [PATCH] Add `id' attributes to all `chapter' and `sect1' tags, to generate useful names for the HTML files (e.g., not x4856.htm). --- doc/src/sgml/advanced.sgml | 8 +++--- doc/src/sgml/arch-dev.sgml | 14 +++++------ doc/src/sgml/arch-pg.sgml | 2 +- doc/src/sgml/arch.sgml | 2 +- doc/src/sgml/backup.sgml | 6 ++--- doc/src/sgml/bki.sgml | 12 ++++----- doc/src/sgml/charset.sgml | 2 +- doc/src/sgml/cvs.sgml | 8 +++--- doc/src/sgml/datatype.sgml | 20 +++++++-------- doc/src/sgml/datetime.sgml | 6 ++--- doc/src/sgml/dfunc.sgml | 10 ++++---- doc/src/sgml/docguide.sgml | 18 ++++++------- doc/src/sgml/ecpg.sgml | 16 ++++++------ doc/src/sgml/extend.sgml | 8 +++--- doc/src/sgml/func.sgml | 33 ++++++++++++------------ doc/src/sgml/geqo.sgml | 10 ++++---- doc/src/sgml/history.sgml | 4 +-- doc/src/sgml/indexcost.sgml | 4 +-- doc/src/sgml/info.sgml | 4 +-- doc/src/sgml/install-win32.sgml | 6 ++--- doc/src/sgml/installation.sgml | 16 ++++++------ doc/src/sgml/intro.sgml | 4 +-- doc/src/sgml/jdbc.sgml | 26 +++++++++---------- doc/src/sgml/keys.sgml | 8 ++++-- doc/src/sgml/libpgtcl.sgml | 6 ++--- doc/src/sgml/libpq++.sgml | 14 +++++------ doc/src/sgml/libpq.sgml | 20 +++++++-------- doc/src/sgml/lobj.sgml | 14 +++++------ doc/src/sgml/manage-ag.sgml | 8 +++--- doc/src/sgml/manage.sgml | 10 ++++---- doc/src/sgml/mvcc.sgml | 16 ++++++------ doc/src/sgml/odbc.sgml | 13 +++++----- doc/src/sgml/oper.sgml | 26 +++++++++---------- doc/src/sgml/plan.sgml | 6 ++--- doc/src/sgml/plperl.sgml | 8 +++--- doc/src/sgml/plsql.sgml | 10 ++++---- doc/src/sgml/pltcl.sgml | 8 +++--- doc/src/sgml/populate.sgml | 10 ++++---- doc/src/sgml/problems.sgml | 2 +- doc/src/sgml/protocol.sgml | 8 +++--- doc/src/sgml/query.sgml | 22 ++++++++-------- doc/src/sgml/regress.sgml | 8 +++--- doc/src/sgml/release.sgml | 56 ++++++++++++++++++++--------------------- doc/src/sgml/rules.sgml | 10 ++++---- doc/src/sgml/runtime.sgml | 6 ++--- doc/src/sgml/sources.sgml | 6 ++--- doc/src/sgml/spi.sgml | 10 ++++---- doc/src/sgml/sql.sgml | 6 ++--- doc/src/sgml/start.sgml | 8 +++--- doc/src/sgml/syntax.sgml | 16 ++++++------ doc/src/sgml/trigger.sgml | 8 +++--- doc/src/sgml/typeconv.sgml | 10 ++++---- doc/src/sgml/user-manag.sgml | 8 +++--- doc/src/sgml/xfunc.sgml | 12 ++++----- doc/src/sgml/xoper.sgml | 4 +-- doc/src/sgml/xplang.sgml | 4 +-- doc/src/sgml/xtypes.sgml | 2 +- 57 files changed, 312 insertions(+), 310 deletions(-) diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml index 1cf2c63ffa..7876eac410 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -1,5 +1,5 @@ @@ -18,7 +18,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/advanced.sgml,v 1.15 2000/06/22 22:31:15 pe (Refer to for how to use it.) - + Inheritance @@ -137,7 +137,7 @@ SET SQL_Inheritance TO OFF; - + Non-Atomic Values @@ -258,7 +258,7 @@ SELECT SAL_EMP.schedule[1:2][1:1] - + More Advanced Features diff --git a/doc/src/sgml/arch-dev.sgml b/doc/src/sgml/arch-dev.sgml index 52bdb8e407..37b09c196e 100644 --- a/doc/src/sgml/arch-dev.sgml +++ b/doc/src/sgml/arch-dev.sgml @@ -1,5 +1,5 @@ @@ -28,7 +28,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/arch-dev.sgml,v 2.9 2000/09/12 05:34:28 tho sending the results. - + The Path of a Query @@ -114,7 +114,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/arch-dev.sgml,v 2.9 2000/09/12 05:34:28 tho - + How Connections are Established @@ -167,7 +167,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/arch-dev.sgml,v 2.9 2000/09/12 05:34:28 tho - + The Parser Stage @@ -442,7 +442,7 @@ current context are performed. - + The <productname>Postgres</productname> Rule System @@ -585,7 +585,7 @@ current context are performed. - + Planner/Optimizer @@ -711,7 +711,7 @@ current context are performed. - + Executor diff --git a/doc/src/sgml/arch-pg.sgml b/doc/src/sgml/arch-pg.sgml index 8de7c1db50..98c9f18f6d 100644 --- a/doc/src/sgml/arch-pg.sgml +++ b/doc/src/sgml/arch-pg.sgml @@ -1,7 +1,7 @@ Architecture - + <ProductName>Postgres</ProductName> Architectural Concepts diff --git a/doc/src/sgml/arch.sgml b/doc/src/sgml/arch.sgml index 4405728aa0..3ce064192a 100644 --- a/doc/src/sgml/arch.sgml +++ b/doc/src/sgml/arch.sgml @@ -1,7 +1,7 @@ Architecture - + <ProductName>Postgres</ProductName> Architectural Concepts diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml index 204692705d..c363664e67 100644 --- a/doc/src/sgml/backup.sgml +++ b/doc/src/sgml/backup.sgml @@ -1,4 +1,4 @@ - + Backup and Restore @@ -18,7 +18,7 @@ - + <acronym>SQL</> Dump @@ -271,7 +271,7 @@ cat filename.* | psql - + File system level backup diff --git a/doc/src/sgml/bki.sgml b/doc/src/sgml/bki.sgml index 938a99d462..9b7a7fbea9 100644 --- a/doc/src/sgml/bki.sgml +++ b/doc/src/sgml/bki.sgml @@ -1,5 +1,5 @@ @@ -37,7 +37,7 @@ Thomas Lockhart Postgres server to your local machine. - + <productname>CVS</productname> Tree Organization @@ -154,7 +154,7 @@ cvs commit - + Getting The Source Via Anonymous <productname>CVS</productname> @@ -286,7 +286,7 @@ $ chmod -R go-w pgsql - + Getting The Source Via <productname>CVSup</productname> diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 3e3266cf5f..a693e77208 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ @@ -271,7 +271,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.36 2000/09/19 18:17:53 pe - + Numeric Types @@ -349,8 +349,8 @@ $Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.36 2000/09/19 18:17:53 pe The numeric types have a full set of corresponding arithmetic operators and - functions. Refer to - and for more information. + functions. Refer to + and for more information. @@ -404,7 +404,7 @@ CREATE TABLE tablename ( - + Monetary Type @@ -456,7 +456,7 @@ CREATE TABLE tablename ( - + Character Types @@ -549,7 +549,7 @@ CREATE TABLE tablename ( - + Date/Time Types @@ -1355,7 +1355,7 @@ January 8 04:05:06 1999 PST - + Boolean Type @@ -1402,7 +1402,7 @@ January 8 04:05:06 1999 PST - + Geometric Types @@ -1731,7 +1731,7 @@ January 8 04:05:06 1999 PST - + IP Version 4 Networks and Host Addresses diff --git a/doc/src/sgml/datetime.sgml b/doc/src/sgml/datetime.sgml index 97952aa839..9f9bcba5ec 100644 --- a/doc/src/sgml/datetime.sgml +++ b/doc/src/sgml/datetime.sgml @@ -1,12 +1,12 @@ Date/Time Support - + Time Zones @@ -623,7 +623,7 @@ Date/time details - + History of Units diff --git a/doc/src/sgml/dfunc.sgml b/doc/src/sgml/dfunc.sgml index ccdb25e60c..7c547d52d0 100644 --- a/doc/src/sgml/dfunc.sgml +++ b/doc/src/sgml/dfunc.sgml @@ -1,5 +1,5 @@ @@ -148,7 +148,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/dfunc.sgml,v 1.10 2000/05/02 20:01:51 thoma - + Linux @@ -171,7 +171,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/dfunc.sgml,v 1.10 2000/05/02 20:01:51 thoma - + <acronym>DEC OSF/1</acronym> @@ -240,7 +240,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/dfunc.sgml,v 1.10 2000/05/02 20:01:51 thoma - + <acronym>SunOS 4.x</acronym>, <acronym>Solaris 2.x</acronym> and <acronym>HP-UX</acronym> diff --git a/doc/src/sgml/docguide.sgml b/doc/src/sgml/docguide.sgml index bcfc88e2dc..543350af98 100644 --- a/doc/src/sgml/docguide.sgml +++ b/doc/src/sgml/docguide.sgml @@ -1,5 +1,5 @@ @@ -31,7 +31,7 @@ Thomas Lockhart without resorting to mailing list support. - + Documentation Roadmap @@ -144,7 +144,7 @@ Thomas Lockhart - + The Documentation Project @@ -206,7 +206,7 @@ Thomas Lockhart - + Documentation Sources @@ -848,7 +848,7 @@ End: - + Building Documentation @@ -913,7 +913,7 @@ PSTYLE= /home/lockhart/SGML/db143.d/docbook/print - + Manpages @@ -968,7 +968,7 @@ $ make man - + Hardcopy Generation for v7.0 @@ -1325,7 +1325,7 @@ exit - + Toolsets @@ -2051,7 +2051,7 @@ dvips postgres.dvi - + Alternate Toolsets diff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgml index 8b3049c6ee..e0ba477b3a 100644 --- a/doc/src/sgml/ecpg.sgml +++ b/doc/src/sgml/ecpg.sgml @@ -1,8 +1,8 @@ - + @@ -43,7 +43,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v 1.16 2000/09/18 20:11:36 petere - + Why Embedded <acronym>SQL</acronym>? @@ -65,7 +65,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v 1.16 2000/09/18 20:11:36 petere - + The Concept @@ -106,7 +106,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v 1.16 2000/09/18 20:11:36 petere - + How To Use <application>ecpg</application> @@ -425,7 +425,7 @@ struct sqlca - + Limitations @@ -460,7 +460,7 @@ struct sqlca - + Porting From Other <acronym>RDBMS</acronym> Packages @@ -503,7 +503,7 @@ struct sqlca - + For the Developer diff --git a/doc/src/sgml/extend.sgml b/doc/src/sgml/extend.sgml index 231fde0f43..5f18a1c770 100644 --- a/doc/src/sgml/extend.sgml +++ b/doc/src/sgml/extend.sgml @@ -1,5 +1,5 @@ @@ -34,7 +34,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/extend.sgml,v 1.5 2000/03/31 03:27:40 thoma - + How Extensibility Works @@ -73,7 +73,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/extend.sgml,v 1.5 2000/03/31 03:27:40 thoma - + The <productname>Postgres</productname> Type System @@ -107,7 +107,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/extend.sgml,v 1.5 2000/03/31 03:27:40 thoma - + About the <productname>Postgres</productname> System Catalogs diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index f7b2334f3d..01764b45f2 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -14,8 +14,8 @@ available through operators and may be documented as operators only. - - SQL Functions + + SQL Functions SQL functions are constructs @@ -65,8 +65,8 @@ - - Mathematical Functions + + Mathematical Functions @@ -261,7 +261,7 @@ - + String Functions @@ -380,12 +380,12 @@ char(varchar 'varchar string') - chr(int) text returns the character having the binary equivalent to int chr(65) + initcap(text) text first letter of each word to upper case @@ -482,7 +482,7 @@ - + Date/Time Functions @@ -607,9 +607,8 @@ - - - Formatting Functions + + Formatting Functions Author @@ -1252,7 +1251,7 @@ - + Geometric Functions @@ -1474,8 +1473,8 @@ Not defined by this name. Implements the intersection operator '#' - - IP V4 Functions + + IP V4 Functions
@@ -1533,8 +1532,8 @@ Not defined by this name. Implements the intersection operator '#' - - Miscellaneous Functions</> + <sect1 id="misc-functions"> + <title>Miscellaneous Functions</> <table> <title>Miscellaneous Functions</> @@ -1588,8 +1587,8 @@ Not defined by this name. Implements the intersection operator '#' </note> </sect1> - <sect1> - <title id="aggregate-funcs">Aggregate Functions + + Aggregate Functions Author diff --git a/doc/src/sgml/geqo.sgml b/doc/src/sgml/geqo.sgml index 10fc2d90e8..0f12b3db3c 100644 --- a/doc/src/sgml/geqo.sgml +++ b/doc/src/sgml/geqo.sgml @@ -1,5 +1,5 @@ @@ -40,7 +40,7 @@ Genetic Optimizer - + Query Handling as a Complex Optimization Problem @@ -84,7 +84,7 @@ Genetic Optimizer - + Genetic Algorithms (<acronym>GA</acronym>) @@ -150,7 +150,7 @@ P''(t) generation of descendants at a time t - + Genetic Query Optimization (<acronym>GEQO</acronym>) in Postgres @@ -231,7 +231,7 @@ P''(t) generation of descendants at a time t - + Future Implementation Tasks for <productname>PostgreSQL</> <acronym>GEQO</acronym> diff --git a/doc/src/sgml/history.sgml b/doc/src/sgml/history.sgml index 9616399321..1499282326 100644 --- a/doc/src/sgml/history.sgml +++ b/doc/src/sgml/history.sgml @@ -1,8 +1,8 @@ - + A Short History of <productname>Postgres</productname> diff --git a/doc/src/sgml/indexcost.sgml b/doc/src/sgml/indexcost.sgml index e2fc6507ee..4570bc4f64 100644 --- a/doc/src/sgml/indexcost.sgml +++ b/doc/src/sgml/indexcost.sgml @@ -1,8 +1,8 @@ - + Index Cost Estimation Functions diff --git a/doc/src/sgml/info.sgml b/doc/src/sgml/info.sgml index 11a2105c9d..7f51e54d18 100644 --- a/doc/src/sgml/info.sgml +++ b/doc/src/sgml/info.sgml @@ -1,8 +1,8 @@ - + Resources diff --git a/doc/src/sgml/install-win32.sgml b/doc/src/sgml/install-win32.sgml index 196bc43136..5705650faa 100644 --- a/doc/src/sgml/install-win32.sgml +++ b/doc/src/sgml/install-win32.sgml @@ -8,7 +8,7 @@ - + Building the libraries @@ -64,7 +64,7 @@ nmake /f win32.mak - + Installing the libraries The only part of the library to really be installed is the @@ -83,7 +83,7 @@ nmake /f win32.mak - + Using the libraries To use the libraries, you must add the libpqdll.lib diff --git a/doc/src/sgml/installation.sgml b/doc/src/sgml/installation.sgml index 2036d7d092..8779754385 100644 --- a/doc/src/sgml/installation.sgml +++ b/doc/src/sgml/installation.sgml @@ -1,9 +1,9 @@ - + <![%flattext-install-include[<productname>PostgreSQL</> ]]>Installation Instructions - + Short Version @@ -25,7 +25,7 @@ su - postgres - + Requirements @@ -124,7 +124,7 @@ su - postgres + Getting The Source @@ -254,7 +254,7 @@ su - postgres - + Installation Procedure @@ -793,7 +793,7 @@ All of PostgreSQL is successfully made. Ready to install. - + Post-Installation Setup @@ -883,7 +883,7 @@ MANPATH=$MANPATH:/usr/local/pgsql/man + Getting Started @@ -978,7 +978,7 @@ kill `cat /usr/local/pgsql/data/postmaster.pid` - + What Now? diff --git a/doc/src/sgml/intro.sgml b/doc/src/sgml/intro.sgml index 1d6de96d8b..cddd648f29 100644 --- a/doc/src/sgml/intro.sgml +++ b/doc/src/sgml/intro.sgml @@ -1,5 +1,5 @@ @@ -22,7 +22,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/intro.sgml,v 1.11 2000/04/07 13:30:58 thoma Foundation (NSF), and ESL, Inc. - + What is <productname>Postgres</productname>? diff --git a/doc/src/sgml/jdbc.sgml b/doc/src/sgml/jdbc.sgml index e08d59ae18..46677410b8 100644 --- a/doc/src/sgml/jdbc.sgml +++ b/doc/src/sgml/jdbc.sgml @@ -1,5 +1,5 @@ @@ -30,7 +30,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/jdbc.sgml,v 1.12 2000/08/29 20:02:07 the driver can be used on any platform. - + Building the <acronym>JDBC</acronym> Interface @@ -97,7 +97,7 @@ java uk.org.retep.finder.Main - + Preparing the Database for <acronym>JDBC</acronym> @@ -125,7 +125,7 @@ host all 127.0.0.1 255.255.255.255 password - + Using the Driver @@ -138,7 +138,7 @@ host all 127.0.0.1 255.255.255.255 password - + Importing <acronym>JDBC</acronym> @@ -158,7 +158,7 @@ import java.sql.*; - + Loading the Driver @@ -219,7 +219,7 @@ Class.forName("postgresql.Driver"); - + Connecting to the Database @@ -298,7 +298,7 @@ Connection db = DriverManager.getConnection(url,user,pwd); - + Issuing a Query and Processing the Result @@ -397,7 +397,7 @@ st.close(); - + Performing Updates @@ -410,7 +410,7 @@ st.executeUpdate("create table basic (a int2, b int2)"); - + Closing the Connection @@ -422,7 +422,7 @@ db.close(); - + Using Large Objects @@ -528,7 +528,7 @@ ps.close(); - + <application>Postgres</application> Extensions to the <acronym>JDBC</acronym> <acronym>API</acronym> @@ -2627,7 +2627,7 @@ It's up to you, and your applications requirements. - + Further Reading diff --git a/doc/src/sgml/keys.sgml b/doc/src/sgml/keys.sgml index 29a6248965..ff506fea53 100644 --- a/doc/src/sgml/keys.sgml +++ b/doc/src/sgml/keys.sgml @@ -1,8 +1,12 @@ - + diff --git a/doc/src/sgml/libpgtcl.sgml b/doc/src/sgml/libpgtcl.sgml index dd6797b764..37344ba0e9 100644 --- a/doc/src/sgml/libpgtcl.sgml +++ b/doc/src/sgml/libpgtcl.sgml @@ -12,7 +12,7 @@ tcl scripts. This package was originally written by Jolly Chen. - + Commands @@ -117,7 +117,7 @@ in a BEGIN/END transaction block. - + Examples @@ -145,7 +145,7 @@ proc getDBs { {host "localhost"} {port "5432"} } { - + pgtcl Command Reference Information diff --git a/doc/src/sgml/libpq++.sgml b/doc/src/sgml/libpq++.sgml index e5045b1b59..44f7f97dcd 100644 --- a/doc/src/sgml/libpq++.sgml +++ b/doc/src/sgml/libpq++.sgml @@ -1,5 +1,5 @@ @@ -46,7 +46,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/libpq++.sgml,v 1.16 2000/05/02 20:01: code for the three examples in this chapter. - + Control and Initialization @@ -178,7 +178,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/libpq++.sgml,v 1.16 2000/05/02 20:01: - + libpq++ Classes @@ -203,7 +203,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/libpq++.sgml,v 1.16 2000/05/02 20:01: - + Database Connection Functions @@ -278,7 +278,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/libpq++.sgml,v 1.16 2000/05/02 20:01: - + Query Execution Functions @@ -574,7 +574,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/libpq++.sgml,v 1.16 2000/05/02 20:01: - + Asynchronous Notification @@ -639,7 +639,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/libpq++.sgml,v 1.16 2000/05/02 20:01: - + Functions Associated with the COPY Command diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml index 201b8e40ac..a9550c8d99 100644 --- a/doc/src/sgml/libpq.sgml +++ b/doc/src/sgml/libpq.sgml @@ -1,5 +1,5 @@ @@ -38,7 +38,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/libpq.sgml,v 1.40 2000/08/29 20:02:07 momji libpq library. - + Database Connection Functions @@ -667,7 +667,7 @@ SSL *PQgetssl(const PGconn *conn); - + Query Execution Functions @@ -1077,7 +1077,7 @@ as with a PGresult returned by libpq itself. - + Asynchronous Query Processing @@ -1368,7 +1368,7 @@ is not currently open or the backend is not currently processing a query. - + Fast Path @@ -1424,7 +1424,7 @@ typedef struct { - + Asynchronous Notification @@ -1510,7 +1510,7 @@ if any notifications came in during the processing of the query. - + Functions Associated with the COPY Command @@ -1694,7 +1694,7 @@ This will work correctly only if the copy in/out is the only - + <application>libpq</application> Tracing Functions @@ -1724,7 +1724,7 @@ void PQuntrace(PGconn *conn) - + <application>libpq</application> Control Functions @@ -1930,7 +1930,7 @@ call fe_setauthsvc at all. - + Sample Programs diff --git a/doc/src/sgml/lobj.sgml b/doc/src/sgml/lobj.sgml index 9d9b9c80bd..43daa3c12c 100644 --- a/doc/src/sgml/lobj.sgml +++ b/doc/src/sgml/lobj.sgml @@ -1,5 +1,5 @@ @@ -22,7 +22,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/lobj.sgml,v 1.12 2000/05/15 12:42:23 momjia large object data. - + Historical Note @@ -42,7 +42,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/lobj.sgml,v 1.12 2000/05/15 12:42:23 momjia - + Implementation Features @@ -54,7 +54,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/lobj.sgml,v 1.12 2000/05/15 12:42:23 momjia - + Interfaces @@ -255,7 +255,7 @@ Oid lo_unlink(PGconn *conn, Oid lob - + Built in registered functions @@ -279,7 +279,7 @@ SELECT lo_export(image.raster, '/tmp/motd') from image - + Accessing Large Objects from LIBPQ @@ -297,7 +297,7 @@ SELECT lo_export(image.raster, '/tmp/motd') from image - + Sample Program diff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml index d8ec11ea74..5ac9776eac 100644 --- a/doc/src/sgml/manage-ag.sgml +++ b/doc/src/sgml/manage-ag.sgml @@ -1,5 +1,5 @@ @@ -29,7 +29,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/manage-ag.sgml,v 2.10 2000/08/29 20:02:07 m linkend="postmaster-start">). - + Creating a Database @@ -181,7 +181,7 @@ CREATE DATABASE name WITH LOCATION = 'location' - + Accessing a Database @@ -282,7 +282,7 @@ Type: \copyright for distribution terms - + Destroying a Database diff --git a/doc/src/sgml/manage.sgml b/doc/src/sgml/manage.sgml index a3c7c166f4..17e999f4ac 100644 --- a/doc/src/sgml/manage.sgml +++ b/doc/src/sgml/manage.sgml @@ -1,5 +1,5 @@ @@ -29,7 +29,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/manage.sgml,v 1.10 2000/05/02 20:01:5 The Database Administrator's Guide covers these topics in more detail. - + Database Creation @@ -75,7 +75,7 @@ ERROR: CREATE DATABASE: Permission denied. - + Alternate Database Locations @@ -164,7 +164,7 @@ ERROR: The database path '/no/where' is invalid. This may be due to a character - + Accessing a Database @@ -274,7 +274,7 @@ TBD - + Destroying a Database diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index c612ae6a32..3a321c4c15 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -1,5 +1,5 @@ @@ -16,7 +16,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.7 2000/03/31 03:27:41 thomas - + Introduction @@ -41,7 +41,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.7 2000/03/31 03:27:41 thomas - + Transaction Isolation @@ -181,7 +181,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.7 2000/03/31 03:27:41 thomas - + Read Committed Isolation Level @@ -216,7 +216,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.7 2000/03/31 03:27:41 thomas - + Serializable Isolation Level @@ -259,7 +259,7 @@ ERROR: Can't serialize access due to concurrent update - + Locking and Tables @@ -444,7 +444,7 @@ ERROR: Can't serialize access due to concurrent update - + Locking and Indices @@ -509,7 +509,7 @@ ERROR: Can't serialize access due to concurrent update - + Data consistency checks at the application level diff --git a/doc/src/sgml/odbc.sgml b/doc/src/sgml/odbc.sgml index b4d1826550..300b9bd6dd 100644 --- a/doc/src/sgml/odbc.sgml +++ b/doc/src/sgml/odbc.sgml @@ -1,5 +1,5 @@ @@ -37,7 +37,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/odbc.sgml,v 1.17 2000/09/18 20:11:37 transportable between servers from different manufacturers.. - + Background @@ -72,7 +72,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/odbc.sgml,v 1.17 2000/09/18 20:11:37 - + Installation @@ -136,7 +136,7 @@ psql -d template1 -f LOCATION/odbc.sql - + Configuration Files @@ -220,7 +220,7 @@ InstallDir = /opt/applix/axdata/axshlib - + <productname>Windows</productname> Applications @@ -301,8 +301,7 @@ InstallDir = /opt/applix/axdata/axshlib - - + ApplixWare diff --git a/doc/src/sgml/oper.sgml b/doc/src/sgml/oper.sgml index 7f38294530..112c6f2f3f 100644 --- a/doc/src/sgml/oper.sgml +++ b/doc/src/sgml/oper.sgml @@ -1,5 +1,5 @@ @@ -57,7 +57,7 @@ select * from emp where int4lt(salary, 40000); has a command (\dd) to show these operators. - + Lexical Precedence @@ -310,7 +310,7 @@ logical union - + General Operators @@ -417,8 +417,8 @@ logical union - - Numerical Operators + + Numerical Operators
@@ -499,7 +499,7 @@ logical union - + Geometric Operators @@ -641,7 +641,7 @@ logical union - + Time Interval Operators @@ -722,8 +722,8 @@ logical union - - IP V4 CIDR Operators + + IP V4 CIDR Operators
@@ -792,10 +792,10 @@ logical union
- + - - IP V4 INET Operators + + IP V4 INET Operators @@ -864,7 +864,7 @@ logical union
- + diff --git a/doc/src/sgml/plan.sgml b/doc/src/sgml/plan.sgml index fb82a45c35..bfc592b6a4 100644 --- a/doc/src/sgml/plan.sgml +++ b/doc/src/sgml/plan.sgml @@ -1,8 +1,8 @@ - + Understanding Performance @@ -19,7 +19,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/plan.sgml,v 2.4 2000/08/29 20:02:07 m performance. - + Using <command>EXPLAIN</command> diff --git a/doc/src/sgml/plperl.sgml b/doc/src/sgml/plperl.sgml index 7f23aaad79..58023ac209 100644 --- a/doc/src/sgml/plperl.sgml +++ b/doc/src/sgml/plperl.sgml @@ -1,5 +1,5 @@ @@ -9,7 +9,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/plperl.sgml,v 2.4 2000/05/09 18:30:43 momji This chapter describes how to compile, install and use PL/Perl. - + Overview PL/Perl allows you to write functions in the Perl scripting @@ -34,7 +34,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/plperl.sgml,v 2.4 2000/05/09 18:30:43 momji - + Building and Installing Assuming that the Postgres @@ -65,7 +65,7 @@ make - + Using PL/Perl Assume you have the following table: diff --git a/doc/src/sgml/plsql.sgml b/doc/src/sgml/plsql.sgml index 17adde2a19..99660afa9f 100644 --- a/doc/src/sgml/plsql.sgml +++ b/doc/src/sgml/plsql.sgml @@ -1,8 +1,8 @@ - + PL/pgSQL - SQL Procedural Language @@ -14,7 +14,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.9 2000/08/25 15:17:36 This package was originally written by Jan Wieck. - + Overview @@ -83,7 +83,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.9 2000/08/25 15:17:36 - + Description @@ -773,7 +773,7 @@ EXIT [ label ] [ WHEN expression - + Examples diff --git a/doc/src/sgml/pltcl.sgml b/doc/src/sgml/pltcl.sgml index 5768cb368b..6267d8c412 100644 --- a/doc/src/sgml/pltcl.sgml +++ b/doc/src/sgml/pltcl.sgml @@ -1,8 +1,8 @@ - + PL/Tcl - TCL Procedural Language @@ -18,7 +18,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/pltcl.sgml,v 2.5 2000/08/25 15:17:36 thomas - + Overview @@ -49,7 +49,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/pltcl.sgml,v 2.5 2000/08/25 15:17:36 thomas - + Description diff --git a/doc/src/sgml/populate.sgml b/doc/src/sgml/populate.sgml index 391b96aa73..abac068e62 100644 --- a/doc/src/sgml/populate.sgml +++ b/doc/src/sgml/populate.sgml @@ -1,8 +1,8 @@ - + Populating a Database @@ -18,7 +18,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/populate.sgml,v 2.2 2000/03/31 03:27: efficient as possible. - + Disable Auto-commit @@ -30,7 +30,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/populate.sgml,v 2.2 2000/03/31 03:27: - + Use COPY FROM @@ -42,7 +42,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/populate.sgml,v 2.2 2000/03/31 03:27: - + Remove Indices diff --git a/doc/src/sgml/problems.sgml b/doc/src/sgml/problems.sgml index cbacac46be..e8a40f2a7d 100644 --- a/doc/src/sgml/problems.sgml +++ b/doc/src/sgml/problems.sgml @@ -1,4 +1,4 @@ - + Problem Reporting Guidelines diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index 2817959f6c..6c9a9888b6 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -37,7 +37,7 @@ certain environment variables after the connection is established) are covered elsewhere. - + Overview @@ -85,7 +85,7 @@ itself. The difference is historical. - + Protocol @@ -620,7 +620,7 @@ to terminate itself. - + Message Data Types @@ -690,7 +690,7 @@ characters that don't fit into your fixed-size buffer. - + Message Formats diff --git a/doc/src/sgml/query.sgml b/doc/src/sgml/query.sgml index eba1f330a6..32b9b9a2c1 100644 --- a/doc/src/sgml/query.sgml +++ b/doc/src/sgml/query.sgml @@ -1,5 +1,5 @@ @@ -27,7 +27,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/query.sgml,v 1.12 2000/06/14 13:12:17 thoma are extensions to the ANSI standard. - + Interactive Monitor @@ -69,7 +69,7 @@ mydb=> \i basics.sql - + Concepts @@ -93,7 +93,7 @@ mydb=> \i basics.sql - + Creating a New Class @@ -140,7 +140,7 @@ CREATE TABLE weather ( - + Populating a Class with Instances @@ -171,7 +171,7 @@ COPY weather FROM '/home/user/weather.txt' - + Querying a Class @@ -240,7 +240,7 @@ SELECT DISTINCT city - + Redirecting SELECT Queries @@ -259,7 +259,7 @@ SELECT * INTO TABLE temp FROM weather; - + Joins Between Classes @@ -334,7 +334,7 @@ SELECT W1.city, W1.temp_lo AS low, W1.temp_hi AS high, - + Updates @@ -352,7 +352,7 @@ UPDATE weather - + Deletions @@ -374,7 +374,7 @@ DELETE FROM classname; - + Using Aggregate Functions diff --git a/doc/src/sgml/regress.sgml b/doc/src/sgml/regress.sgml index 56e1d61051..fc761c68dd 100644 --- a/doc/src/sgml/regress.sgml +++ b/doc/src/sgml/regress.sgml @@ -45,7 +45,7 @@ the regression tests are current for every official release. - + Regression Environment @@ -191,7 +191,7 @@ setenv PGTZ PST8PDT7,M04.01.0,M10.05.03 - + Regression Test Procedure @@ -305,7 +305,7 @@ setenv PGTZ PST8PDT7,M04.01.0,M10.05.03 - + Regression Analysis @@ -476,7 +476,7 @@ setenv PGTZ PST8PDT7,M04.01.0,M10.05.03 - + Platform-specific comparison files diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 86d96cdc36..9a7bc3e588 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,11 +1,11 @@ Release Notes - + Release 7.1 @@ -362,7 +362,7 @@ Is the postmaster running at 'localhost' and accepting connections on Unix socke - + Run-time configuration @@ -1800,7 +1800,7 @@ openssl x509 -inform PEM -outform PEM -in newreq.pem -out newkey_no_passphrase.p - + Secure TCP/IP Connections with SSH tunnels diff --git a/doc/src/sgml/sources.sgml b/doc/src/sgml/sources.sgml index 347c7efa99..1ab1e0b4cb 100644 --- a/doc/src/sgml/sources.sgml +++ b/doc/src/sgml/sources.sgml @@ -1,11 +1,11 @@ - + Postgres Source Code - + Formatting diff --git a/doc/src/sgml/spi.sgml b/doc/src/sgml/spi.sgml index d453b1ed70..141295c138 100644 --- a/doc/src/sgml/spi.sgml +++ b/doc/src/sgml/spi.sgml @@ -59,7 +59,7 @@ a returned integer value or in SPI_result global variable, as described below). On error, a negative or NULL result will be returned. - + Interface Functions @@ -1096,7 +1096,7 @@ TBD - + Interface Support Functions @@ -2608,7 +2608,7 @@ TBD - + Memory Management @@ -2675,7 +2675,7 @@ this query is done! - + Visibility of Data Changes @@ -2697,7 +2697,7 @@ of Q) or after Q is done. - + Examples diff --git a/doc/src/sgml/sql.sgml b/doc/src/sgml/sql.sgml index 05d6442fbb..51bd5e43c5 100644 --- a/doc/src/sgml/sql.sgml +++ b/doc/src/sgml/sql.sgml @@ -1,5 +1,5 @@ @@ -191,7 +191,7 @@ PART: 4 | 3 - + Relational Data Model Formalities @@ -372,7 +372,7 @@ attributes are taken from. We often write a relation scheme as - + Operations in the Relational Data Model diff --git a/doc/src/sgml/start.sgml b/doc/src/sgml/start.sgml index 438f3b76db..b5093ffed1 100644 --- a/doc/src/sgml/start.sgml +++ b/doc/src/sgml/start.sgml @@ -1,5 +1,5 @@ @@ -40,7 +40,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/start.sgml,v 1.12 2000/05/18 14:24:32 momji language, Postgres SQL. - + Setting Up Your Environment @@ -121,7 +121,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/start.sgml,v 1.12 2000/05/18 14:24:32 momji - + Starting the Interactive Monitor (psql) @@ -200,7 +200,7 @@ FATAL 1:Feb 17 23:19:55:process userid (2360) != database owner (268) - + Managing a Database diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index 957067008c..2749549a19 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,5 +1,5 @@ @@ -19,7 +19,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.24 2000/08/07 19:53:27 tgl types, functions, and operators. - + Key Words @@ -338,7 +338,7 @@ UNCOMMITTED UNNAMED - + Comments @@ -367,7 +367,7 @@ UNCOMMITTED UNNAMED - + Names @@ -404,7 +404,7 @@ UNCOMMITTED UNNAMED - + Constants @@ -548,7 +548,7 @@ CAST ( 'string' AS type ) - + Fields and Columns @@ -650,7 +650,7 @@ CAST ( 'string' AS type ) - + Operators @@ -663,7 +663,7 @@ CAST ( 'string' AS type ) - + Expressions diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index d7858a7ce5..0b3442517c 100644 --- a/doc/src/sgml/trigger.sgml +++ b/doc/src/sgml/trigger.sgml @@ -10,7 +10,7 @@ AFTER on INSERT, DELETE or UPDATE of a tuple as a trigger event. - + Trigger Creation @@ -176,7 +176,7 @@ CREATE TRIGGER trigger [ BEFORE | AFTER ] [ INSERT | - + Interaction with the Trigger Manager @@ -389,7 +389,7 @@ typedef struct Trigger - + Visibility of Data Changes @@ -426,7 +426,7 @@ execution of Q) or after Q is done. - + Examples diff --git a/doc/src/sgml/typeconv.sgml b/doc/src/sgml/typeconv.sgml index bd1c0bbd8f..5169999f98 100644 --- a/doc/src/sgml/typeconv.sgml +++ b/doc/src/sgml/typeconv.sgml @@ -29,7 +29,7 @@ The Programmer's Guide has more details on the exact algorithms used for implicit type conversion and coercion. - + Overview @@ -204,7 +204,7 @@ should use this new function and will no longer do the implicit conversion using - + Operators @@ -419,7 +419,7 @@ will try to oblige. - + Functions @@ -569,7 +569,7 @@ tgl=> select substr(text(1234), 3); - + Query Targets @@ -620,7 +620,7 @@ tgl=> SELECT * FROM vv; - + UNION Queries diff --git a/doc/src/sgml/user-manag.sgml b/doc/src/sgml/user-manag.sgml index 942dde5b35..c1830560b0 100644 --- a/doc/src/sgml/user-manag.sgml +++ b/doc/src/sgml/user-manag.sgml @@ -7,7 +7,7 @@ enough to not warrant explanation. - + Database Users @@ -108,7 +108,7 @@ CREATE USER name - + Groups @@ -125,7 +125,7 @@ ALTER GROUP name DROP USER uname1 - + Privileges @@ -172,7 +172,7 @@ REVOKE ALL ON accounts FROM PUBLIC; - + Functions and Triggers diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index 6a7787dfad..b61c46de9c 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -1,5 +1,5 @@ @@ -51,7 +51,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v 1.20 2000/08/25 15:17:37 thoma and funcs.c. - + Query Language (<acronym>SQL</acronym>) Functions @@ -328,7 +328,7 @@ SELECT clean_EMP(); - + Procedural Language Functions @@ -347,7 +347,7 @@ SELECT clean_EMP(); - + Internal Functions @@ -375,7 +375,7 @@ SELECT clean_EMP(); - + Compiled (C) Language Functions @@ -1198,7 +1198,7 @@ LANGUAGE 'c'; - + Function Overloading diff --git a/doc/src/sgml/xoper.sgml b/doc/src/sgml/xoper.sgml index 2c938148fc..d38e78a4e1 100644 --- a/doc/src/sgml/xoper.sgml +++ b/doc/src/sgml/xoper.sgml @@ -1,5 +1,5 @@ @@ -76,7 +76,7 @@ SELECT (a + b) AS c FROM test_complex; COMMUTATOR and other optimizer hints appear below. - + Operator Optimization Information diff --git a/doc/src/sgml/xplang.sgml b/doc/src/sgml/xplang.sgml index 4c566b43c4..af88de1342 100644 --- a/doc/src/sgml/xplang.sgml +++ b/doc/src/sgml/xplang.sgml @@ -1,5 +1,5 @@ @@ -23,7 +23,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/xplang.sgml,v 1.8 2000/04/02 22:59:40 tgl E is outside the scope of this manual. - + Installing Procedural Languages diff --git a/doc/src/sgml/xtypes.sgml b/doc/src/sgml/xtypes.sgml index af307671fa..b28830f288 100644 --- a/doc/src/sgml/xtypes.sgml +++ b/doc/src/sgml/xtypes.sgml @@ -9,7 +9,7 @@ are in funcs.sql. - + User-Defined Types -- 2.11.0