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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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