To: Bruce Momjian <bruce@momjian.us>
cc: Susanne Ebrecht <susanne@2ndQuadrant.com>,
	Robert Haas <robertmhaas@gmail.com>,
	Grzegorz Szpetkowski <gszpetkowski@gmail.com>, pgsql-docs@postgresql.org
Subject: Re: createuser/dropuser username 
In-reply-to: <201109080137.p881bSj10401@momjian.us> 
References: <201109080137.p881bSj10401@momjian.us>
Comments: In-reply-to Bruce Momjian <bruce@momjian.us>
	message dated "Wed, 07 Sep 2011 21:37:28 -0400"
Date: Thu, 08 Sep 2011 10:40:31 -0400
Message-ID: <22065.1315492831@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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.

> 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.

			regards, tom lane