From: Tom Lane <tgl@sss.pgh.pa.us>
To: fcs1@poczta.onet.pl
cc: pgsql-bugs@postgresql.org
Subject: Re: BUG #14738: ALTER SERVER for foregin servers not working
In-reply-to: <20170710113917.7727.10247@wrigleys.postgresql.org>
References: <20170710113917.7727.10247@wrigleys.postgresql.org>
Comments: In-reply-to fcs1@poczta.onet.pl
	message dated "Mon, 10 Jul 2017 11:39:17 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1837.1499703533.1@sss.pgh.pa.us>
Date: Mon, 10 Jul 2017 12:18:53 -0400
Message-ID: <1838.1499703533@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

fcs1@poczta.onet.pl writes:
> PostgreSQL version: 9.4.1

> Command like this doesn't take effect:
> ALTER SERVER srw_egib_1
>   OPTIONS (
>     SET host 'localhost',
>     SET port '5432',
>     SET dbname 'gml2m1');
> It changes definition of this server but tables connected to it are still
> connected to previous definition of this server, for example:

It would help if you provided a concrete example of misbehavior rather
than abstract claims.  However, I *think* this is something we fixed in
9.4.11.  Please update and try again.

			regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs