From: | "James W(dot) Wilson" <jww1066(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem with dblink and "drop owned by" |
Date: | 2012-07-18 23:38:45 |
Message-ID: | CAFP0EzJKcM5NTCUbisc92e=E72b1P60yHdPawqwf9cJEqV8O5g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "James W. Wilson" <jww1066(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2012-07-19 00:43:32 | Re: data from the table is getting dropped when I am restarting my application after making changes in the objects created in my application in play |
Previous Message | Tatsuo Ishii | 2012-07-18 23:16:26 | Re: main log encoding problem |