Re: [HACKERS] psql commandline conninfo

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: pgsql-patches(at)postgresql(dot)org
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] psql commandline conninfo
Date: 2006-12-16 03:59:58
Message-ID: 2312.24.211.165.134.1166241598.squirrel@www.dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Andrew Dunstan wrote:
> Tom Lane wrote:
>> "Andrew Dunstan" <andrew(at)dunslane(dot)net> writes:
>>
>>> We change libpq from time to time. Besides, how many DBs are there that
>>> match the name pattern /^conn:.*=/ ? My guess is mighty few. So I don't
>>> expect lots of surprise.
>>>
>>
>> Um, but how many DB names have an "=" in them at all?
>>
>> Basically what this proposal is about is migrating from separated
>> dbname/user/host/port/etc parameters to a unified conninfo parameter.
>> That seems to me like a good long-term objective, and so I'm willing
>> to break a few eggs on the way to the omelet, as long as we're not
>> breaking any very likely usages.
>>
>> So: who here has a database with "=" in the name? And hands up if
>> you've got a database whose name begins with "conn:"?
>>
>> I'm betting zero response rate on both of those, so see no reason to
>> contort the long-term definition for a very marginal difference in
>> the extent of backwards compatibility ...
>>
>>
>>
>
> I'm not sure -hackers is the most representative group to poll regarding
> dbnames in use ...
>
> Anyway, if I understand your current position, the only change needed to
> my current patch would be that if we fail to parse a dbname parameter
> that contains an = we simply fail at that point, rather than retrying it
> as a straight database name.
>
> I'm OK with that.
>

Here's the patch for what I think is the consensus position. If there's no
objection I will apply this and document it.

cheers

andrew

Attachment Content-Type Size
dsnpatch application/octet-stream 1.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-12-16 04:55:04 Re: [HACKERS] psql commandline conninfo
Previous Message Tom Lane 2006-12-16 00:04:17 Re: Operator class group proposal

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-12-16 04:55:04 Re: [HACKERS] psql commandline conninfo
Previous Message Bruce Momjian 2006-12-15 03:19:36 Re: Updated XML patch