Thread: alter user problem

alter user problem

From

postgresql

Date:

20 December 2002, 00:06:23

<p>Hi all<p>I have install Postgresql 7.3 with user name EDU.<br />then I enter the psql to change the password for EDU
using"alter user EDU with password 'aaaa''<br />it returns " user EDU do not exist".<br />I check the system table
pg_user,and the user 'EDU' actually exists.<br />But if I take the following SQL, it works<br />"create user TEST'<br
/>"Alteruser TEST with password 'dddd';<br />I check the pg_user again, and find the user "TEST' is replace by
'test'.<br/>So I have a question:<br />How I change the password for the initial user "EDU", or is it  a bug for
postgresql7.3?<br />Great thanks for any message<br />Josh.

Re: alter user problem

From

"Christopher Kings-Lynne"

Date:

20 December 2002, 00:30:05

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.