Search Postgresql Archives

Re: problem with dblink and "drop owned by"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"James W. Wilson" <jww1066@xxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux