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 much
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
morehttp://mail.google.com/support/bin/answer.py?hl=enctx=mailanswer=185812
Report phishing
Why this message is popping up in my
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
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
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
Hi Eliot,
2011/11/17 Eliot Gable egable+pgsql-gene...@gmail.com:
snip
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
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 clear in Foreign Data Wrapper
documentation at PostgreSQL manuals.
I wasted at least 12
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 clear in