Re: BUG #5304: psql using conninfo fails in connecting to the server

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5304: psql using conninfo fails in connecting to the server
Date: 2010-02-01 08:53:38
Message-ID: 9837222c1002010053n5df5e55dw88c85bed306a4be2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

2010/2/1 Fujii Masao <masao(dot)fujii(at)gmail(dot)com>:
> On Mon, Feb 1, 2010 at 5:31 PM, Heikki Linnakangas
> <heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>> Fujii Masao wrote:
>>> In HEAD, psql using conninfo fails in connecting to the server as follows.
>>>
>>>   $ bin/psql "host=localhost"
>>>   psql: FATAL:  database "host=localhost" does not exist
>>>
>>> This is because the recently-introduced PQconnectStartParams()
>>> doesn't handle correctly the dbname parameter containing '='.
>>
>> Hmm, I don't think that was ever really supposed to work, it was
>> accidental that it did. I certainly didn't realize you could do that.
>> The documented way to do that is:
>>
>> bin/psql --host=localhost
>
> Really? According to the document, psql using conninfo seems to
> be supported.
>
> http://developer.postgresql.org/pgdocs/postgres/app-psql.html#R2-APP-PSQL-CONNECTING

Yes, that is definitely supposed to work. It was intentionally added
in 8.3 and is very useful :-)

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-02-01 16:06:11 Re: BUG #5304: psql using conninfo fails in connecting to the server
Previous Message Fujii Masao 2010-02-01 08:45:40 Re: BUG #5304: psql using conninfo fails in connecting to the server

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2010-02-01 08:54:03 Re: Hot Standby and VACUUM FULL
Previous Message Fujii Masao 2010-02-01 08:45:40 Re: BUG #5304: psql using conninfo fails in connecting to the server