Ah, gotcha! I guess whatever sample I was originally copying from used
hostaddr for some reason.. Thanks for the clarification, Tom!
On Wed, May 15, 2013 at 6:08 AM, Tom Lane wrote:
> Mike Christensen writes:
> > Though I'm a bit curious why there's a host and hostaddr. Why can't it
> > jus
Mike Christensen writes:
> Though I'm a bit curious why there's a host and hostaddr. Why can't it
> just resolve whatever you give it?
Well, it will ... if you use the "host" parameter. The whole point of
"hostaddr" is that for that parameter, it will not try a DNS lookup.
You'd only use that i
Though I'm a bit curious why there's a host and hostaddr. Why can't it
just resolve whatever you give it?
On Tue, May 14, 2013 at 9:31 PM, Mike Christensen wrote:
> Excellent! Thanks so much.
>
>
> On Tue, May 14, 2013 at 9:25 PM, Adrian Klaver wrote:
>
>> On 05/14/2013 09:17 PM, Mike Christen
Excellent! Thanks so much.
On Tue, May 14, 2013 at 9:25 PM, Adrian Klaver wrote:
> On 05/14/2013 09:17 PM, Mike Christensen wrote:
>
>> If I have this:
>>
>> CREATE OR REPLACE VIEW Link.Foo AS
>>select * from dblink(
>> 'hostaddr=123.123.123.123 dbname=KitchenPC user=Website
>> passwor
On 05/14/2013 09:17 PM, Mike Christensen wrote:
If I have this:
CREATE OR REPLACE VIEW Link.Foo AS
select * from dblink(
'hostaddr=123.123.123.123 dbname=KitchenPC user=Website
password=secret',
'select * from Foo') as ...
Then it works. However, if I do:
CREATE OR REPLACE VIEW L
If I have this:
CREATE OR REPLACE VIEW Link.Foo AS
select * from dblink(
'hostaddr=123.123.123.123 dbname=KitchenPC user=Website
password=secret',
'select * from Foo') as ...
Then it works. However, if I do:
CREATE OR REPLACE VIEW Link.Foo AS
select * from dblink(
'hostaddr=db.d
