missing windows info

2018-11-19 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/libpq-pgservice.html
Description:

The default location for a user level connection service file on Windows is
not given. The path is given for the password file on the previous page in
the documentation.

Please add that '%APPDATA%\postgresql\.pg_service.conf' is the default
location in https://www.postgresql.org/docs/current/libpq-pgservice.html.


Re: INSERT INTO RETURNING SYNTAX ERROR

2018-11-19 Thread Bruce Momjian
On Mon, Oct 22, 2018 at 08:42:27AM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/9.6/static/sql-insert.html
> Description:
> 
> When using the RETURNING extension on the INSERT function when nested, does
> not propagate the return value up, and causes a syntax error on the "INTO"
> keyword, this is because the RETURNING extension is also expecting in "INTO"
> key word, which isn't mentioned anywhere in the documentation?

Uh, can you show us an example of the failure?

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+  Ancient Roman grave inscription +



Add note about how to disable the subscription too?

2018-11-19 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/sql-dropsubscription.html
Description:

This page has a note about how to set the subscription to not use a slot,
but it doesn't mention that the subscription needs to be disabled first. In
my case, I had to Google around and then do:

ALTER SUBSCRIPTION xxx disable;

Then I could set the slot_name. Then I could drop it.


Re: Documentation for create unique index is insuficient and (because of that) incorrect

2018-11-19 Thread Bruce Momjian
On Tue, Oct 23, 2018 at 06:29:55PM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/11/static/indexes-unique.html
> Description:
> 
> In https://www.postgresql.org/docs/11/static/indexes-unique.html there are
> omited clausules
> 
> For example WHERE clausule is omited. 
> 
> In https://www.postgresql.org/docs/11/static/sql-createindex.html you can
> see the right sintax with all the clausules.

The first URL is an example and is not intended to be the complete
syntax.

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+  Ancient Roman grave inscription +



Section 26.2.1. Planning wording

2018-11-19 Thread Theo Kramer
Section 26.2.1. Planning wording includes the following

"In any case the hardware architecture must be the same — shipping from, say, a 
32-bit to a 64-bit system will not work."

would  be more correct if it read as follows

"In any case the CPU architecture must be the same — shipping from, say, a 
32-bit to a 64-bit system will not work."

as “hardware architecture” would imply the difference between say Dell and IBM 
which should be ok if the CPU is the same architecture ...

-- 
Regards
Theo Kramer