docbook problem

Поиск
Список
Период
Сортировка
Искать

docbook problem

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
I get the following output from:

	gmake programmer.html

I am missing something?  Configure says I don't have DocBook V3.1.  Any
idea how I configure that with OpenJade?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
openjade  -D . -D ./ref -D ./../graphics -c /usr/local/share/sgml/stylesheets/docbook/catalog -d stylesheet.dsl -i output-html -t sgml book-decl.sgml programmer.sgml
openjade:book-decl.sgml:1:55:W: cannot generate system identifier for public text "-//OASIS//DTD DocBook V3.1//EN"
openjade:book-decl.sgml:11:0:E: reference to entity "BOOK" for which no system identifier could be generated
openjade:book-decl.sgml:1:0: entity was defined here
openjade:book-decl.sgml:11:0:E: DTD did not contain element declaration for document type name
openjade:programmer.sgml:7:9:E: there is no attribute "ID"
openjade:programmer.sgml:7:21:E: element "BOOK" undefined
openjade:programmer.sgml:9:7:E: element "TITLE" undefined
openjade:programmer.sgml:10:10:E: element "BOOKINFO" undefined
openjade:programmer.sgml:11:13:E: element "CORPAUTHOR" undefined
openjade:legal.sgml:5:10:E: element "COPYRIGHT" undefined
openjade:legal.sgml:6:6:E: element "YEAR" undefined
openjade:legal.sgml:7:8:E: element "HOLDER" undefined
openjade:legal.sgml:10:12:E: element "LEGALNOTICE" undefined
openjade:legal.sgml:11:7:E: element "TITLE" undefined
openjade:legal.sgml:13:6:E: element "PARA" undefined
openjade:legal.sgml:14:14:E: element "PRODUCTNAME" undefined
openjade:legal.sgml:14:54:E: general entity "copy" not defined and no default entity
openjade:legal.sgml:19:6:E: element "PARA" undefined
openjade:legal.sgml:20:14:E: element "PRODUCTNAME" undefined
openjade:legal.sgml:24:6:E: element "PARA" undefined
openjade:legal.sgml:32:6:E: element "PARA" undefined
openjade:legal.sgml:40:6:E: element "PARA" undefined
openjade:intro.sgml:5:13:E: there is no attribute "ID"
openjade:intro.sgml:5:22:E: element "PREFACE" undefined
openjade:intro.sgml:6:8:E: element "TITLE" undefined
openjade:intro.sgml:8:12:E: there is no attribute "ID"
openjade:intro.sgml:8:26:E: element "SECT1" undefined
openjade:intro.sgml:9:9:E: element "TITLE" undefined
openjade:intro.sgml:9:31:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:11:8:E: element "PARA" undefined
openjade:intro.sgml:12:16:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:13:40:E: element "ACRONYM" undefined
openjade:intro.sgml:14:15:E: there is no attribute "URL"
openjade:intro.sgml:14:75:E: element "ULINK" undefined
openjade:intro.sgml:15:16:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:17:41:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:20:13:E: element "ACRONYM" undefined
openjade:intro.sgml:21:13:E: element "ACRONYM" undefined
openjade:intro.sgml:22:13:E: element "ACRONYM" undefined
openjade:intro.sgml:25:8:E: element "PARA" undefined
openjade:intro.sgml:26:16:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:31:8:E: element "PARA" undefined
openjade:intro.sgml:32:16:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:36:13:E: element "ACRONYM" undefined
openjade:intro.sgml:44:44:E: element "QUOTE" undefined
openjade:intro.sgml:47:16:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:52:15:E: element "SIMPLELIST" undefined
openjade:intro.sgml:53:12:E: element "MEMBER" undefined
openjade:intro.sgml:54:12:E: element "MEMBER" undefined
openjade:intro.sgml:55:12:E: element "MEMBER" undefined
openjade:intro.sgml:59:8:E: element "PARA" undefined
openjade:intro.sgml:62:15:E: element "SIMPLELIST" undefined
openjade:intro.sgml:63:12:E: element "MEMBER" undefined
openjade:intro.sgml:64:12:E: element "MEMBER" undefined
openjade:intro.sgml:65:12:E: element "MEMBER" undefined
openjade:intro.sgml:66:12:E: element "MEMBER" undefined
openjade:intro.sgml:70:8:E: element "PARA" undefined
openjade:intro.sgml:71:35:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:73:14:E: element "FIRSTTERM" undefined
openjade:intro.sgml:74:40:E: element "FIRSTTERM" undefined
openjade:intro.sgml:77:29:E: element "PRODUCTNAME" undefined
openjade:intro.sgml:80:51:E: element "PRODUCTNAME" undefined
openjade:history.sgml:5:19:E: element "SECT1" undefined
openjade:history.sgml:6:7:E: element "TITLE" undefined
openjade:history.sgml:6:39:E: element "PRODUCTNAME" undefined
openjade:history.sgml:8:6:E: element "PARA" undefined
openjade:history.sgml:10:14:E: element "PRODUCTNAME" undefined
openjade:history.sgml:11:14:E: element "PRODUCTNAME" undefined
openjade:history.sgml:12:14:E: element "PRODUCTNAME" undefined
openjade:history.sgml:14:37:E: element "PRODUCTNAME" undefined
openjade:history.sgml:22:7:E: element "SECT2" undefined
openjade:history.sgml:23:8:E: element "TITLE" undefined
openjade:history.sgml:23:34:E: element "PRODUCTNAME" undefined
openjade:history.sgml:25:7:E: element "PARA" undefined
openjade:history.sgml:26:37:E: element "PRODUCTNAME" undefined
openjade:history.sgml:27:11:E: element "ACRONYM" undefined
openjade:history.sgml:29:17:E: there is no attribute "ENDTERM"
openjade:history.sgml:29:39:E: there is no attribute "LINKEND"
openjade:history.sgml:29:47:E: element "XREF" undefined
openjade:history.sgml:32:47:E: element "XREF" undefined
openjade:history.sgml:35:49:E: element "XREF" undefined
openjade:history.sgml:38:49:E: element "XREF" undefined
openjade:history.sgml:39:8:E: end tag for "XREF" omitted, but its declaration does not permit this
openjade:history.sgml:38:3: start tag was here
openjade:history.sgml:39:8:E: end tag for "XREF" omitted, but its declaration does not permit this
openjade:history.sgml:35:3: start tag was here
openjade:history.sgml:39:8:E: end tag for "XREF" omitted, but its declaration does not permit this
openjade:history.sgml:32:3: start tag was here
openjade:history.sgml:39:8:E: end tag for "XREF" omitted, but its declaration does not permit this
openjade:history.sgml:29:3: start tag was here
openjade:history.sgml:41:7:E: element "PARA" undefined
openjade:history.sgml:42:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:44:47:E: element "ACRONYM" undefined
openjade:history.sgml:46:49:E: element "XREF" undefined
openjade:history.sgml:49:48:E: element "XREF" undefined
openjade:history.sgml:52:50:E: element "XREF" undefined
openjade:history.sgml:58:31:E: element "PRODUCTNAME" undefined
openjade:history.sgml:60:8:E: end tag for "XREF" omitted, but its declaration does not permit this
openjade:history.sgml:52:4: start tag was here
openjade:history.sgml:60:8:E: end tag for "XREF" omitted, but its declaration does not permit this
openjade:history.sgml:49:4: start tag was here
openjade:history.sgml:60:8:E: end tag for "XREF" omitted, but its declaration does not permit this
openjade:history.sgml:46:3: start tag was here
openjade:history.sgml:62:7:E: element "PARA" undefined
openjade:history.sgml:63:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:70:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:73:40:E: element "ULINK" undefined
openjade:history.sgml:75:40:E: element "ULINK" undefined
openjade:history.sgml:78:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:80:69:E: element "ULINK" undefined
openjade:history.sgml:84:7:E: element "PARA" undefined
openjade:history.sgml:95:7:E: element "SECT2" undefined
openjade:history.sgml:96:8:E: element "TITLE" undefined
openjade:history.sgml:96:21:E: element "PRODUCTNAME" undefined
openjade:history.sgml:98:7:E: element "PARA" undefined
openjade:history.sgml:100:51:E: element "PRODUCTNAME" undefined
openjade:history.sgml:101:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:103:54:E: element "PRODUCTNAME" undefined
openjade:history.sgml:107:7:E: element "PARA" undefined
openjade:history.sgml:108:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:111:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:113:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:116:16:E: element "ITEMIZEDLIST" undefined
openjade:history.sgml:117:13:E: element "LISTITEM" undefined
openjade:history.sgml:118:10:E: element "PARA" undefined
openjade:history.sgml:119:37:E: element "PRODUCTNAME" undefined
openjade:history.sgml:120:14:E: element "ACRONYM" undefined
openjade:history.sgml:122:18:E: element "PRODUCTNAME" undefined
openjade:history.sgml:123:39:E: element "PRODUCTNAME" undefined
openjade:history.sgml:124:14:E: element "ACRONYM" undefined
openjade:history.sgml:126:19:E: element "FILENAME" undefined
openjade:history.sgml:127:30:E: element "ACRONYM" undefined
openjade:history.sgml:132:13:E: element "LISTITEM" undefined
openjade:history.sgml:133:10:E: element "PARA" undefined
openjade:history.sgml:135:19:E: element "APPLICATION" undefined
openjade:history.sgml:136:20:E: element "ACRONYM" undefined
openjade:history.sgml:136:44:E: element "FILENAME" undefined
openjade:history.sgml:140:13:E: element "LISTITEM" undefined
openjade:history.sgml:141:10:E: element "PARA" undefined
openjade:history.sgml:142:43:E: element "FILENAME" undefined
openjade:history.sgml:143:25:E: element "ACRONYM" undefined
openjade:history.sgml:145:18:E: element "APPLICATION" undefined
openjade:history.sgml:146:36:E: element "PRODUCTNAME" undefined
openjade:history.sgml:150:13:E: element "LISTITEM" undefined
openjade:history.sgml:151:10:E: element "PARA" undefined
openjade:history.sgml:158:13:E: element "LISTITEM" undefined
openjade:history.sgml:159:10:E: element "PARA" undefined
openjade:history.sgml:165:13:E: element "LISTITEM" undefined
openjade:history.sgml:166:10:E: element "PARA" undefined
openjade:history.sgml:167:51:E: element "ACRONYM" undefined
openjade:history.sgml:168:35:E: element "PRODUCTNAME" undefined
openjade:history.sgml:173:13:E: element "LISTITEM" undefined
openjade:history.sgml:174:10:E: element "PARA" undefined
openjade:history.sgml:175:14:E: element "ACRONYM" undefined
openjade:history.sgml:175:55:E: element "ACRONYM" undefined
openjade:history.sgml:176:42:E: element "PRODUCTNAME" undefined
openjade:history.sgml:177:45:E: element "PRODUCTNAME" undefined
openjade:history.sgml:185:7:E: element "SECT2" undefined
openjade:history.sgml:186:8:E: element "TITLE" undefined
openjade:history.sgml:186:21:E: element "PRODUCTNAME" undefined
openjade:history.sgml:188:7:E: element "PARA" undefined
openjade:history.sgml:191:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:192:36:E: element "PRODUCTNAME" undefined
openjade:history.sgml:193:32:E: element "ACRONYM" undefined
openjade:history.sgml:196:15:E: element "PRODUCTNAME" undefined
openjade:history.sgml:199:7:E: element "PARA" undefined
openjade:history.sgml:200:50:E: element "PRODUCTNAME" undefined
openjade:history.sgml:202:20:E: element "PRODUCTNAME" undefined
openjade:history.sgml:207:7:E: element "PARA" undefined
openjade:history.sgml:208:37:E: element "PRODUCTNAME" undefined
openjade:history.sgml:211:15:E: element "ITEMIZEDLIST" undefined
openjade:history.sgml:212:12:E: element "LISTITEM" undefined
openjade:history.sgml:213:9:E: element "PARA" undefined
openjade:history.sgml:221:12:E: element "LISTITEM" undefined
openjade:history.sgml:222:9:E: element "PARA" undefined
openjade:history.sgml:228:12:E: element "LISTITEM" undefined
openjade:history.sgml:229:9:E: element "PARA" undefined
openjade:history.sgml:230:24:E: element "ACRONYM" undefined
openjade:history.sgml:236:12:E: element "LISTITEM" undefined
openjade:history.sgml:237:9:E: element "PARA" undefined
openjade:history.sgml:243:12:E: element "LISTITEM" undefined
openjade:history.sgml:244:9:E: element "PARA" undefined
openjade:info.sgml:5:21:E: element "SECT1" undefined
openjade:info.sgml:6:7:E: element "TITLE" undefined
openjade:info.sgml:8:6:E: element "PARA" undefined
openjade:info.sgml:11:15:E: element "VARIABLELIST" undefined
openjade:info.sgml:12:16:E: element "VARLISTENTRY" undefined
openjade:info.sgml:13:9:E: element "TERM" undefined
openjade:info.sgml:14:13:E: element "LISTITEM" undefined
openjade:info.sgml:15:10:E: element "PARA" undefined
openjade:info.sgml:21:16:E: element "VARLISTENTRY" undefined
openjade:info.sgml:22:9:E: element "TERM" undefined
openjade:info.sgml:23:13:E: element "LISTITEM" undefined
openjade:info.sgml:24:10:E: element "PARA" undefined
openjade:info.sgml:31:16:E: element "VARLISTENTRY" undefined
openjade:info.sgml:32:9:E: element "TERM" undefined
openjade:info.sgml:33:13:E: element "LISTITEM" undefined
openjade:info.sgml:34:10:E: element "PARA" undefined
openjade:info.sgml:42:16:E: element "VARLISTENTRY" undefined
openjade:info.sgml:43:9:E: element "TERM" undefined
openjade:info.sgml:44:13:E: element "LISTITEM" undefined
openjade:info.sgml:45:10:E: element "PARA" undefined
openjade:info.sgml:51:16:E: element "VARLISTENTRY" undefined
openjade:info.sgml:52:9:E: element "TERM" undefined
openjade:info.sgml:53:13:E: element "LISTITEM" undefined
openjade:info.sgml:54:10:E: element "PARA" undefined
openjade:info.sgml:60:16:E: element "VARLISTENTRY" undefined
openjade:info.sgml:61:9:E: element "TERM" undefined
openjade:info.sgml:62:13:E: element "LISTITEM" undefined
openjade:I: maximum number of errors (200) reached; change with -E option
openjade:stylesheet.dsl:2:73:W: cannot generate system identifier for public text "-//James Clark//DTD DSSSL Style Sheet//EN"
openjade:stylesheet.dsl:21:0:E: reference to entity "STYLE-SHEET" for which no system identifier could be generated
openjade:stylesheet.dsl:2:0: entity was defined here
openjade:stylesheet.dsl:21:0:E: DTD did not contain element declaration for document type name
openjade:stylesheet.dsl:10:0:E: notation "DSSSL" for entity "dbstyle" undefined
openjade:stylesheet.dsl:23:12:E: element "STYLE-SHEET" undefined
openjade:stylesheet.dsl:24:26:E: there is no attribute "USE"
openjade:stylesheet.dsl:24:35:E: element "STYLE-SPECIFICATION" undefined
openjade:stylesheet.dsl:25:27:E: element "STYLE-SPECIFICATION-BODY" undefined
openjade:stylesheet.dsl:89:28:E: there is no attribute "ID"
openjade:stylesheet.dsl:89:47:E: there is no attribute "DOCUMENT"
openjade:stylesheet.dsl:89:56:E: element "EXTERNAL-SPECIFICATION" undefined
openjade:stylesheet.dsl:90:13:E: end tag for "EXTERNAL-SPECIFICATION" omitted, but its declaration does not permit this
openjade:stylesheet.dsl:89:1: start tag was here
openjade:E: specification document does not have the DSSSL architecture as a base architecture

 PostgreSQL 7.2 Programmer's Guide
   The PostgreSQL Global Development Group
  
 1996-2001
 PostgreSQL Global Development Group

 Legal Notice

   PostgreSQL is Copyright  1996-2001
  by the PostgreSQL Global Development Group and is distributed under
  the terms of the license of the University of California below.
 

   Postgres95 is Copyright  1994-5 
  by the Regents of the University of California.
 

   Permission to use, copy, modify, and distribute this software and
  its documentation for any purpose, without fee, and without a
  written agreement is hereby granted, provided that the above
  copyright notice and this paragraph and the following two paragraphs
  appear in all copies.
 

   IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY
  PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL
  DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS
  SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA
  HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 

   THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
  INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
  MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE
  PROVIDED HEREUNDER IS ON AN "AS-IS" BASIS, AND THE UNIVERSITY OF
  CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTAINANCE, SUPPORT,
  UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
 




 

  
   Preface

      What is PostgreSQL?

       PostgreSQL is an object-relational
    database management system (ORDBMS) based on
        POSTGRES, Version 4.2,
    developed at the University of California at Berkeley Computer
    Science Department.  The POSTGRES
    project, led by Professor Michael Stonebraker, was sponsored by
    the Defense Advanced Research Projects Agency
    (DARPA), the Army Research Office
    (ARO), the National Science Foundation
    (NSF), and ESL, Inc.
   

       PostgreSQL is an open-source descendant of
    this original Berkeley code.  It provides SQL92/SQL99 language support
    and other modern features.
   

       POSTGRES pioneered many of the
    object-relational concepts now becoming available in some commercial
    databases.
    Traditional   relational  database  management  systems
    (RDBMS) support a data model consisting of a collection
    of named relations, containing attributes of a specific
    type.  In current commercial  systems,  possible  types
    include  floating  point  numbers,  integers, character
    strings, money, and dates.  It is  commonly  recognized
    that  this model is inadequate for future data 
    processing applications.
    The relational  model  successfully  replaced  previous
    models  in  part  because  of its Spartan simplicity.
    However, as mentioned, this simplicity often makes  the
    implementation  of  certain applications very difficult.
    Postgres offers  substantial additional
    power  by  incorporating  the following additional
    concepts in such a way that  users  can  easily
    extend the system:

         inheritance
     data types
     functions
    
   

       Other features provide additional power and flexibility:

         constraints
     triggers
     rules
     transaction integrity
    
   

       These features put Postgres into the
    category of databases referred to as
    object-relational. Note that this is distinct
    from those referred to as object-oriented,
    which in general are not as well suited to supporting the
    traditional relational database languages.
    So, although Postgres has some
    object-oriented features, it is firmly in the relational database
    world. In fact, some commercial databases have recently
    incorporated features pioneered by Postgres.
   

  

   
 A Short History of Postgres

   The object-relational database management system now known as 
  PostgreSQL (and briefly called
  Postgres95) is derived from the
  Postgres package written at the University of
  California at Berkeley.  With over a decade of
  development behind it, PostgreSQL 
  is the most advanced open-source database available anywhere,
  offering multi-version concurrency control, supporting almost
  all SQL constructs (including subselects, transactions, and
  user-defined types and functions), and having a wide range of
  language bindings available (including C, C++, Java, Perl, Tcl, and Python).
 

   The Berkeley Postgres Project

     Implementation of the Postgres 
   DBMS began in 1986.  The
   initial  concepts  for  the  system  were  presented in
      and the definition of the initial  data  model
   appeared in 
   .
   The design of the rule system at
   that time was described in  
   .
   The  rationale
   and  architecture  of the storage manager were detailed in 
   .
  

     Postgres has undergone  several  major  releases  since
   then.   The  first "demoware" system became operational
   in 1987 and was shown at the  1988  ACM-SIGMOD  
   Conference.   We  released Version 1, described in 
   ,
   to a few external users in June 1989.  In response to a
   critique  of  the  first rule system 
   (), 
   the rule
   system was  redesigned 
   ()
   and  Version  2  was
   released  in  June 1990 with the new rule system.  
   Version 3 appeared in 1991 and added support for  multiple
   storage  managers,  an  improved  query executor, and a
   rewritten rewrite rule  system.   For  the  most  part,
   releases  until Postgres95 (see below)
   focused on portability and reliability.
  

     Postgres has been  used
   to  implement  many  different
   research and production applications.  These include: a
   financial data analysis system, a  jet  engine  
   performance   monitoring   package,   an   asteroid  tracking
   database, a medical information database,  and  several
   geographic information systems.  
   Postgres has also been
   used as an educational tool  at  several  universities.
   Finally,  
   Illustra  Information  Technologies
   (since merged into
   Informix)
   picked up
   the code and commercialized it.
   Postgres  became  the  primary  data  manager
   for  the
   Sequoia 2000
   scientific computing project in late 1992.
  

     The size of the  external  user  community
   nearly  doubled  during  1993.   It became increasingly
   obvious that maintenance of the prototype code and 
   support  was  taking  up large amounts of time that should
   have been devoted to database research.  In  an  effort
   to  reduce  this support burden, the project officially
   ended with Version 4.2.
  
 

   Postgres95

     In 1994, Andrew Yu and Jolly Chen
   added a SQL language interpreter to Postgres.
   Postgres95 was subsequently released to
   the Web to find its own way in the world as an
   open-source descendant of the original Postgres
   Berkeley code.
  

     Postgres95 code was completely
   ANSI C and trimmed in size by 25%. Many
   internal changes improved performance and maintainability. 
   Postgres95 v1.0.x ran about  30-50%
   faster  on  the  Wisconsin  Benchmark compared to 
   Postgres v4.2.
   Apart from bug fixes, these were the major enhancements:

                  The query language Postquel was replaced with
      SQL (implemented in the server).
      Subqueries were not supported until
      PostgreSQL (see below), but they
      could be imitated in Postgres95 with user-defined
      SQL functions. Aggregates were
      re-implemented.  Support for the GROUP BY query clause was also added.
      The libpq interface remained
      available  for  C  
      programs.
     
    

               In addition to the monitor program, a new program
      (psql) was provided for interactive SQL queries
      using GNU readline.
     
    

               A new  front-end  library,  libpgtcl,
      supported  Tcl-based  clients.   A sample shell, 
      pgtclsh, provided new Tcl  commands  to  interface
      tcl
      programs with the Postgres95 backend.
     
    

               The  large  object interface was overhauled. The Inversion large objects were
      the  only  mechanism for  storing  large objects.
      (The Inversion file system was removed.)
     
    

               The  instance-level  rule  system  was removed.
      Rules were still available as rewrite rules.
     
    

               A short tutorial introducing regular SQL features as
      well as those of Postgres95 was
      distributed with the source code.
     
    

               GNU make (instead of  BSD  make)  was  used
      for  the build.  Also,  Postgres95  could  be
      compiled with an unpatched gcc
      (data alignment of  doubles  was fixed).
     
    
   
  
 

   PostgreSQL

     By 1996, it became clear that the name "Postgres95" would
   not stand the test of time. We chose a new name,
   PostgreSQL, to reflect the relationship
   between the original Postgres and the more
   recent versions with SQL capability.  At the same
   time, we set the version numbering to start at 6.0, putting the
   numbers back into the sequence originally begun by the
   Postgres Project.
  

     The emphasis during development of Postgres95
   was on identifying and understanding existing problems in the backend code.
   With PostgreSQL, 
   the emphasis has shifted to augmenting features and capabilities, although
   work continues in all areas.
  

     Major enhancements in PostgreSQL include:
  

              Table-level locking has been replaced with multi-version concurrency control,
     which allows readers to continue reading consistent data during writer activity
     and enables hot backups from pg_dump while the database stays available for
     queries.
    
   

            Important backend features, including subselects, defaults, 
     constraints, and triggers, have been implemented.
    
   

            Additional SQL92-compliant language features have been added,
     including primary keys, quoted identifiers, literal string type coercion,
     type casting, and binary and hexadecimal integer input.
    
   

            Built-in types have been improved, including new wide-range date/time types 
     and additional geometric type support.
    
   

            Overall backend code speed has been increased by approximately 20-40%, 
     and backend start-up time has decreased 80% since version 6.0 was released.
    
   
  
 


   
 Documentation Resources

   This manual set is organized into several parts:

         Tutorial
               An introduction for new users. Does not cover advanced features.
     
    
   

       User's Guide
               Documents the SQL query language environment, including data types
      and functions.
     
    
   

       Programmer's Guide
               Advanced information for application programmers. Topics include
      type and function extensibility, library interfaces,
      and application design issues.
     
    
   

       Administrator's Guide
               Installation and server management information
     
    
   

       Reference Manual
               Reference pages for SQL command syntax and client and server programs
     
    
   

       Developer's Guide
    gmake: *** [programmer.html] Error 1

Re: docbook problem

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
Bruce Momjian writes:

> I get the following output from:
>
> 	gmake programmer.html
>
> I am missing something?  Configure says I don't have DocBook V3.1.  Any
> idea how I configure that with OpenJade?

Set the environment variable SGML_CATALOG_FILES to point to the catalog
file for for DocBook V3.1, e.g.

export SGML_CATALOG_FILES=/somewhere/docbook31/docbook.cat

See also:

http://www.docbook.org/tdg/html/appa.html

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Re: docbook problem

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
> Bruce Momjian writes:
> 
> > I get the following output from:
> >
> > 	gmake programmer.html
> >
> > I am missing something?  Configure says I don't have DocBook V3.1.  Any
> > idea how I configure that with OpenJade?
> 
> Set the environment variable SGML_CATALOG_FILES to point to the catalog
> file for for DocBook V3.1, e.g.
> 
> export SGML_CATALOG_FILES=/somewhere/docbook31/docbook.cat
> 
> See also:
> 
> http://www.docbook.org/tdg/html/appa.html

OK, I am farther now.  The problem now is that the output is streaming
to my screen as flat text, rather than creating html.  Any ideas?

Make output attached.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
gmake -C sgml clean
gmake[1]: Entering directory `/usr/var/local/src/gen/pgsql/CURRENT/pgsql/doc/src/sgml'
rm -f HTML.manifest *.html
rm -rf *.1 *.l man1 manl manpage.refs manpage.links manpage.log
rm -f *.rtf *.tex *.dvi *.aux *.log *.ps *.pdf
rm -f HTML.index bookindex.sgml setindex.sgml
gmake[1]: Leaving directory `/usr/var/local/src/gen/pgsql/CURRENT/pgsql/doc/src/sgml'
gmake -C sgml admin.html
gmake[1]: Entering directory `/usr/var/local/src/gen/pgsql/CURRENT/pgsql/doc/src/sgml'
perl /usr/local/share/sgml/stylesheets/docbook/bin/collateindex.pl -f -g -t 'Index' -o bookindex.sgml -N
perl /usr/local/share/sgml/stylesheets/docbook/bin/collateindex.pl -f -g -t 'Index' -x -o setindex.sgml -N
openjade  -D . -D ./ref -D ./../graphics -c /usr/local/share/sgml/stylesheets/docbook/catalog -d stylesheet.dsl -i output-html -t sgml book-decl.sgml admin.sgml
openjade:/usr/local/sgml/stylesheets/docbook.cat:22:0:W: DTDDECL catalog entries are not supported
openjade:/usr/local/sgml/stylesheets/docbook.cat:22:0:W: DTDDECL catalog entries are not supported
openjade:/usr/local/sgml/stylesheets/docbook.cat:22:0:W: DTDDECL catalog entries are not supported
openjade:stylesheet.dsl:2:73:W: cannot generate system identifier for public text "-//James Clark//DTD DSSSL Style Sheet//EN"
openjade:stylesheet.dsl:21:0:E: reference to entity "STYLE-SHEET" for which no system identifier could be generated
openjade:stylesheet.dsl:2:0: entity was defined here
openjade:stylesheet.dsl:21:0:E: DTD did not contain element declaration for document type name
openjade:stylesheet.dsl:10:0:E: notation "DSSSL" for entity "dbstyle" undefined
openjade:stylesheet.dsl:23:12:E: element "STYLE-SHEET" undefined
openjade:stylesheet.dsl:24:26:E: there is no attribute "USE"
openjade:stylesheet.dsl:24:35:E: element "STYLE-SPECIFICATION" undefined
openjade:stylesheet.dsl:25:27:E: element "STYLE-SPECIFICATION-BODY" undefined
openjade:stylesheet.dsl:89:28:E: there is no attribute "ID"
openjade:stylesheet.dsl:89:47:E: there is no attribute "DOCUMENT"
openjade:stylesheet.dsl:89:56:E: element "EXTERNAL-SPECIFICATION" undefined
openjade:stylesheet.dsl:90:13:E: end tag for "EXTERNAL-SPECIFICATION" omitted, but its declaration does not permit this
openjade:stylesheet.dsl:89:1: start tag was here
openjade:E: specification document does not have the DSSSL architecture as a base architecture
PostgreSQL 7.2 Administrator's GuideThe PostgreSQL Global Development Group1996-2001PostgreSQL Global Development GroupLegal Notice  PostgreSQL is Copyright � 1996-2001
  by the PostgreSQL Global Development Group and is distributed under
  the terms of the license of the University of California below.
   Postgres95 is Copyright � 1994-5 
  by the Regents of the University of California.
   Permission to use, copy, modify, and distribute this software and

Re: docbook problem

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
Bruce Momjian writes:

> OK, I am farther now.  The problem now is that the output is streaming
> to my screen as flat text, rather than creating html.  Any ideas?

This is a weird behaviour of jade if it can't read the style sheet.  You
need to add the DSSSL catalog to your SGML_CATALOG_FILES as well:

export SGML_CATALOG_FILES=otherstuff:/some/where/dsssl.cat

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Re: docbook problem

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
> Bruce Momjian writes:
> 
> > OK, I am farther now.  The problem now is that the output is streaming
> > to my screen as flat text, rather than creating html.  Any ideas?
> 
> This is a weird behaviour of jade if it can't read the style sheet.  You
> need to add the DSSSL catalog to your SGML_CATALOG_FILES as well:
> 
> export SGML_CATALOG_FILES=otherstuff:/some/where/dsssl.cat

Still not working.  I don't have a dsssl.cat file.  I downloaded
OpenJade, the ISO images (renamed as iso-*.gml), and downloaded the
docbook 3.1 and Norman Walsh style sheets 1.64.

I dumped the ISO and docbook 3.1 in the same directory, and put the
Norman Walsh in a subdirectory called docbook.  Is that correct?

Here is a recusive ls of my sgml directory.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
ISOEnts.zip	db164.zip	docbk31.zip	stylesheets/

./stylesheets:
31chg.txt	dbhier.mod	iso-amsa.gml	iso-cyr1.gml	iso-lat1.gml
40issues.txt	dbnotn.mod	iso-amsb.gml	iso-cyr2.gml	iso-lat2.gml
50issues.txt	dbpool.mod	iso-amsc.gml	iso-dia.gml	iso-num.gml
ChangeLog	docbook/	iso-amsn.gml	iso-grk1.gml	iso-pub.gml
cals-tbl.dtd	docbook.cat	iso-amso.gml	iso-grk2.gml	iso-tech.gml
dbcent.mod	docbook.dcl	iso-amsr.gml	iso-grk3.gml	readme.txt
dbgenent.mod	docbook.dtd	iso-box.gml	iso-grk4.gml

./stylesheets/docbook:
BUGS		VERSION		common/		frames/		olink/
ChangeLog	WhatsNew	contrib/	html/		print/
README		bin/		docbook.dcl	images/		test/
TODO		catalog		dtds/		lib/

./stylesheets/docbook/bin:
ChangeLog		LostLog			collateindex.pl

./stylesheets/docbook/common:
ChangeLog	dbl1de.dsl	dbl1fr.dsl	dbl1nl.dsl	dbl1ro.ent
LostLog		dbl1de.ent	dbl1fr.ent	dbl1nl.ent	dbl1ru.dsl
Oldversion.sgm	dbl1el.dsl	dbl1hu.dsl	dbl1no.dsl	dbl1ru.ent
README		dbl1el.ent	dbl1hu.ent	dbl1no.ent	dbl1sk.dsl
dbcommon.dsl	dbl1en.dsl	dbl1id.dsl	dbl1null.dsl	dbl1sk.ent
dbl10n.dsl	dbl1en.ent	dbl1id.ent	dbl1pl.dsl	dbl1sl.dsl
dbl1ca.dsl	dbl1es.dsl	dbl1it.dsl	dbl1pl.ent	dbl1sl.ent
dbl1ca.ent	dbl1es.ent	dbl1it.ent	dbl1pt.dsl	dbl1sv.dsl
dbl1cs.dsl	dbl1et.dsl	dbl1ja.dsl	dbl1pt.ent	dbl1sv.ent
dbl1cs.ent	dbl1et.ent	dbl1ja.ent	dbl1ptbr.dsl	dbl1zhcn.dsl
dbl1da.dsl	dbl1fi.dsl	dbl1ko.dsl	dbl1ptbr.ent	dbl1zhcn.ent
dbl1da.ent	dbl1fi.ent	dbl1ko.ent	dbl1ro.dsl	dbtable.dsl

./stylesheets/docbook/contrib:
html/		imagemap/	print/		renumberinpart/	subdoc/

./stylesheets/docbook/contrib/html:
ChangeLog		LostLog			short-biblioentry.dsl

./stylesheets/docbook/contrib/imagemap:
ChangeLog	LostLog		imagemap.dsl	testdoc.sgm	testimg.jpg

./stylesheets/docbook/contrib/print:
ChangeLog		LostLog			short-biblioentry.dsl

./stylesheets/docbook/contrib/renumberinpart:
ChangeLog		renumberinpart.dsl
LostLog			test.sgm

./stylesheets/docbook/contrib/subdoc:
ChangeLog	book.sgm	subdoc.dtd	subdoc2.sgm
LostLog		subdoc.dsl	subdoc1.sgm	subdocbc.mod

./stylesheets/docbook/dtds:
dbdsssl/	decls/		html/		imagelib/	olink/

./stylesheets/docbook/dtds/dbdsssl:
ChangeLog	LostLog		dbdsssl.dtd

./stylesheets/docbook/dtds/decls:
ChangeLog	LostLog		docbook.dcl	xml.dcl

./stylesheets/docbook/dtds/html:
ChangeLog	LostLog		dbhtml.dcl	test.htm
ISOlat1.gml	catalog		dbhtml.dtd

./stylesheets/docbook/dtds/imagelib:
ChangeLog	LostLog		imagelib.dtd

./stylesheets/docbook/dtds/olink:
ChangeLog	LostLog		olinksum.dtd

./stylesheets/docbook/frames:
ChangeLog	README		docbook.js	frames.htm
LostLog		docbook.css	frames.dsl	navbar.htm

./stylesheets/docbook/html:
ChangeLog		dbdivis.dsl		dbnavig.dsl
LostLog			dbefsyn.dsl		dbparam.dsl
OldChangelog.sgm	dbfootn.dsl		dbpi.dsl
README			dbgloss.dsl		dbprocdr.dsl
XREF			dbgraph.dsl		dbrfntry.dsl
catalog			dbhtml.dsl		dbsect.dsl
db31.dsl		dbindex.dsl		dbsynop.dsl
dbadmon.dsl		dbinfo.dsl		dbtable.dsl
dbautoc.dsl		dbinline.dsl		dbtitle.dsl
dbbibl.dsl		dblink.dsl		dbttlpg.dsl
dbblock.dsl		dblists.dsl		dbverb.dsl
dbcallou.dsl		dblot.dsl		docbook.dsl
dbchunk.dsl		dbmath.dsl		version.dsl
dbcompon.dsl		dbmsgset.dsl

./stylesheets/docbook/images:
ChangeLog	caution.gif	next.gif	tip.gif		toc-plus.gif
LostLog		home.gif	note.gif	toc-blank.gif	up.gif
callouts/	important.gif	prev.gif	toc-minus.gif	warning.gif

./stylesheets/docbook/images/callouts:
1.gif		3.gif		6.gif		9.gif
10.gif		4.gif		7.gif		ChangeLog
2.gif		5.gif		8.gif		LostLog

./stylesheets/docbook/lib:
ChangeLog	LostLog		Oldversion.sgm	README		dblib.dsl

./stylesheets/docbook/olink:
ChangeLog	LostLog		README		olink.dsl

./stylesheets/docbook/print:
ChangeLog		dbdivis.dsl		dbprint.dsl
LostLog			dbefsyn.dsl		dbprocdr.dsl
OldChangelog.sgm	dbgloss.dsl		dbrfntry.dsl
README			dbgraph.dsl		dbsect.dsl
XREF			dbindex.dsl		dbsynop.dsl
catalog			dbinfo.dsl		dbtable.dsl
db31.dsl		dbinline.dsl		dbtitle.dsl
dbadmon.dsl		dblink.dsl		dbttlpg.dsl
dbautoc.dsl		dblists.dsl		dbverb.dsl
dbbibl.dsl		dblot.dsl		docbook.dsl
dbblock.dsl		dbmath.dsl		notoc.dsl
dbcallou.dsl		dbmsgset.dsl		plain.dsl
dbcompon.dsl		dbparam.dsl		version.dsl

./stylesheets/docbook/test:
ChangeLog	footnote.sgm	tennis.mpeg	xchapter.sgm	xiterms.sgm
LostLog		genindex.sgm	xarticle.dsl	xcmdsyn.sgm	xlists.sgm
cases/		headft.dsl	xarticle.sgm	xfuncsyn.sgm	xmath.sgm
db31.sgm	imagelib/	xbadtag.sgm	xgloss.sgm	xml/
docbook.css	multicol.dsl	xbiblio2.sgm	xgraphic.sgm	xmlang.sgm
docbook40.xml	multicol.sgm	xblocks.sgm	xheadft.sgm	xreference.sgm
docinfo.sgm	refentry.sgm	xbook.sgm	xinclude.sgm	xsections.sgm
emc2.gif	struct.sgm	xbook2.sgm	xindex.sgm	xset.sgm
emc2i.gif	tennis.jpg	xcallout.sgm	xinlines.sgm	xtables.sgm

./stylesheets/docbook/test/cases:
ChangeLog	callout.sgm	include.sgm	makemlang.pl	sections.sgm
LostLog		cmdsyn.sgm	index.sgm	math.sgm	tables.sgm
biblio.sgm	funcsyn.sgm	inlines.sgm	mlang.sgm	titlepg.sgm
biblio2.sgm	gloss.sgm	iterms.sgm	refent.sgm
blocks.sgm	graphic.sgm	lists.sgm	refentry.sgm

./stylesheets/docbook/test/imagelib:
ChangeLog	LostLog		catalog		imagelib.xml

./stylesheets/docbook/test/xml:
ChangeLog	catalog		xinlines.xml
LostLog		inlines.xml	xml.dcl

Re: docbook problem

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
> > Bruce Momjian writes:
> > 
> > > OK, I am farther now.  The problem now is that the output is streaming
> > > to my screen as flat text, rather than creating html.  Any ideas?
> > 
> > This is a weird behaviour of jade if it can't read the style sheet.  You
> > need to add the DSSSL catalog to your SGML_CATALOG_FILES as well:
> > 
> > export SGML_CATALOG_FILES=otherstuff:/some/where/dsssl.cat
> 
> Still not working.  I don't have a dsssl.cat file.  I downloaded
> OpenJade, the ISO images (renamed as iso-*.gml), and downloaded the
> docbook 3.1 and Norman Walsh style sheets 1.64.
> 
> I dumped the ISO and docbook 3.1 in the same directory, and put the
> Norman Walsh in a subdirectory called docbook.  Is that correct?

Got it working.

I did a Usenet search and someone mentioned having the Jade catalog file
in your SGML_CATALOG_FILES.  I didn't have it in there.  I only had
docbook and the Walsh style sheets.   In fact openjade 1.3 has in its
Makefile:

	$(TARGETS): FORCE
	        @$(MAKE) -f Makefile do=$@ $(dodirs)
	        @if test $@ = 'install'; then \
	          $(LIBTOOL) --finish $(libdir); \
	          mkdir -p $(datadir); \
	          cp -f dsssl/builtins.dsl $(datadir); \
	        fi;

This copies only the builtins.dsl file to /usr/local.  I made a
/usr/local/sgml/jade directory, put _all_ the /dsssl file in it, added
it to my SGML_CATALOG_FILES, and it worked.

So obvious, I don't know why I didn't think of it earlier.  NOT!  It is
software like this that give open source a bad name.  :-)

Is there some trick I missed that would make the dsssl files visible
more automatically?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: docbook problem

От:
Thomas Lockhart <lockhart@fourpalms.org>
Дата:
> Is there some trick I missed that would make the dsssl files visible
> more automatically?

You can make your own catalog file which points at the other catalog
files. You still need to set SGML_CATALOG_FILES (to that one
ubercatalog), or you need to rebuild openjade to know where the correct
default location is.

The Mark Gallesi/Cygnus rpms got this right a couple of years ago, but
the last one or two distros of Mandrake were a bit screwed up.
Mandrake-8.0 is somewhat better, but not perfect. Not sure how Red Hat
does on their rpms...

                     - Thomas

Deadlock

От:
Joseph Paris <paris@mcs.anl.gov>
Дата:
Hey,

I was wondering how pgsql handles multile requests to lock a table?  Say
there are 5 concurent threads attempting a lock on a DB... does pgsql
assign an arbritrary order to these requests or does it just ignore?

Thanks,
Joe Paris


Re: Deadlock

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
Joseph Paris writes:

> I was wondering how pgsql handles multile requests to lock a table?  Say
> there are 5 concurent threads attempting a lock on a DB... does pgsql
> assign an arbritrary order to these requests or does it just ignore?

Presuming that the locks actually conflict, the other 4 will block waiting
for the first transaction to release the lock.  See LOCK reference page.

Btw., this is not the mailing list for usage questions.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Re: docbook problem

От:
eschmid+sic@s.netic.de
Дата:
On Fri, May 25, 2001 at 06:02:47AM +0000, Thomas Lockhart wrote:
> > Is there some trick I missed that would make the dsssl files visible
> > more automatically?
> 
> You can make your own catalog file which points at the other catalog
> files. You still need to set SGML_CATALOG_FILES (to that one
> ubercatalog), or you need to rebuild openjade to know where the correct
> default location is.
> 
> The Mark Gallesi/Cygnus rpms got this right a couple of years ago, but
> the last one or two distros of Mandrake were a bit screwed up.
> Mandrake-8.0 is somewhat better, but not perfect. Not sure how Red Hat
> does on their rpms...

Use a Debian distribution. We used last year Mandrake and there was no way
to build the PHP manual. I have been on there booth and they have told me
that Mandrake is making the manuals with DocBook. But they can't tell me,
where the needed files are hidden in rpms.

BTW: we have this year a booth at the LinuxDays also. It would be great if
some people from the PostgreSQL community can visit our booth.

-Egon 

-- 
LinuxTag, Stuttgart, Germany: July 5-8 2001: http://www.linuxtag.de/
All known books about PHP and related books: http://php.net/books.php 
Concert Band of the University of Hohenheim: http://www.concert-band.de/
First and second bestselling book in German: http://www.php-buch.de/
FAQ