[Fwd: Re: dblink patches for comment]

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: [Fwd: Re: dblink patches for comment]
Date: 2009-06-06 03:50:33
Message-ID: 4A29E789.1050405@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Based on Tom's post today about RC1, it sounds like I need to get this
committed very soon. Any complaints?

Joe

-------- Original Message --------
Subject: Re: [HACKERS] dblink patches for comment
Date: Tue, 02 Jun 2009 16:08:18 -0700
From: Joe Conway <mail(at)joeconway(dot)com>

Tom Lane wrote:
> The docs patch looks okay, except this comment is a bit hazy:
>
>> + -- Note: local connection must require authentication for this to work properly
>
> I think what it means is
>
>> + -- Note: local connection must require password authentication for this to work properly
>
> If not, please clarify some other way. It might also be good to be a
> bit more clear about what "fail to work properly" might entail.

OK, hopefully the attached is more clear.

> As far as the code goes, hopefully Peter will take a look since he's
> spent more time on the SQL/MED code than I have. The only thing I can
> see that looks bogus is that get_connect_string() is failing to handle
> any quoting/escaping that might be needed for the values to be inserted
> into the connection string. I don't recall offhand what rules libpq
> has for that, but I hope it at least implements doubled single quotes...

Added quote_literal_cstr() around the connection string params. Also
found I needed to restrict the servername string length to NAMEDATALEN
in order to avoid an assert if a full connection string is passed to
dblink_connect().

Other comments?

Thanks,

Joe

Attachment Content-Type Size
dblink.2009.06.02.02-sqlmed.diff text/x-patch 7.8 KB
dblink.2009.06.02.02-sqlmed_doc.diff text/x-patch 3.1 KB
Attached Message Part text/plain 160 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message J. Greg Davidson 2009-06-06 05:16:30 Re: blocking referencing system catalogs in 8.4 breaks my code
Previous Message Tatsuo Ishii 2009-06-06 03:45:58 Re: 8.4b2 tsearch2 strange error