Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] postgres_fdw extension support - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [PATCH] postgres_fdw extension support
Date
Msg-id 20150723145917.GD21169@awork2.anarazel.de
Whole thread Raw
In response to Re: [PATCH] postgres_fdw extension support  (Paul Ramsey <pramsey@cleverelephant.ca>)
List pgsql-hackers
Tree view 
On 2015-07-23 07:48:49 -0700, Paul Ramsey wrote:
> 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.

Add SET to the mix and you should be good. The default is ADD, which
explains the problem.

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Paul Ramsey
Date:
Subject: Re: [PATCH] postgres_fdw extension support
Next
From: Robert Haas
Date:
Subject: Re: optimizing vacuum truncation scans