Re: createuser/dropuser username - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: createuser/dropuser username
Date
Msg-id 201109081452.p88Eq4b02307@momjian.us
Whole thread Raw
In response to Re: createuser/dropuser username  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: createuser/dropuser username
List pgsql-docs
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Tom Lane wrote:
> >> Bruce Momjian <bruce@momjian.us> writes:
> >>> 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?
>
> > I saw that, but how is that consistent with other command-line tools?
> > What is the logic that has some tools preserve case and others not?
>
> If there are any that fail to preserve case, those are the ones to be
> fixed.  Making the working ones match the broken ones is not the correct
> direction.

I started going in that direction and stopped because of this example
in our docs:

        vacuumdb --analyze --verbose --table 'foo(bar)' xyzzy

Ideas?

>
> > Really?  Pg_dump doesn't preserve case for table names:
>
> >     pg_dump -t Test test
>
> pg_dump is a special case because the arguments are patterns to match,
> not fixed names.

OK.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: createuser/dropuser username
Next
From: Alvaro Herrera
Date:
Subject: Re: createuser/dropuser username