On Thu, Jul 23, 2015 at 7:48 AM, Paul Ramsey <[email protected]> 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. -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
