Can't delete user

[ajpierson]

I am having some problems with managing users in postgreSQL 8.0.1. I have a user that was set up with privilages to create users and databases. When I try to connect to a database (or do anything) with this user I get the following error:

psql: FATAL: user "adam" does not exist.

If I try to create the user adam again I get the following error:

createuser: creation of new user failed: ERROR: user "adam" already exists.

If I try to delete the user I get:

dropuser: removal of user "adam" failed: ERROR: user "adam" does not exist.

I have also tried by using the SQL commands DROP USER and CREATE USER, with similar results. Is there some where that I can go and manually remove the user? I am running postgreSQL 8.0.1 on gentoo linux

 

[aardvark92]

I recall having a similar problem a couple months ago. Those error messages look familiar.... I think in my case, the user name was capitalized when first set up.

 

[ajpierson]

Thank you for the post, I tried all sorts of permutations with capital letters and that still didn't work. Any other ideas?