Re: problem with dblink and "drop owned by"

Поиск
Список
Период
Сортировка
От James W. Wilson
Тема Re: problem with dblink and "drop owned by"
Дата
Msg-id CAFP0EzLzY4OcH4BQmePLNtHuFkwaRpQGgswP3YAh5Fogvs3uWg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: problem with dblink and "drop owned by"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
OK, understood, thanks.

On Wed, Jul 18, 2012 at 10:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "James W. Wilson" <jww1066@gmail.com> writes:
>> I'm confused. I thought foreign data wrappers were required to create
>> database links from one Postgresql server to another.
>
> contrib/dblink doesn't require them.  It does have an option to use an
> FDW instead of a libpq connection string to specify the connection
> target.  I had forgotten that that option got added in 8.4, before we
> had any other working use for FDWs --- so maybe we should rethink the
> decision not to backport this fix?
>
> Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
> Branch: master Release: REL9_1_BR [e356743f3] 2010-11-12 15:29:23 +0200
> Branch: REL9_0_STABLE Release: REL9_0_2 [533073cf2] 2010-11-12 15:30:19 +0200
>
>     Add missing support for removing foreign data wrapper / server privileges
>     belonging to a user at DROP OWNED BY. Foreign data wrappers and servers
>     don't do anything useful yet, which is why no-one has noticed, but since we
>     have them, seems prudent to fix this. Per report from Chetan Suttraway.
>     Backpatch to 9.0, 8.4 has the same problem but this patch didn't apply
>     there so I'm not going to bother.
>
> In the meantime, though, you do not *need* an FDW.  dblink worked fine
> for many releases before FDWs existed, and it still does work without
> 'em.
>
>                         regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: [BUGS] main log encoding problem
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: Handling error during async query