dblink vs dbi-link (and errors compiling)

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: dblink vs dbi-link (and errors compiling)
Date: 2007-09-07 03:54:38
Message-ID: 1189137278.17218.51.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm confused as to the difference between dblink and dbi-link.

dblink is included in the contrib directory and dbi-link is available
from pgfoundry.

dblink seems like it creates a view of a remote DB and is static, which
means that it needs to be refreshed each time.

dbi-link seems like it uses perl's dbi to connect to a remote db.

In either of the above, I would like to know which one is able to help
me to like connect to a remote DB, use the table there and join to a
local table in PG so that I don't have to use DBI to pull and insert
those data into the local PG database.

BTW, dblink doesn't compile. (8.2.4)

gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fpic
-I../../src/interfaces/libpq -I. -I../../src/include -D_GNU_SOURCE -c
-o dblink.o dblink.c
dblink.c:56:28: error: utils/fmgroids.h: No such file or directory
dblink.c: In function 'get_pkey_attnames':
dblink.c:1684: error: 'F_OIDEQ' undeclared (first use in this function)
dblink.c:1684: error: (Each undeclared identifier is reported only once
dblink.c:1684: error: for each function it appears in.)
make: *** [dblink.o] Error 1

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-09-07 04:01:14 Re: Call for Speakers PostgreSQL Conference Fall 2007
Previous Message Tom Lane 2007-09-07 03:54:31 Re: an other provokative question??