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

Re: Bug #591: Postgres apparently not identifying users created in Caps

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rmendez(at)sheertalent(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #591: Postgres apparently not identifying users created in Caps
Date: 2002-02-16 18:47:43
Message-ID: 20591.1013885263@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
> alter user Test with password 'testpwd';

You need double quotes.

	alter user "Test" with password 'testpwd';

You may care to read the section of the user's guide that discusses
case insensitivity of identifiers in SQL.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Eugene PervagoDate: 2002-02-17 21:45:34
Subject: crash on cash_words('21,474,836.48'::money)
Previous:From: pgsql-bugsDate: 2002-02-16 18:22:06
Subject: Bug #591: Postgres apparently not identifying users created in Caps

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