dblink versus schemas. What to use in this case?

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: dblink versus schemas. What to use in this case?
Date: 2005-02-23 14:33:33
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB165DA@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I have got two database schemas. They're rather independend. Thus they are
in two databases. However there is one function that needs access to the
other database.

As I found out, I have two choices:
*Using schemas and put the schemas tighter together (via interdependencies).
Dumping distinct schemas is possible, however quistionable if a restore will
work with the dependencies.
*Using dblink. Dblink gives me a loose binding of the two databases. Some of
us care about the 'contrib' status of dblink. Speed (connect, query,
disconnect may sloww down) and it's deadlock resolv capabilities. However
the deadlock thingy is just a question of interest.

What should I do?
....to make one fcn of one DB access another DB's tables/fcns....

Thanks

Browse pgsql-sql by date

  From Date Subject
Next Message George Weaver 2005-02-23 14:59:56 Re: Working with XML.
Previous Message Andrew Sullivan 2005-02-23 14:25:26 Re: PostgreSQL ignores my indexes