public inbox for [email protected]
help / color / mirror / Atom feedALTER SERVER SYNTAX ISSUE
2+ messages / 2 participants
[nested] [flat]
* ALTER SERVER SYNTAX ISSUE
@ 2018-10-30 23:52 PG Doc comments form <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2018-10-30 23:52 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-alterserver.html
Description:
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');
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ALTER SERVER SYNTAX ISSUE
@ 2018-10-31 11:57 Tom Lane <[email protected]>
parent: PG Doc comments form <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2018-10-31 11:57 UTC (permalink / raw)
To: [email protected]; +Cc: [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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-10-31 11:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-30 23:52 ALTER SERVER SYNTAX ISSUE PG Doc comments form <[email protected]>
2018-10-31 11:57 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox