CRI74 - Fabien Combernous <[EMAIL PROTECTED]> writes: > template1=# CREATE USER sympa WITH UNENCRYPTED PASSWORD 'kiki' > NOCREATEDB NOCREATEUSER; > CREATE USER > template1=# \c - sympa > Password: > FATAL 1: Password authentication failed for user "sympa"
Perhaps you did this inside a BEGIN block, and forgot to COMMIT? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings