Hi all
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 postgresql 7.3?
Great thanks for any message
Josh.





Hi all
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 postgresql 7.3?Great thanks for any 
messageJosh.
Fri, 20 Dec 2002 10:1:58 +0800
postgresql <postgresql@db.pku.edu.cn>
alter user problem
You need to go:

ALTER USER "EDU" WITH PASSWORD 'aaaa';

Since you have used an uppercase name, you will always need to double quote
it.

Chris
  -----Original Message-----
  From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of postgresql
  Sent: Friday, 20 December 2002 10:01 AM
  To: pgsql-hackers@postgresql.org
  Subject: [HACKERS] alter user problem


  Hi all

  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
postgresql 7.3?
  Great thanks for any message
  Josh.






You 
need to go:
 
ALTER 
USER "EDU" WITH PASSWORD 'aaaa';
 
Since 
you have used an uppercase name, you will always need to double quote 
it.
 
Chris

-----Original Message-----From: 
  pgsql-hackers-owner@postgresql.org 
  [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of 
  postgresqlSent: Friday, 20 December 2002 10:01 AMTo: 
  pgsql-hackers@postgresql.orgSubject: [HACKERS] alter user 
  problem
Hi all
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 postgresql 7.3?Great thanks for any 
  messageJosh.
Fri, 20 Dec 2002 10:30:15 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: alter user problem