Hello,
I'm trying to create new user. What is wrong in this ?
template1=# CREATE USER sympa WITH UNENCRYPTED PASSWORD 'kiki' NOCREATEDB NOCREATEUSER;
CREATE USER
template1=# \c - sympa
Password:
FATAL 1: Password authentication failed for user "sympa"
Previous connection kept template1=#
In log file i see : "verify_password: user 'sympa' not found in password file."
Then to verify that user is created i tried this : CREATE USER sympa WITH UNENCRYPTED PASSWORD 'kiki' NOCREATEDB NOCREATEUSER; ERROR: CREATE USER: user name "sympa" already exists template1=#
-- IT ressources center of Haute Savoie Saleve Building, International Business parc of Archamps, France Tel : +33450315630 - Fax : +33450953817 - http://www.cri74.fr
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
