I'm confused. I thought foreign data wrappers were required to create
database links from one Postgresql server to another. Is there some
way to create a database link without using them? I was working off of
this example:
http://www.postgresql.org/docs/8.4/static/contrib-dblink-connect.html
I'm stuck with 8.4 for now, unfortunately.
James
On Wed, Jul 18, 2012 at 6:14 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "James W. Wilson" <jww1066@gmail.com> writes:
>> Hi, I'm using Postgresql 8.4.12-1 on Debian. I've installed 'dblink'
>> from the contrib package (also 8.4.12-1) and am now running into a
>> strange problem when I run "drop owned by".
>
> You're running into a old bug, which is that DROP OWNED BY doesn't know
> what to do with foreign data wrappers. According to the commit logs,
> this was fixed a couple of years ago in 9.0 and up, but we did not
> bother to fix 8.4 because foreign data wrappers aren't actually useful
> for anything in 8.4. If you want to work with FDWs, I'd suggest moving
> forward to a release where they have some real functionality ...
>
> regards, tom lane