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

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

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

pgsql-bugs by date

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

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