On Mon, 2004-03-08 at 11:57, Joe Maldonado wrote:Hello, I see that there is an item "Queries across databases or servers (two-phase commit)" on the todo list's urgent header. I have tried asking this question on the other lists and have not yet gotten a suitable answer to this question...When is this functionality expected to be available in PostgreSQL? I as well as many others want to be able to run queries such as
SELECT a.field_a, b.field_b FROM user:[EMAIL PROTECTED] AS a NATURAL JOIN local_table AS b;
Cross database selects can be accomplished using contrib/dblink.
It will be some time before cross database writes or locks will be possible.
THANKS!!!! this looks very promising and it seems that there are function available for insert/update/delete.
Again thanks
-Joe
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
