You need to go:
ALTER USER "EDU" WITH PASSWORD 'aaaa';
Since you have used an uppercase name, you will always need to double quote
[mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of postgresql
Sent: Friday, 20 December 2002 10:01 AM
Subject: [HACKERS] alter user problem
I have install Postgresql 7.3 with user name EDU.
then I enter the psql to change the password for EDU using "alter user EDU
with password 'aaaa''
it returns " user EDU do not exist".
I check the system table pg_user, and the user 'EDU' actually exists.
But if I take the following SQL, it works
"create user TEST'
"Alter user TEST with password 'dddd';
I check the pg_user again, and find the user "TEST' is replace by 'test'.
So I have a question:
How I change the password for the initial user "EDU", or is it a bug for
Great thanks for any message
In response to
pgsql-hackers by date
|Next:||From: Hiroshi Inoue||Date: 2002-12-20 04:21:59|
|Subject: Re: About server side prepare|
|Previous:||From: Dave Cramer||Date: 2002-12-20 02:11:05|
|Subject: Re: error when using move, any suggestions?|