Invalid password for \ and ' characters

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: pgadmin-support(at)postgresql(dot)org
Subject: Invalid password for \ and ' characters
Date: 2006-03-18 21:40:41
Message-ID: dvhupa$9ur$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2006-03-19 11:18:00 Re: postgreSQL txt dump restore
Previous Message Andrew Madu 2006-03-18 18:13:28 postgreSQL txt dump restore