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
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 |