[DOCS] Some more indexterm
Hi all, During a training course last week, a customer told me he found strange that current_user is not available on the documentation's index. I think he's right, so I made this little patch thats adds indexterm tags for current_database, current_schema and current_user. Please apply if you find this interesting. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com Index: doc/src/sgml/func.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/func.sgml,v retrieving revision 1.412 diff -r1.412 func.sgml 10710a10711,10722 > current_database > > > > current_schema > > > > current_user > > > ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [DOCS] Some more indexterm
Please send us a context diff, diff -c. --- Guillaume Lelarge wrote: > Hi all, > > During a training course last week, a customer told me he found strange > that current_user is not available on the documentation's index. I think > he's right, so I made this little patch thats adds indexterm tags for > current_database, current_schema and current_user. > > Please apply if you find this interesting. > > Regards. > > > -- > Guillaume. > http://www.postgresqlfr.org > http://dalibo.com > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[DOCS] small changes to config and vacuum.sgml
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I apologize in advance if the docbook isn't quite right, my docbook installation is wonkey and I couldn't validate. Index: sgml/config.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/config.sgml,v retrieving revision 1.156 diff -c -r1.156 config.sgml *** sgml/config.sgml19 Nov 2007 02:26:10 - 1.156 - - --- sgml/config.sgml28 Nov 2007 00:51:24 - *** *** 961,966 - - --- 961,971 + +See the +command for information on setting this parameter. + + cvs diff: Diffing sgml/ref Index: sgml/ref/vacuum.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/vacuum.sgml,v retrieving revision 1.49 diff -c -r1.49 vacuum.sgml *** sgml/ref/vacuum.sgml7 Oct 2007 01:16:42 - 1.49 - - --- sgml/ref/vacuum.sgml28 Nov 2007 00:51:24 - *** *** 96,102 VERBOSE ! Prints a detailed vacuum activity report for each table. - - --- 96,105 VERBOSE ! Prints a detailed vacuum activity report for each table. Can be used ! to help determine appropriate settings for ! max_fsm_pages, max_fsm_pages, ! and default_statistics_target. - - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ - -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTLvaATb/zqfZUUQRAtR1AJ43b6La72D8DPIWSJ++B4WuiXdhlwCeNEyi NcVnl9FukCqEZimxgDFs/qc= =4vI0 - -END PGP SIGNATURE- -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTLw3ATb/zqfZUUQRAqjbAJ0XgYAV3mXD9GRj5UbVYzOUw5yAngCbBNhq qABPc18aa+UzzdybXNxJv5Q= =0yPj -END PGP SIGNATURE- ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] Some more indexterm
Guillaume Lelarge wrote: > Hi all, > > During a training course last week, a customer told me he found strange > that current_user is not available on the documentation's index. I think > he's right, so I made this little patch thats adds indexterm tags for > current_database, current_schema and current_user. > > Please apply if you find this interesting. I figured out where it goes in the docs. Applied and attached. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: doc/src/sgml/func.sgml === RCS file: /cvsroot/pgsql/doc/src/sgml/func.sgml,v retrieving revision 1.412 diff -c -c -r1.412 func.sgml *** doc/src/sgml/func.sgml 27 Nov 2007 18:29:11 - 1.412 --- doc/src/sgml/func.sgml 28 Nov 2007 05:12:40 - *** *** 10722,10727 --- 10722,10739 current + + current_database + + + + current_schema + + + + current_user + + The session_user is normally the user who initiated the current database connection; but superusers can change this setting ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [DOCS] small changes to config and vacuum.sgml
Patch applied. Thanks. --- Joshua D. Drake wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > - -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello, > > I apologize in advance if the docbook isn't quite right, my docbook > installation is wonkey and I couldn't validate. > > Index: sgml/config.sgml > === > RCS file: /projects/cvsroot/pgsql/doc/src/sgml/config.sgml,v > retrieving revision 1.156 > diff -c -r1.156 config.sgml > *** sgml/config.sgml19 Nov 2007 02:26:10 - 1.156 > - - --- sgml/config.sgml28 Nov 2007 00:51:24 - > *** > *** 961,966 > - - --- 961,971 > > > > + > +See the endterm="sql-vacuum-title"> > +command for information on setting this parameter. > + > + > > > > cvs diff: Diffing sgml/ref > Index: sgml/ref/vacuum.sgml > === > RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/vacuum.sgml,v > retrieving revision 1.49 > diff -c -r1.49 vacuum.sgml > *** sgml/ref/vacuum.sgml7 Oct 2007 01:16:42 - 1.49 > - - --- sgml/ref/vacuum.sgml28 Nov 2007 00:51:24 - > *** > *** 96,102 > VERBOSE > > > ! Prints a detailed vacuum activity report for each table. > > > > - - --- 96,105 > VERBOSE > > > ! Prints a detailed vacuum activity report for each table. Can be > used ! to help determine appropriate settings for > ! max_fsm_pages, > max_fsm_pages, ! and > default_statistics_target. > > > > > - - -- > > === The PostgreSQL Company: Command Prompt, Inc. === > Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 > PostgreSQL solutions since 1997 http://www.commandprompt.com/ > UNIQUE NOT NULL > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate > PostgreSQL Replication: http://www.commandprompt.com/products/ > > - -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.6 (GNU/Linux) > > iD8DBQFHTLvaATb/zqfZUUQRAtR1AJ43b6La72D8DPIWSJ++B4WuiXdhlwCeNEyi > NcVnl9FukCqEZimxgDFs/qc= > =4vI0 > - -END PGP SIGNATURE- > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.6 (GNU/Linux) > > iD8DBQFHTLw3ATb/zqfZUUQRAqjbAJ0XgYAV3mXD9GRj5UbVYzOUw5yAngCbBNhq > qABPc18aa+UzzdybXNxJv5Q= > =0yPj > -END PGP SIGNATURE- > > ---(end of broadcast)--- > TIP 3: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faq -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: doc/src/sgml/config.sgml === RCS file: /cvsroot/pgsql/doc/src/sgml/config.sgml,v retrieving revision 1.156 diff -c -c -r1.156 config.sgml *** doc/src/sgml/config.sgml 19 Nov 2007 02:26:10 - 1.156 --- doc/src/sgml/config.sgml 28 Nov 2007 05:00:15 - *** *** 962,968 --- 962,977 + + + +See the +command for information on setting this parameter. + + + + Kernel Resource Usage Index: doc/src/sgml/ref/vacuum.sgml === RCS file: /cvsroot/pgsql/doc/src/sgml/ref/vacuum.sgml,v retrieving revision 1.49 diff -c -c -r1.49 vacuum.sgml *** doc/src/sgml/ref/vacuum.sgml 7 Oct 2007 01:16:42 - 1.49 --- doc/src/sgml/ref/vacuum.sgml 28 Nov 2007 05:00:15 - *** *** 96,102 VERBOSE ! Prints a detailed vacuum activity report for each table. --- 96,105 VERBOSE ! Prints a detailed vacuum activity report for each table. Can be used ! to help determine appropriate settings for ! max_fsm_pages, max_fsm_pages, ! and default_statistics_target. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [DOCS] Some more indexterm
Bruce Momjian a écrit : > Please send us a context diff, diff -c. > Sorry, I thought a "cvs diff" was enough. Is there a way to get a context diff with "cvs diff" command ? Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] Some more indexterm
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 28 Nov 2007 08:02:45 +0100 Guillaume Lelarge <[EMAIL PROTECTED]> wrote: > Bruce Momjian a écrit : > > Please send us a context diff, diff -c. > > > > Sorry, I thought a "cvs diff" was enough. Is there a way to get a > context diff with "cvs diff" command ? cvs diff -c > > Regards. > > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTRNVATb/zqfZUUQRArBMAJ4sfX6x9/dL6lvsoOq90WN7ycM4ZwCdEYOc 0xXOoI/C1ajRqXbDUCXYUjQ= =nV8w -END PGP SIGNATURE- ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [DOCS] Some more indexterm
Joshua D. Drake a écrit : > On Wed, 28 Nov 2007 08:02:45 +0100 > Guillaume Lelarge <[EMAIL PROTECTED]> wrote: > >> Bruce Momjian a écrit : >>> Please send us a context diff, diff -c. >>> >> Sorry, I thought a "cvs diff" was enough. Is there a way to get a >> context diff with "cvs diff" command ? > > cvs diff -c > Thanks, I put this on my .cvsrc and I can now send a new documentation patch. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com ---(end of broadcast)--- TIP 6: explain analyze is your friend
[DOCS] Two fixes for plpgsql.sgml
Hi, This patch fixes two issues on plpgsql.sgml. Please review them carefully, at least the second one. Thanks. Regards. PS : this patch should be in context diff if my .cvsrc is correctly set up... at least, it doesn't look like my previous patch :) -- Guillaume. http://www.postgresqlfr.org http://dalibo.com Index: doc/src/sgml/plpgsql.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plpgsql.sgml,v retrieving revision 1.117 diff -c -r1.117 plpgsql.sgml *** doc/src/sgml/plpgsql.sgml 26 Oct 2007 01:11:09 - 1.117 --- doc/src/sgml/plpgsql.sgml 28 Nov 2007 07:11:58 - *** *** 133,139 PL/pgSQL functions can also be declared to return ! a set, or table, of any data type they can return a single instance of. Such a function generates its output by executing RETURN NEXT for each desired element of the result set, or by using RETURN QUERY to output the result of --- 133,139 PL/pgSQL functions can also be declared to return ! a set, or table, or any data type they can return a single instance of. Such a function generates its output by executing RETURN NEXT for each desired element of the result set, or by using RETURN QUERY to output the result of *** *** 1428,1434 WHERE fooid > 0 LOOP -- can do some processing here ! RETURN NEXT r; -- return next row of SELECT END LOOP; RETURN; END --- 1428,1434 WHERE fooid > 0 LOOP -- can do some processing here ! RETURN NEXT r; -- return current row of SELECT END LOOP; RETURN; END ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
