If password set by pgadmin contains \ or ' character, it is not possible to
login to pgAdmin
PROBLEM WITH \ character is password
To reproduce
1. Create new login role in pgadmin
2. Enter \ to password field.
3. Select SQL tab
Observed:
CREATE ROLE test LOGIN PASSWORD '\\'
Expected
CREATE ROLE test LOGIN PASSWORD '\'
Postres does NOT require backslashes in password strings.
PgAdmin probably uses its qtString for password strings.
This causes invalid passwords to be set if password contains \ character.
PROBLEM WITH ' CHARACTER IN PASSWORD
To reproduce:
1. Using pgADMIN login role property dialog set pgAdmin login role password
to '
2. Re-open the connection to server.
Observed:
---------------------------
pgAdmin III
---------------------------
An error has occured:
Error connecting to the server: missing "=" after "''" in connection info
string
Platform:
pgAdmin 1.4.0 on windows xp
PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)
Andrus Moor
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
