Re: BUG #5304: psql using conninfo fails in connecting to the server - Mailing list pgsql-bugs

From Joe Conway
Subject Re: BUG #5304: psql using conninfo fails in connecting to the server
Date
Msg-id 4B68CBDB.4070006@joeconway.com
Whole thread Raw
In response to Re: BUG #5304: psql using conninfo fails in connecting to the server  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5304: psql using conninfo fails in connecting to the server  (Fujii Masao <masao.fujii@gmail.com>)
Re: BUG #5304: psql using conninfo fails in connecting to the server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 02/01/2010 08:06 AM, Tom Lane wrote:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>> 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.
>
> No, it was intentional.

Here's a patch.

If "=" is found in the dbname psql argument, the argument is assumed to
be a conninfo string. In that case, append application_name to the
conninfo and use PQsetdbLogin() as before. Otherwise use the new
PQconnectdbParams().

Also only uses static assignments for array constructors.

Objections?

Thanks,

Joe

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: whole-row functional index?
Next
From: Fujii Masao
Date:
Subject: Re: BUG #5304: psql using conninfo fails in connecting to the server