Обсуждение: Speaking of dblink

Could someone point me in the direction of some documentation on dblink? I
haven't been able to find anything on it on postgresql.org, and I'd like to
learn more about it.

Thanks,
--Walt Weaver
  Bozeman, Montana

Weaver, Walt wrote:
> Could someone point me in the direction of some documentation on dblink? I
> haven't been able to find anything on it on postgresql.org, and I'd like to
> learn more about it.
>

See README.dblink in contrib/dblink of the source distribution. I believe it
also gets installed by the RPM -- yep, here it is:

# rpm -ql postgresql-contrib | grep README.dblink
/usr/lib/pgsql/contrib/dblink/README.dblink

HTH,

Joe

Yup, found that, I've got dblink set up, I was just hoping to find a bit
more in-depth information.

Thanks for the help,

--Walt

-----Original Message-----
From: Joe Conway [mailto:mail@joeconway.com]
Sent: Monday, September 23, 2002 1:39 PM
To: Weaver, Walt
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Speaking of dblink


Weaver, Walt wrote:
> Could someone point me in the direction of some documentation on dblink? I
> haven't been able to find anything on it on postgresql.org, and I'd like
to
> learn more about it.
>

See README.dblink in contrib/dblink of the source distribution. I believe it

also gets installed by the RPM -- yep, here it is:

# rpm -ql postgresql-contrib | grep README.dblink
/usr/lib/pgsql/contrib/dblink/README.dblink

HTH,

Joe

Weaver, Walt wrote:
> Yup, found that, I've got dblink set up, I was just hoping to find a bit
> more in-depth information.
>

Sorry -- that's it for the moment. If you have any specific questions, feel
free to ask ;-)

BTW, if you can, I'd recommend getting PostgreSQL 7.3beta 2, which should be
out in the next couple of days. The functionality of dblink is much improved
(and somewhat different) from the previous one. The original syntax is now
deprecated in favor of the new syntax, although the old will be supported for
this release. The documentation is a bit expanded as well, and there is a
regression test script which illustrates the usage of each of the functions.

Joe

Sounds good, I'll look for the 7.3 beta.

Thanks!

--Walt

-----Original Message-----
From: Joe Conway [mailto:mail@joeconway.com]
Sent: Monday, September 23, 2002 1:54 PM
To: Weaver, Walt
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Speaking of dblink


Weaver, Walt wrote:
> Yup, found that, I've got dblink set up, I was just hoping to find a bit
> more in-depth information.
>

Sorry -- that's it for the moment. If you have any specific questions, feel
free to ask ;-)

BTW, if you can, I'd recommend getting PostgreSQL 7.3beta 2, which should be

out in the next couple of days. The functionality of dblink is much improved

(and somewhat different) from the previous one. The original syntax is now
deprecated in favor of the new syntax, although the old will be supported
for
this release. The documentation is a bit expanded as well, and there is a
regression test script which illustrates the usage of each of the functions.

Joe

Sir,


    We had been experimenting with dblink to perform remote update and
remote queries and queries involving multiple remote databases. It works
fine in our local intranet. I still need to find out how it would fare
when some of the remote database servers will be located outside of our
local intranet.

    We tried to work on designing and implementing a distributed database
with most of the relations are horizontally partitioned particularly those
which are experiencing dynamic behaviour while those which are not always
updated are fully replicated in all the sites. Our experience showed that
these requirements are ably supported by dblink.


Manny Cabido
MSU-Iligan Institute of Technology
Iligan City 9200
Philippines