Thread: Feature Request - Postgres FDW
Surprised to see this isn’t offered as a Foreign Data Wrapper- one to other Postgres servers. I was attempting to replace some uses I have of dbilink, and found a couple places where I am using it to connect to Postgres. One is for pseudo “Autonomous Transactions”- a db link to the same postgres server with autocommit turned on. Another is to a different database server, simply for separation of concerns, load distribution, etc, where data is rarely but sometimes needed from the originating server.
Has there been any talk of providing a Postgres FDW? What are your thoughts?
~Dave Greco
David Greco <David_Greco@harte-hanks.com> wrote: > Surprised to see this isn't offered as a Foreign Data Wrapper- one > to other Postgres servers. People have been working on it. It seems quite likely to be included in the 9.3 release next year. -Kevin
Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote: > David Greco <David_Greco@harte-hanks.com> wrote: > > > Surprised to see this isn't offered as a Foreign Data Wrapper- one > > to other Postgres servers. > > People have been working on it. It seems quite likely to be > included in the 9.3 release next year. That's cool ;-) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
Great thanks. I see there is talk of 9.3 including autonomous transaction support as well. -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] Sent: Tuesday, August 07, 2012 1:04 PM To: David Greco; pgsql-general@postgresql.org Subject: Re: [GENERAL] Feature Request - Postgres FDW David Greco <David_Greco@harte-hanks.com> wrote: > Surprised to see this isn't offered as a Foreign Data Wrapper- one to > other Postgres servers. People have been working on it. It seems quite likely to be included in the 9.3 release next year. -Kevin