Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

Next:From: Andreas PflugDate: 2006-03-19 11:18:00
Subject: Re: postgreSQL txt dump restore
Previous:From: Andrew MaduDate: 2006-03-18 18:13:28
Subject: postgreSQL txt dump restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group