On 4 Jul 2003 at 18:56, MIka Santos wrote:
> said online registration. He wanted a multidatabase querying. For example, we
> knew that the following statements are posible,
> select *
> from t1, t2., t3;
> provided that t1 and t2, t3 are tables from a single database.
> Ourthesis is to make the
Hello Mika
Currently you can use dblink which queries a remote database and returns
the data as a table. This works nicely for PostgreSQL. There is also a
JDBC version in progress.
We have writte an Oracle version of dblink.
SELECT * FROM dblink('connectstr', 'SELECT ...') AS some_type;
This w
As luck would have I've put some thought into this problem before as
well. Having reviewed the code quite a bit, and played around with the
backend, my intuition tells me that the following would work.
Write a custom "cluster-aware" postmaster so it distributes queries to
various machines. Of
Gud day! We are currently having our thesis for our undergarduate course and this involoves the code of PostgreSQL. Basically, our thesis needs a modification of the existing code of the said database. As of now, our University has an existing online registration system which uses Postgre as their
