Re: [DOCS] [GENERAL] [pgsql-advocacy] Documentation quality WAS: interesting
> Agreed. I am starting a list of what can/need to be indexed on pgsql docs > site as I'm working to build a new site with pgsql as a backend. I > think Tom Lane > suggested that.. I would like to know where I can send > the list. It'll probably somekind of a work in progress. So if everyone > else can contribute, > it'll be so much faster. Probably a semi-automated > system for handling those > lists? Assuming some kind of full-text search facility, an interesting idea would be a self-updating index, one that keeps track of what search terms are commonly used and adds those to the index automatically. -- Mike Nolan ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] [PATCHES] Synopsis inconsistencies
Patch applied. Thanks. --- Rod Taylor wrote: -- Start of PGP signed section. > Most of the synopsis areas for DROP commands use "name" as the > identifier, while some areas do not. > > The attached converts be below to "name": > conversion_name > index_name > > > The below have an existing, initdb supplied, entity named "name". As > such, it could be confusing for the reader to see that identifier used > in the example. > > domainname > typename > > Perhaps we should be going the otherway and converting the other uses of > "name" into "group_name", "user_name", "function_name", etc. > > -- > Rod Taylor <[EMAIL PROTECTED]> > > PGP Key: http://www.rbt.ca/rbtpub.asc [ Attachment, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[DOCS] Current CVS docs producing errors
When building postgres.tar.gz I get the following errors:
make -C sgml clean
make[1]: Entering directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
rm -f HTML.manifest *.html *.gif
rm -rf *.1 *.l man1 manl manpage.refs manpage.links manpage.log
rm -f *.rtf *.tex-ps *.tex-pdf *.dvi *.aux *.log *.ps *.pdf *.out *.eps *.fot
rm -f HTML.index bookindex.sgml version.sgml features-supported.sgml
features-unsupported.sgml
make[1]: Leaving directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
make -C sgml html
make[1]: Entering directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
/usr/bin/perl /usr/local/share/sgml/stylesheets/docbook/bin/collateindex.pl -f -g -o
bookindex.sgml -N
{ \
echo ""; \
echo ""; \
} >version.sgml
/usr/bin/perl ./mk_feature_tables.pl YES
../../../src/backend/catalog/sql_feature_packages.txt
../../../src/backend/catalog/sql_features.txt > features-supported.sgml
/usr/bin/perl ./mk_feature_tables.pl NO
../../../src/backend/catalog/sql_feature_packages.txt
../../../src/backend/catalog/sql_features.txt > features-unsupported.sgml
openjade -V draft-mode -D . -c /usr/local/share/sgml/stylesheets/docbook/catalog -d
stylesheet.dsl -i output-html -t sgml postgres.sgml
openjade:datatype.sgml:2611:12:E: document type does not allow element "ROW" here
openjade:datatype.sgml:2616:12:E: document type does not allow element "ROW" here
openjade:datatype.sgml:2621:5:E: document type does not allow element "ROW" here
openjade:datatype.sgml:2625:5:E: document type does not allow element "ROW" here
openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
specified
openjade:datatype.sgml:2625:1: start tag was here
openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
specified
openjade:datatype.sgml:2621:1: start tag was here
openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
specified
openjade:datatype.sgml:2607:1: start tag was here
openjade:perform.sgml:69:19:X: reference to non-existent ID "RUNTIME-CONFIG-OPTIMIZER"
openjade:/usr/local/share/sgml/stylesheets/docbook/html/../common/dbtable.dsl:224:13:E:
2nd argument for primitive "ancestor" of wrong type: "#"
not a singleton node list
openjade:/usr/local/share/sgml/stylesheets/docbook/html/dblink.dsl:203:1:E: XRef
LinkEnd to missing ID 'RUNTIME-CONFIG-OPTIMIZER'
make[1]: *** [html] Error 1
make[1]: Leaving directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
make: *** [postgres.tar] Error 2
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Re: [DOCS] Current CVS docs producing errors
Seems you were caught in mid patch.
They work with cvs sources from 30 minutes ago.
Try updating and re-running -- the last error in particular was caused
by 2 patches crossing in the night (patch queue).
On Tue, 2003-06-24 at 22:52, Bruno Wolff III wrote:
> When building postgres.tar.gz I get the following errors:
>
> make -C sgml clean
> make[1]: Entering directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> rm -f HTML.manifest *.html *.gif
> rm -rf *.1 *.l man1 manl manpage.refs manpage.links manpage.log
> rm -f *.rtf *.tex-ps *.tex-pdf *.dvi *.aux *.log *.ps *.pdf *.out *.eps *.fot
> rm -f HTML.index bookindex.sgml version.sgml features-supported.sgml
> features-unsupported.sgml
> make[1]: Leaving directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> make -C sgml html
> make[1]: Entering directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> /usr/bin/perl /usr/local/share/sgml/stylesheets/docbook/bin/collateindex.pl -f -g -o
> bookindex.sgml -N
> { \
> echo ""; \
> echo " '\([0-9][0-9]*\.[0-9][0-9]*\)'`\">"; \
> } >version.sgml
> /usr/bin/perl ./mk_feature_tables.pl YES
> ../../../src/backend/catalog/sql_feature_packages.txt
> ../../../src/backend/catalog/sql_features.txt > features-supported.sgml
> /usr/bin/perl ./mk_feature_tables.pl NO
> ../../../src/backend/catalog/sql_feature_packages.txt
> ../../../src/backend/catalog/sql_features.txt > features-unsupported.sgml
> openjade -V draft-mode -D . -c /usr/local/share/sgml/stylesheets/docbook/catalog -d
> stylesheet.dsl -i output-html -t sgml postgres.sgml
> openjade:datatype.sgml:2611:12:E: document type does not allow element "ROW" here
> openjade:datatype.sgml:2616:12:E: document type does not allow element "ROW" here
> openjade:datatype.sgml:2621:5:E: document type does not allow element "ROW" here
> openjade:datatype.sgml:2625:5:E: document type does not allow element "ROW" here
> openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> specified
> openjade:datatype.sgml:2625:1: start tag was here
> openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> specified
> openjade:datatype.sgml:2621:1: start tag was here
> openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> specified
> openjade:datatype.sgml:2607:1: start tag was here
> openjade:perform.sgml:69:19:X: reference to non-existent ID
> "RUNTIME-CONFIG-OPTIMIZER"
> openjade:/usr/local/share/sgml/stylesheets/docbook/html/../common/dbtable.dsl:224:13:E:
> 2nd argument for primitive "ancestor" of wrong type: "#"
> not a singleton node list
> openjade:/usr/local/share/sgml/stylesheets/docbook/html/dblink.dsl:203:1:E: XRef
> LinkEnd to missing ID 'RUNTIME-CONFIG-OPTIMIZER'
> make[1]: *** [html] Error 1
> make[1]: Leaving directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> make: *** [postgres.tar] Error 2
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
--
Rod Taylor <[EMAIL PROTECTED]>
PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part
Re: [DOCS] Current CVS docs producing errors
It works here and in the 15 minute build in the developers site.
---
Bruno Wolff III wrote:
> When building postgres.tar.gz I get the following errors:
>
> make -C sgml clean
> make[1]: Entering directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> rm -f HTML.manifest *.html *.gif
> rm -rf *.1 *.l man1 manl manpage.refs manpage.links manpage.log
> rm -f *.rtf *.tex-ps *.tex-pdf *.dvi *.aux *.log *.ps *.pdf *.out *.eps *.fot
> rm -f HTML.index bookindex.sgml version.sgml features-supported.sgml
> features-unsupported.sgml
> make[1]: Leaving directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> make -C sgml html
> make[1]: Entering directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> /usr/bin/perl /usr/local/share/sgml/stylesheets/docbook/bin/collateindex.pl -f -g -o
> bookindex.sgml -N
> { \
> echo ""; \
> echo " '\([0-9][0-9]*\.[0-9][0-9]*\)'`\">"; \
> } >version.sgml
> /usr/bin/perl ./mk_feature_tables.pl YES
> ../../../src/backend/catalog/sql_feature_packages.txt
> ../../../src/backend/catalog/sql_features.txt > features-supported.sgml
> /usr/bin/perl ./mk_feature_tables.pl NO
> ../../../src/backend/catalog/sql_feature_packages.txt
> ../../../src/backend/catalog/sql_features.txt > features-unsupported.sgml
> openjade -V draft-mode -D . -c /usr/local/share/sgml/stylesheets/docbook/catalog -d
> stylesheet.dsl -i output-html -t sgml postgres.sgml
> openjade:datatype.sgml:2611:12:E: document type does not allow element "ROW" here
> openjade:datatype.sgml:2616:12:E: document type does not allow element "ROW" here
> openjade:datatype.sgml:2621:5:E: document type does not allow element "ROW" here
> openjade:datatype.sgml:2625:5:E: document type does not allow element "ROW" here
> openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> specified
> openjade:datatype.sgml:2625:1: start tag was here
> openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> specified
> openjade:datatype.sgml:2621:1: start tag was here
> openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> specified
> openjade:datatype.sgml:2607:1: start tag was here
> openjade:perform.sgml:69:19:X: reference to non-existent ID
> "RUNTIME-CONFIG-OPTIMIZER"
> openjade:/usr/local/share/sgml/stylesheets/docbook/html/../common/dbtable.dsl:224:13:E:
> 2nd argument for primitive "ancestor" of wrong type: "#"
> not a singleton node list
> openjade:/usr/local/share/sgml/stylesheets/docbook/html/dblink.dsl:203:1:E: XRef
> LinkEnd to missing ID 'RUNTIME-CONFIG-OPTIMIZER'
> make[1]: *** [html] Error 1
> make[1]: Leaving directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> make: *** [postgres.tar] Error 2
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Square, Pennsylvania 19073
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [DOCS] Current CVS docs producing errors
On Tue, Jun 24, 2003 at 22:52:32 -0400,
Rod Taylor <[EMAIL PROTECTED]> wrote:
> Seems you were caught in mid patch.
>
> They work with cvs sources from 30 minutes ago.
>
> Try updating and re-running -- the last error in particular was caused
> by 2 patches crossing in the night (patch queue).
I resynced and picked up a new perform.sgml and TODO.sgml. This got rid
of one of the errors. I am still seeing all of the datatype.sgml errors.
I wasn't getting these errors a couple of days ago.
>
> On Tue, 2003-06-24 at 22:52, Bruno Wolff III wrote:
> > When building postgres.tar.gz I get the following errors:
> >
> > make -C sgml clean
> > make[1]: Entering directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> > rm -f HTML.manifest *.html *.gif
> > rm -rf *.1 *.l man1 manl manpage.refs manpage.links manpage.log
> > rm -f *.rtf *.tex-ps *.tex-pdf *.dvi *.aux *.log *.ps *.pdf *.out *.eps *.fot
> > rm -f HTML.index bookindex.sgml version.sgml features-supported.sgml
> > features-unsupported.sgml
> > make[1]: Leaving directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> > make -C sgml html
> > make[1]: Entering directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> > /usr/bin/perl /usr/local/share/sgml/stylesheets/docbook/bin/collateindex.pl -f -g
> > -o bookindex.sgml -N
> > { \
> > echo ""; \
> > echo " > '\([0-9][0-9]*\.[0-9][0-9]*\)'`\">"; \
> > } >version.sgml
> > /usr/bin/perl ./mk_feature_tables.pl YES
> > ../../../src/backend/catalog/sql_feature_packages.txt
> > ../../../src/backend/catalog/sql_features.txt > features-supported.sgml
> > /usr/bin/perl ./mk_feature_tables.pl NO
> > ../../../src/backend/catalog/sql_feature_packages.txt
> > ../../../src/backend/catalog/sql_features.txt > features-unsupported.sgml
> > openjade -V draft-mode -D . -c /usr/local/share/sgml/stylesheets/docbook/catalog
> > -d stylesheet.dsl -i output-html -t sgml postgres.sgml
> > openjade:datatype.sgml:2611:12:E: document type does not allow element "ROW" here
> > openjade:datatype.sgml:2616:12:E: document type does not allow element "ROW" here
> > openjade:datatype.sgml:2621:5:E: document type does not allow element "ROW" here
> > openjade:datatype.sgml:2625:5:E: document type does not allow element "ROW" here
> > openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> > specified
> > openjade:datatype.sgml:2625:1: start tag was here
> > openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> > specified
> > openjade:datatype.sgml:2621:1: start tag was here
> > openjade:datatype.sgml:2629:14:E: end tag for "ROW" omitted, but OMITTAG NO was
> > specified
> > openjade:datatype.sgml:2607:1: start tag was here
> > openjade:perform.sgml:69:19:X: reference to non-existent ID
> > "RUNTIME-CONFIG-OPTIMIZER"
> > openjade:/usr/local/share/sgml/stylesheets/docbook/html/../common/dbtable.dsl:224:13:E:
> > 2nd argument for primitive "ancestor" of wrong type: "# > 145061872>" not a singleton node list
> > openjade:/usr/local/share/sgml/stylesheets/docbook/html/dblink.dsl:203:1:E: XRef
> > LinkEnd to missing ID 'RUNTIME-CONFIG-OPTIMIZER'
> > make[1]: *** [html] Error 1
> > make[1]: Leaving directory `/usr/local/src/postgresql-7.4/pgsql/doc/src/sgml'
> > make: *** [postgres.tar] Error 2
> >
> > ---(end of broadcast)---
> > TIP 5: Have you checked our extensive FAQ?
> >
> >http://www.postgresql.org/docs/faqs/FAQ.html
> --
> Rod Taylor <[EMAIL PROTECTED]>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [DOCS] Current CVS docs producing errors
On Tue, 2003-06-24 at 23:18, Bruno Wolff III wrote: > On Tue, Jun 24, 2003 at 22:52:32 -0400, > Rod Taylor <[EMAIL PROTECTED]> wrote: > > Seems you were caught in mid patch. > > > > They work with cvs sources from 30 minutes ago. > > > > Try updating and re-running -- the last error in particular was caused > > by 2 patches crossing in the night (patch queue). > > I resynced and picked up a new perform.sgml and TODO.sgml. This got rid > of one of the errors. I am still seeing all of the datatype.sgml errors. > I wasn't getting these errors a couple of days ago. Are you sure you don't have local changes? A conflict perhaps? Try removing datatype.sgml and re-fetching it again. Below is the only change to that file in a number of days, and it looks fine to me. http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/datatype.sgml.diff?r1=1.117&r2=1.118 -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc signature.asc Description: This is a digitally signed message part
Re: [DOCS] Current CVS docs producing errors
On Tue, Jun 24, 2003 at 23:20:52 -0400, Rod Taylor <[EMAIL PROTECTED]> wrote: > > Are you sure you don't have local changes? A conflict perhaps? I had wiped what I had tonight to get a clean copy from CVS as I had been testing a patch to fix some problems with sockaddr and wanted to see if things worked from CVS now. I am not using any local patches. I am running a recent version of openjade (1.3.3-pre1), but it worked for me last week. > > Try removing datatype.sgml and re-fetching it again. I just tried that and it didn't help. > > Below is the only change to that file in a number of days, and it looks > fine to me. > > http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/datatype.sgml.diff?r1=1.117&r2=1.118 I looked at this and while I don't know SGML I expect that the complaints are referring to some unclosed entries that were added in that change. They are in the last section of the differences (after line 2604). > -- > Rod Taylor <[EMAIL PROTECTED]> > > PGP Key: http://www.rbt.ca/rbtpub.asc ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [DOCS] Current CVS docs producing errors
On Tue, Jun 24, 2003 at 22:38:50 -0500, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > I looked at this and while I don't know SGML I expect that the complaints > are referring to some unclosed entries that were added in that change. > They are in the last section of the differences (after line 2604). I am testing with some s thrown in now and things seem to be working. I will send a diff shortly that you can look at. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [DOCS] Current CVS docs producing errors
Found them --- patch applied. --- Bruno Wolff III wrote: > On Tue, Jun 24, 2003 at 22:38:50 -0500, > Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > > > I looked at this and while I don't know SGML I expect that the complaints > > are referring to some unclosed entries that were added in that change. > > They are in the last section of the differences (after line 2604). > > I am testing with some s thrown in now and things seem to be working. > I will send a diff shortly that you can look at. > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: doc/src/sgml/datatype.sgml === RCS file: /cvsroot/pgsql-server/doc/src/sgml/datatype.sgml,v retrieving revision 1.118 diff -c -c -r1.118 datatype.sgml *** doc/src/sgml/datatype.sgml 24 Jun 2003 22:21:21 - 1.118 --- doc/src/sgml/datatype.sgml 25 Jun 2003 03:50:14 - *** *** 2608,2613 --- 2608,2614 10.1.2.3/32 10.1.2.3/32 10.1.2.3/32 + 2001:4f8:3:ba::/64 2001:4f8:3:ba::/64 *** *** 2622,2631 --- 2623,2634 :::1.2.3.0/120 :::1.2.3.0/120 :::1.2.3/120 + :::1.2.3.0/128 :::1.2.3.0/128 :::1.2.3.0/128 + ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [DOCS] Current CVS docs producing errors
These changes fixed the problem I was having. *** datatype.sgml.orig Tue Jun 24 22:41:31 2003 --- datatype.sgml Tue Jun 24 22:42:44 2003 *** *** 2608,2613 --- 2608,2614 10.1.2.3/32 10.1.2.3/32 10.1.2.3/32 + 2001:4f8:3:ba::/64 2001:4f8:3:ba::/64 *** *** 2622,2631 --- 2623,2634 :::1.2.3.0/120 :::1.2.3.0/120 :::1.2.3/120 + :::1.2.3.0/128 :::1.2.3.0/128 :::1.2.3.0/128 + ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [DOCS] Current CVS docs producing errors
On Tue, Jun 24, 2003 at 23:51:02 -0400, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Found them --- patch applied. Thanks. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
