Re: [GENERAL] Foreign Tables

Thank you for your response... > Foreign tables in 9.1 are read-only, so you can't write to them. Making > foreign tables writable is a TODO item, but ISTM it's difficult to > implement it for even 9.2. So the answer to your question 1a) is "No". > > BTW, I'm interested in your use case very mu

Re: [GENERAL] Foreign Tables

On Thu, Nov 17, 2011 at 2:59 AM, Raghavendra < raghavendra@enterprisedb.com> wrote: > > Shigeru Hanada shigeru.han...@gmail.com > 7:48 AM (5 hours ago) > to Eliot, pgsql-general > This message may not have been sent by: shigeru.han...@gmail.com Learn > more

Re: [GENERAL] Foreign Tables

Shigeru Hanada shigeru.han...@gmail.com 7:48 AM (5 hours ago) to Eliot, pgsql-general This message may not have been sent by: shigeru.han...@gmail.com Learn more Report phishing Why this message is popping up in

Re: [GENERAL] Foreign Tables

Hi Eliot, 2011/11/17 Eliot Gable : > 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? Foreign tables in 9.1 are

Re: [GENERAL] Foreign Tables

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

Re: [GENERAL] Foreign tables using postgresql_fdw or odbc_fdw

On Sunday, September 18, 2011 6:32:43 am Edson Carlos Ericksson Richter wrote: > Tried both, but they don't work for 9.1. > > I want to thank Adrian, without his help I would never find the link that > confirmed the postgresql_fdw is not working. > > Would be nice to make all this information cle