missing windows info
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
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?
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
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
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