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

Re: alter user problem

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "postgresql" <postgresql(at)db(dot)pku(dot)edu(dot)cn>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: alter user problem
Date: 2002-12-20 02:30:15
Message-ID: GNELIHDDFBOCMGBFGEFOAELFCEAA.chriskl@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
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(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of postgresql
  Sent: Friday, 20 December 2002 10:01 AM
  To: pgsql-hackers(at)postgresql(dot)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.

In response to

pgsql-hackers by date

Next:From: Hiroshi InoueDate: 2002-12-20 04:21:59
Subject: Re: About server side prepare
Previous:From: Dave CramerDate: 2002-12-20 02:11:05
Subject: Re: error when using move, any suggestions?

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