Обсуждение: server vs foreign server inconsistency

Поиск
Список
Период
Сортировка

server vs foreign server inconsistency

От
Jaime Casanova
Дата:
Hi,

A few days ago i was wondering why we use CREATE/DROP SERVER but then
when we want to GRANT/REVOKE we need to use FOREIGN SERVER.

of course options are:

1) modify both to accept both forms
2) modify one of them to accept both forms and use that way in all our
examples in docs
3) do nothing at all

IMHO i think 3 is not acceptable because it's annoying

opinions?

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157



Re: server vs foreign server inconsistency

От
Tom Lane
Дата:
Jaime Casanova <jaime@2ndquadrant.com> writes:
> A few days ago i was wondering why we use CREATE/DROP SERVER but then
> when we want to GRANT/REVOKE we need to use FOREIGN SERVER.

Because the SQL standard says so.
        regards, tom lane