Re: createuser/dropuser username

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Susanne Ebrecht <susanne(at)2ndQuadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>, pgsql-docs(at)postgresql(dot)org
Subject: Re: createuser/dropuser username
Date: 2011-09-07 22:07:03
Message-ID: 7070.1315433223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Uh, I did some digging after this email report and found it does need
> some cleanup, which is done in the attached patch.

> It removes quoting for table references in clusterdb and index/table
> references in reindexdb,

Uh, surely that breaks things. Or did you miss my statement that the
current behavior is what is intended?

> and adds a general documentation overview about
> when case is preserved and suggests quoting, and adds documentation
> where special quoting happens.

I don't find the documentation changes to be improvements either.
Possibly instead of

> ! Specifies the default tablespace for the database (double-quoted internally).

you could do something like

Specifies the default tablespace for the database. (This name
is not subject to case-folding.)

> + <para>
> + When specified on the command line, user and databases names have
> + their case preserved &mdash; the presence of spaces or special
> + characters might require quoting. Table names and other identifiers
> + do not have their case preserved, except where documented, and
> + might require quoting.
> + </para>

This latter sentence is just plain wrong.

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2011-09-08 01:37:28 Re: createuser/dropuser username
Previous Message Bruce Momjian 2011-09-07 21:48:36 Re: createuser/dropuser username