Thread: Documentation

Documentation

From
Jeffrey Melloy
Date:
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


Re: Documentation

From
Neil Conway
Date:
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


Re: Documentation

From
Oliver Elphick
Date:
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


Re: Documentation

From
Joe Conway
Date:
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


Re: Documentation

From
Oliver Elphick
Date:
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


Re: Documentation

From
Joe Conway
Date:
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


Re: Documentation

From
Oliver Elphick
Date:
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


Re: Documentation

From
Joe Conway
Date:
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


explain triggers

From
Ryan Mahoney
Date:
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>


Re: Documentation

From
Oliver Elphick
Date:
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