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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Known but bad behavior with alter user?


  • From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
  • To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
  • Subject: Known but bad behavior with alter user?
  • Date: Fri, 24 Mar 2006 09:58:23 -0800
  • Message-id: <4424333F(dot)3030501(at)commandprompt(dot)com>

Hello,

Take the following:

template1=# alter user foo rename to bar;
NOTICE:  MD5 password cleared because of role rename
NOTICE:  MD5 password cleared because of role rename
ALTER ROLE
template1=#

Now we have to reset the password.. which seems an extra
step that shouldn't be required.

Joshua D. Drake



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group