Discussion:
createuser problem in 7.3.4 on Linux
(too old to reply)
Peter Eisentraut
2003-12-17 10:26:03 UTC
Permalink
But if I try DROP USER Administrator&nbsp;&nbsp;I get<BR>
<BR>
ERROR: DROP USER: user "administrator" does not exist<BR>
<BR>
Note the last error has "administrator" rather than "Administrator".<BR>
You need to double quote the name to preserve case.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly
A.Bhuvaneswaran
2003-12-17 10:31:28 UTC
Permalink
As user postgres I have run initdb. I create a user named
Administrator via the createuser script. All goes well and I get the
response CREATE USER.
psql -U Administrator template1
psql: FATAL: IDENT authentication failed for user "Administrator".
Default installation uses ident authentication method. It requires os
user with the same name & mapping in pg_ident.conf. If i am correct, you
are looking for either trust/password authentication method. If so, edit
pg_hba.conf and comment the ident entry and uncomment trust entry.
ERROR: DROP USER: user "administrator" does not exist
It looks strange. Ensure, you are not deleting the user twice -:).
Since, IMO, both createuser and dropuser scripts handle the case
properly.

regards,
bhuvaneswaran
A.Bhuvaneswaran
2003-12-17 11:18:16 UTC
Permalink
Post by Peter Eisentraut
You need to double quote the name to preserve case.
IMO, in 7.3.4, these two scripts (createuser & dropuser) preserve the
case by default even without double quote. For example, 'createuser
Admin' makes an entry Admin(not admin) in pg_shadow. Similarly, dropuser
deletes the same entry even without double quote.

Else, am i missing some thing?

regards,
bhuvaneswaran
Peter Eisentraut
2003-12-17 11:21:50 UTC
Permalink
Post by A.Bhuvaneswaran
Post by Peter Eisentraut
You need to double quote the name to preserve case.
IMO, in 7.3.4, these two scripts (createuser & dropuser) preserve the
case by default even without double quote. For example, 'createuser
Admin' makes an entry Admin(not admin) in pg_shadow. Similarly, dropuser
deletes the same entry even without double quote.
Sure, but we were not talking about createuser or dropuser.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

Loading...