Skip site navigation (1) Skip section navigation (2)

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-08 14:40:31
Message-ID: 22065.1315492831@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-docs
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.

> 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

In response to

Responses

pgsql-docs by date

Next:From: Bruce MomjianDate: 2011-09-08 14:52:04
Subject: Re: createuser/dropuser username
Previous:From: Bruce MomjianDate: 2011-09-08 13:14:26
Subject: Re: createuser/dropuser username

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group