Thread: Bug with passwords that include apostrophes
pgAdmin version: latest bundled
OS: Windows XP
Description
-----------
Attempting to log into a database with pgAdmin using a password that
contains the apostrophe (') character causes this error:
"An error has occurred.
Error connecting to the server: missing "=" after "asdf" in connection
info string."
It's almost certain you have the same problem connecting with a username
with an apostrophe, or to a db name with one.
In the connection string you need to go:
password='asdf\'fdsa' dbname='dbname'
To properly escape it.
Chris
> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Christopher Kings-Lynne
> Sent: 16 June 2006 03:29
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Bug with passwords that include apostrophes
>
> pgAdmin version: latest bundled
> OS: Windows XP
>
> Description
> -----------
>
> Attempting to log into a database with pgAdmin using a password that
> contains the apostrophe (') character causes this error:
>
Latest bundled with what? That bug was fixed already:
2006-02-17 DP 1.4.2 Properly escape single quotes in connection
strings.
Regards, Dave.
> Latest bundled with what? That bug was fixed already: > > 2006-02-17 DP 1.4.2 Properly escape single quotes in connection > strings. Ah bummer. Turns out I had 1.4.0... Chris
How do I get an email address removed from this list?
-----Original Message-----
From: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Christopher
Kings-Lynne
Sent: Thursday, June 15, 2006 10:29 PM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Bug with passwords that include apostrophes
pgAdmin version: latest bundled
OS: Windows XP
Description
-----------
Attempting to log into a database with pgAdmin using a password that
contains the apostrophe (') character causes this error:
"An error has occurred.
Error connecting to the server: missing "=" after "asdf" in connection info
string."
It's almost certain you have the same problem connecting with a username
with an apostrophe, or to a db name with one.
In the connection string you need to go:
password='asdf\'fdsa' dbname='dbname'
To properly escape it.
Chris
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to
majordomo@postgresql.orgso that your message can get through to the mailing list cleanly