On Tuesday 14 July 2009 13:35:23 you wrote: > yes -- thank you > > that's in the direction of what I am looking for > > > ODBC connectivity and joins across databases! > > > It looks like it cannot support > a single image table across databases It's effectively a single image across nodes - in that the grid allows you to partition a table across nodes (i.e. physical servers) so any sql see's it as a single table so long as you send the sql to the grid controller > > But do you know if supports viewes that combines tables > from different servers (this way > I can prefix a table on each server with server_id and then > just combine them in the view in a single Image table) > no need for this, the system presents the clients (via the controller) a single table - even though its actually partitioned across nodes It's quite similar to the Informix XPS product if that helps > > I am downloading it now and will try out on my windows dev > machine. > > > thanks > > > Maybe this is what you're looking for? > > > > http://www.enterprisedb.com/community/projects/gridsql.do > > > > > > > > > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > -- > Vlad P > author of C++ ORM http://github.com/vladp/CppOrm/tree/master -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general