Thread: Documentation
When attempting to generate a pdf of the programmer documentation, I get the following nondescript error: $ make programmer.pdf openjade -D . -D ./ref -c /sw/share/sgml/docbook-dsssl-1.78//catalog -d stylesheet.dsl -t tex -V tex-backend -i output-print -V texpdf-output -o programmer.tex-pdf book-decl.sgml programmer.sgml make: *** [programmer.tex-pdf] Segmentation fault make: *** Deleting file `programmer.tex-pdf' After it has chugged for a while. Any help would be appreciated. I'm using Mac OS X 10.2, with most of the docbook stuff installed by fink. Jeffrey Melloy jmelloy@visualdistortion.org
On Fri, 2003-04-18 at 04:48, Jeffrey Melloy wrote: > When attempting to generate a pdf of the programmer documentation, I > get the following nondescript error: > $ make programmer.pdf > openjade -D . -D ./ref -c /sw/share/sgml/docbook-dsssl-1.78//catalog > -d stylesheet.dsl -t tex -V tex-backend -i output-print -V > texpdf-output -o programmer.tex-pdf book-decl.sgml programmer.sgml > make: *** [programmer.tex-pdf] Segmentation fault > make: *** Deleting file `programmer.tex-pdf' My guess would be you've run into a bug with your OpenJade setup. In any case, the PDF docs for 7.3 are now available online: http://www.postgresql.org/docs/ Cheers, Neil
On Sun, 2003-04-20 at 22:01, Neil Conway wrote: > My guess would be you've run into a bug with your OpenJade setup. In any > case, the PDF docs for 7.3 are now available online: > > http://www.postgresql.org/docs/ That's good, but is anyone able to supply A4 versions? (I can't, because I hit that same bug with both jade and openjade.) -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "The sacrifices of God are a broken spirit; a broken and a contrite heart, O God, thou wilt not despise." Psalms 51:17
Oliver Elphick wrote: > On Sun, 2003-04-20 at 22:01, Neil Conway wrote: > >>My guess would be you've run into a bug with your OpenJade setup. In any >>case, the PDF docs for 7.3 are now available online: >> >>http://www.postgresql.org/docs/ > > > That's good, but is anyone able to supply A4 versions? (I can't, > because I hit that same bug with both jade and openjade.) > How does one produce an A4 version? I'll gladly recreate the pdf's in A4 format (if I knew how without a lot of research). Joe
On Mon, 2003-04-21 at 19:01, Joe Conway wrote: > How does one produce an A4 version? I'll gladly recreate the pdf's in A4 > format (if I knew how without a lot of research). I think it is defined for your sgml installation. I have in /etc/sgml/docbook-dsssl/print/siteconfig.dsl: (define %paper-type% "A4") ;; set by debconf -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "The sacrifices of God are a broken spirit; a broken and a contrite heart, O God, thou wilt not despise." Psalms 51:17
Oliver Elphick wrote: > On Mon, 2003-04-21 at 19:01, Joe Conway wrote: > >>How does one produce an A4 version? I'll gladly recreate the pdf's in A4 >>format (if I knew how without a lot of research). > > I think it is defined for your sgml installation. I have in > /etc/sgml/docbook-dsssl/print/siteconfig.dsl: > > (define %paper-type% "A4") ;; set by debconf > > On my RH 8 box I didn't find that file, but did find the setting in /usr/share/sgml/docbook/dsssl-stylesheets/print/dbparam.dsl and changed it to "A4" (was "USletter"). Unfortunately that didn't seem to make any difference -- the pdfs built were still USletter. There is probably a more preferred method, but I then modified doc/src/sgml/stylesheet.dsl directly, adding (define %paper-type% "A4") and that seemed to work. The resulting pdfs are available here: http://www.joeconway.com/ Let me know how they look. HTH, Joe
On Tue, 2003-04-22 at 01:48, Joe Conway wrote: > Oliver Elphick wrote: > > On Mon, 2003-04-21 at 19:01, Joe Conway wrote: > > > >>How does one produce an A4 version? I'll gladly recreate the pdf's in A4 > >>format (if I knew how without a lot of research). > > > > I think it is defined for your sgml installation. I have in > > /etc/sgml/docbook-dsssl/print/siteconfig.dsl: > > > > (define %paper-type% "A4") ;; set by debconf > > > > > > On my RH 8 box I didn't find that file, but did find the setting in > /usr/share/sgml/docbook/dsssl-stylesheets/print/dbparam.dsl and changed > it to "A4" (was "USletter"). Unfortunately that didn't seem to make any > difference -- the pdfs built were still USletter. > > There is probably a more preferred method, but I then modified > doc/src/sgml/stylesheet.dsl directly, adding > (define %paper-type% "A4") > and that seemed to work. The resulting pdfs are available here: > http://www.joeconway.com/ > > Let me know how they look. They seem fine, except that the page numbers disappear if I print from acroread without specifying "Fit to page". That may be because they fall into my printer's untouchable space. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "If my people, which are called by my name, shall humble themselves, and pray, and seek my face, and turn from their wicked ways; then will I hear from heaven, and will forgive their sin, and will heal their land." II Chronicles 7:14
Oliver Elphick wrote: > On Tue, 2003-04-22 at 01:48, Joe Conway wrote: >>Let me know how they look. > > They seem fine, except that the page numbers disappear if I print from > acroread without specifying "Fit to page". That may be because they > fall into my printer's untouchable space. > Do you want me to try anything other settings? Joe
Is there a simple way or ready built script to view the EXPLAIN output of a query *and* the EXPLAIN output of the triggers that will be executed due to the initial statement? I have a few comlpex database schemas and I apply referential integrity constraints throughout. Some delete statements have become excruciatingly slow - I suspect this is due to some of the queries being executed by triggers created by my referential integrity constraints that currently use sequential scans where an index scan would be more appropriate. If I could see the explain output of all of this is would save a lot of time narrowing things down. If no one knows how to do this / or it hasn't been done yet, maybe I'll hack this together. Thanks! -r -- Ryan Mahoney <ryan@paymentalliance.net>
On Tue, 2003-04-22 at 17:55, Joe Conway wrote: > Oliver Elphick wrote: > > On Tue, 2003-04-22 at 01:48, Joe Conway wrote: > >>Let me know how they look. > > > > They seem fine, except that the page numbers disappear if I print from > > acroread without specifying "Fit to page". That may be because they > > fall into my printer's untouchable space. > > > > Do you want me to try anything other settings? I should leave it. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "If my people, which are called by my name, shall humble themselves, and pray, and seek my face, and turn from their wicked ways; then will I hear from heaven, and will forgive their sin, and will heal their land." II Chronicles 7:14