Re: dblink versus long connection strings

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: dblink versus long connection strings
Date: 2010-11-22 17:02:54
Message-ID: 4CEAA23E.3020609@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/22/2010 11:51 AM, Tom Lane wrote:
> Itagaki Takahiro<itagaki(dot)takahiro(at)gmail(dot)com> writes:
>> On Tue, Nov 23, 2010 at 01:27, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> I'm inclined to think that we should just change all the
>>> truncate_identifier calls to warn=false, and forget about providing
>>> identifier-truncated warnings here. Â It's too difficult to tell whether
>>> a string is really meant as an identifier.
>> It is not a truncated identifier, but I think the truncation is still
>> worth warning because we cannot distinguish two connections that
>> differ only>63 bytes.
> The problem is to not give a warning when the string isn't meant as a
> connection name at all, but as a libpq conninfo string (which can
> perfectly reasonably run to more than 63 characters). Most if not all
> of the dblink functions will accept either.
>
> Perhaps a reasonable compromise is to issue the truncation warnings when
> an overlength name is being *entered* into the connection table, but not
> for simple lookups.

Can't we distinguish a name from a conninfo string by the presence of an
= sign?

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-11-22 17:04:31 Re: format() with embedded to_char() formatter
Previous Message Tom Lane 2010-11-22 16:51:27 Re: dblink versus long connection strings