[DOCS] pg_restore -l documentation

2017-08-03 Thread Jeff Janes
The docs for the -l switch in pg_restore say: List the contents of the archive. this is weird, because everywhere else we use "table of contents" to describe this, which makes it seem like just plain 'contents' should mean the bulk table data. Attached patch changes it to say: List the table of

[DOCS] pg_archivecleanup docs

2016-08-05 Thread Jeff Janes
I think the documentation for the -x option is confusing: -x extension When using the program as a standalone utility, provide an extension that will be stripped from all file names before deciding if they should be deleted. This is typically useful for cleaning up archives that have been compres

[DOCS]

2015-12-27 Thread Jeff Janes
According to the documentation: http://www.postgresql.org/docs/9.5/static/datatype-pseudo.html At present the procedural languages all forbid use of a pseudo-type as argument type, and allow only void and record as a result type (plus trigger when the function is used as a trigger). However, pl/

Re: [DOCS] "Alter system" command documentation

2015-06-15 Thread Jeff Janes
On Mon, Jun 15, 2015 at 2:10 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Jun 15, 2015 at 4:58 PM, Euler Taveira > wrote: > >> On 15-06-2015 13:32, Jeff Janes wrote: >> > From http://www.postgresql.org/docs/current/static/sql-altersystem.h

[DOCS] "Alter system" command documentation

2015-06-15 Thread Jeff Janes
Hi, >From http://www.postgresql.org/docs/current/static/sql-altersystem.html "Values set with ALTER SYSTEM will be effective after the next server configuration reload (SIGHUP or pg_ctl reload), or after the next server restart in the case of parameters that can only be changed at server start."

Re: [DOCS] 8.4 doc bug for "Incrementally Updated Backups"

2012-11-27 Thread Jeff Janes
On Mon, Nov 26, 2012 at 12:01 PM, Bruce Momjian wrote: > On Sat, Nov 24, 2012 at 01:56:27PM -0800, Jeff Janes wrote: >> On Fri, Nov 23, 2012 at 5:36 PM, Bruce Momjian wrote: >> > On Fri, Nov 23, 2012 at 04:26:48PM -0800, Jeff Janes wrote: >> >> On Fri, Nov 23,

Re: [DOCS] 8.4 doc bug for "Incrementally Updated Backups"

2012-11-25 Thread Jeff Janes
On Fri, Nov 23, 2012 at 5:36 PM, Bruce Momjian wrote: > On Fri, Nov 23, 2012 at 04:26:48PM -0800, Jeff Janes wrote: >> On Fri, Nov 23, 2012 at 3:42 PM, Bruce Momjian wrote: >> > >> > We don't assume people are reading docs from very old versions. >> > &

Re: [DOCS] 8.4 doc bug for "Incrementally Updated Backups"

2012-11-24 Thread Jeff Janes
On Fri, Nov 23, 2012 at 3:42 PM, Bruce Momjian wrote: > > We don't assume people are reading docs from very old versions. > Even if that is the version they are using? It is, after all, still under maintenance, Cheers, Jeff -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To

[DOCS] 8.4 doc bug for "Incrementally Updated Backups"

2012-11-23 Thread Jeff Janes
Based on Jürgen Fuchsberger's experience described on the general list, I think the following should have been back-patched to 8.4 and 8.3 (assuming it gets a minor update before it EOL) as well, not just 9.0. In particular, in 8.4 chapter 24.4.5 it says "it will be up to you to determine how far

Re: [DOCS] [PERFORM] Planner selects different execution plans depending on limit

2012-09-16 Thread Jeff Janes
On Thu, Sep 13, 2012 at 10:33 AM, Tom Lane wrote: > Bill Martin writes: > >> How can I adjust the statistics target of the index? > > Just pretend it's a table. > > ALTER TABLE index_name ALTER COLUMN column_name SET STATISTICS ... > > You'll need to look at the index (eg with \d) to see

[DOCS] Documentation cross reference from copy to \copy

2012-08-10 Thread Jeff Janes
Where the SQL COPY command warns us not to confuse it with \copy, a link to \copy would be useful. The attached patch implements that, but I'm not sure it does so in the preferred way. Thanks, Jeff copy_crossref_v1.patch Description: Binary data - Sent via pgsql-docs mailing list (pgsql-docs@p