Re: createuser/dropuser username

Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Tom Lane wrote:
> >> Bruce Momjian <bruce(at)momjian(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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