Invalid password for \ and ' characters

Поиск
Список
Период
Сортировка
От Andrus Moor
Тема Invalid password for \ and ' characters
Дата
Msg-id dvhupa$9ur$1@news.hub.org
обсуждение исходный текст
Ответы Re: Invalid password for \ and ' characters  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список pgadmin-support
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




В списке pgadmin-support по дате отправления:

Предыдущее
От: "Andrew Madu"
Дата:
Сообщение: postgreSQL txt dump restore
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: postgreSQL txt dump restore