Re: [DOCS] description of CHECKPOINT command confusing

2011-10-11 Thread Fujii Masao
On Wed, Oct 12, 2011 at 12:02 PM, Josh Kupershmidt wrote: > Basically, I think the page should be structured to emphasize >  1.) what is a "checkpoint" to a user who is not familiar with the term, and >  2.) why would a user want to use the CHECKPOINT command? > > To tackle 1.), I think a little b

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Tom Lane
Robert Haas writes: > On Tue, Oct 11, 2011 at 11:59 AM, Tom Lane wrote: >> I think removing them from the docs but continuing to accept them makes >> sense.  We do still hear from people migrating from 7.4 or older, and >> it's not always going to be practical for them to make a dump with a >> ne

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Robert Haas
On Tue, Oct 11, 2011 at 11:59 AM, Tom Lane wrote: > Bruce Momjian writes: >> Robert Haas wrote: >>> On Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian wrote: Robert Haas wrote: > I wonder if we ought to consider removing CREATEUSER and NOCREATEUSER > as synonyms for SUPERUSER and NOSUP

[DOCS] description of CHECKPOINT command confusing

2011-10-11 Thread Josh Kupershmidt
Hi all, I think that the page about the CHECKPOINT command: http://www.postgresql.org/docs/current/static/sql-checkpoint.html could really use some work. The page is quite obtuse if you don't already understand what a checkpoint is. The first sentence goes: | Write-Ahead Logging (WAL) puts a

Re: [DOCS] lo_manage trigger on updates

2011-10-11 Thread Josh Kupershmidt
On Mon, Oct 10, 2011 at 1:18 PM, Robert Haas wrote: > On Thu, Aug 11, 2011 at 11:43 PM, Josh Kupershmidt wrote: >> I think the doc section about using lo_manage() as a trigger: >>   http://www.postgresql.org/docs/current/static/lo.html >> >> could have its example tweaked to use a column-level BE

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Tom Lane
Bruce Momjian writes: > Robert Haas wrote: >> On Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian wrote: >>> Robert Haas wrote: I wonder if we ought to consider removing CREATEUSER and NOCREATEUSER as synonyms for SUPERUSER and NOSUPERUSER. ?It looks like that change was made in 8.1, w

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Bruce Momjian
Robert Haas wrote: > On Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian wrote: > > Robert Haas wrote: > >> On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams > >> wrote: > >> > The help for LOGIN/NOLOGIN at > >> > http://www.postgresql.org/docs/9.1/static/sql-createrole.html: > >> > "...NOLOGIN > >> > is

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Robert Haas
On Tue, Oct 11, 2011 at 10:44 AM, Bruce Momjian wrote: > Robert Haas wrote: >> On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams >> wrote: >> > The help for LOGIN/NOLOGIN at >> > http://www.postgresql.org/docs/9.1/static/sql-createrole.html: "...NOLOGIN >> > is the default, except when CREATE ROLE is i

Re: [DOCS] Discrepancy in 9.1 Documentation on CREATE ROLE

2011-10-11 Thread Bruce Momjian
Robert Haas wrote: > On Thu, Oct 6, 2011 at 10:48 PM, Ron Adams > wrote: > > The help for LOGIN/NOLOGIN at > > http://www.postgresql.org/docs/9.1/static/sql-createrole.html: "...NOLOGIN > > is the default, except when CREATE ROLE is invoked through its alternative > > spelling CREATE USER." The h