On Thu, Jul 23, 2015 at 7:48 AM, Paul Ramsey <pramsey@cleverelephant.ca> wrote:
> In testing it I came across an unrelated issue which could make it
> hard for users to manage the options on their wrappers/servers
>
> fdw=# ALTER SERVER foreign_server OPTIONS ( extensions 'postgis' );
> ALTER SERVER
> fdw=# ALTER SERVER foreign_server OPTIONS ( extensions 'postgis,seg' );
> ERROR: option "extensions" provided more than once
>
> Once set, an option seems to be effectively immutable.
Whoops, I see I just didn't read the fully syntax on providing options, using
ALTER SERVER foreign_server OPTIONS ( SET extensions 'postgis,seg' );
works just fine. Sorry for noise,
P.