Thanks Melvin for your reply. Sorry I missed the command i'm using.
>Finally, I see no reason why this user should not be able to change it's >own password. >What is the exact command you are using to try to change the >password? What is the >exact error?
Command : ALTER ROLE MyRole WITH PASSWORD 'myPassword'
It first confirm the existing password which is fine and authorization is granted.
As soon I try to change the password it give me the error :
ERROR: Can not ALTER ROLE in a read only transaction.
>First, it would be helpful if you indicated the O/S and version of >PostgreSQL you are using.
I'm using Postgresl 9.1 on Windows 7 (64 bit) and Debian Linux 6.x (64 bit)
>Also, it is not a good idea to use CamelCase names in POstgreSQL. There is >no need for >that and PostgreSQL will always try to convert names to >lowercase unless bounded by >double quotes.
I just wrote for clarity :-)
>Finally, I see no reason why this user should not be able to change it's >own password. >What is the exact command you are using to try to change the >password? What is the >exact error?
As soon I try to change the password it give me the error :
ERROR: Can not ALTER ROLE in a read only transaction.
First, it would be helpful if you indicated the O/S and version of PostgreSQL you are using.
Also, it is not a good idea to use CamelCase names in POstgreSQL. There is no need for that and PostgreSQL will always try to convert names to lowercase unless bounded by double quotes.
Finally, I see no reason why this user should not be able to change it's own password. What is the exact command you are using to try to change the password? What is the exact error?