Re: Questions about Views, Rules and DBLink

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Questions about Views, Rules and DBLink
Дата
Msg-id 24410.1122869992@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Questions about Views, Rules and DBLink  (Joao Afonso <joaoaafonso@gmail.com>)
Ответы Re: Questions about Views, Rules and DBLink  (Joe Conway <mail@joeconway.com>)
Re: Questions about Views, Rules and DBLink  (Joao Afonso <joaoaafonso@gmail.com>)
Список pgsql-general
Joao Afonso <joaoaafonso@gmail.com> writes:
>   So (finally), my question is why does this happen? Using instead on
> the users_util insert rule shouldn't discard the original query and
> rewrite it according to the specified on the rule?? Is this a problem
> of dblink?

I hadn't noticed the dblink_current_query() function before, but now
that I see it, I consider it a pretty bad idea.  It certainly will not
help you the way you are hoping, because what it returns is the text of
the interactive command the backend is currently working on --- which
could be indefinitely far removed from the operation your rule is firing
for.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postmaster
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Questions about Views, Rules and DBLink