On Wed, 2011-11-16 at 13:38 -0500, Eliot Gable wrote: > I am working on a reporting project where I need to generate a report based > on data from several different network appliances. Each appliance runs a > PostgreSQL database which houses all of the information for the appliance. > Further, there are dozens of triggers in the database which fire when > various tables are touched in various different ways (insert, update, > delete). These triggers currently are used to build materialized views of > much of the data that I want to summarize in the reports. > > I have read as much as I can find on 9.1's foreign table support, and it > looks almost ideal for bridging the gap between all the databases and > collecting all the data into a single report. However, I am unclear on a > few points... > > 1a) Can the foreign tables be written to? For example, I have server1 with > table foo and server2 which does 'create foreign table bar' where bar > references server1.foo. Can server2 write to bar and have it show in > server1.foo? > No, you can't (yet?). -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
