Re: BUG #5761: In 'dblink' function connection string truncated

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: queej <dqj(at)quinn-jacobs(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5761: In 'dblink' function connection string truncated
Date: 2010-11-29 18:27:38
Message-ID: 1053.1291055258@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

queej <dqj(at)quinn-jacobs(dot)org> writes:
> On Nov 29, 10:50am, d(dot)(dot)(dot)(at)authentrics(dot)com (queej) wrote:
>> Yes, it causes an error for me since it truncates the connection string in
>> the middle of the username, omitting the password altogether. I must be
>> missing something; I can't understand what my alternative is but to call the
>> dblink(text,text) function with a connection string and a SQL statement.

> I should have mentioned that my dblink() calls are within views, so I
> cannot do a two-step process of dblink_connect() followed by a
> dblink().

As far as our investigation could tell, the message you're complaining
about is simply a warning and would not result in any actual failure.
I agree it's a bug that the message comes out at all, but it appears
to be just cosmetic. If you have a situation where it leads to a
non-cosmetic problem, you need to provide a complete test case
illustrating that, or it's not going to get fixed.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2010-11-29 18:53:36 Re: BUG #5774: VACCUM & REINDEX kills production environement
Previous Message Balamurugan Mahendran 2010-11-29 17:08:18 Re: BUG #5774: VACCUM & REINDEX kills production environement