public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: ALTER SERVER SYNTAX ISSUE
Date: Wed, 31 Oct 2018 07:57:18 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

=?utf-8?q?PG_Doc_comments_form?= <[email protected]> writes:
> I found that the alter server statement below does not work:
> ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');
> but this does:
> ALTER SERVER foo OPTIONS (set host 'foo', set dbname 'foodb');

Hm, define "does not work".  Those aren't equivalent: the first
form adds options that weren't already set, while the second one
changes the values of already-set options.  (The SQL committee
were being unreasonably nitpicky in not providing an add-or-replace
choice, IMO, but that's how the spec is written.)

Is your complaint just that this is inadequately documented?
I see that it's not spelled out in so many words on that page.

			regards, tom lane

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: ALTER SERVER SYNTAX ISSUE
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox