| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | Erik Jones <erik(at)myemma(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dblink vs dbi-link (and errors compiling) |
| Date: | 2007-09-07 08:58:29 |
| Message-ID: | 1189155509.13896.6.camel@neuromancer.home.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2007-09-07 at 10:16 +0200, Albe Laurenz wrote:
> Ow Mun Heng wrote:
> True, you'll have to write some stuff that does something like:
> - pull the data over from the other database
> - replace the data in the local table
Already doing that currently for some data tables/
> Since it is between PostgreSQL databases,
actually, it'll be against SQL Servers
> preserves less of the PostgreSQL-ness
> of the data - e.g. data type is lost, all data arrive as text.
Another thing I didn't know.. thanks again for this heads up..
> The correct way is like this:
> cd into the PostgreSQL source directory
> ./configure with the correct arguments
> make -C src/backend ../../src/include/utils/fmgroids.h
> make -C contrib/dblink
Cool. I'll give it a shot//
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2007-09-07 09:16:02 | Re: dblink vs dbi-link (and errors compiling) |
| Previous Message | Dave Page | 2007-09-07 08:34:12 | Re: Connecting to PostgreSQL server with Mono using ident authetication |