Re: PostgreSQL 12 release notes missing breaking change in libpq

2019-10-23 Thread Bruce Momjian
On Thu, Oct 17, 2019 at 10:33:10AM +0900, Michael Paquier wrote: > On Wed, Oct 16, 2019 at 01:12:36PM +, PG Doc comments form wrote: > > In PostgreSQL 12, libpq's parsing of connection string integer parameters > > was made more strict, such that invalid values now result in an error rather > >

Re: Typo on Refresh Materialized View page

2019-10-23 Thread Bruce Momjian
On Fri, Oct 11, 2019 at 04:31:21AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/sql-refreshmaterializedview.html > Description: > > Hello > > There appears to be a typo on this page: > https:

Log Rotation Documentation Update

2019-10-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-logging.html Description: Hi all: We recently ran into an unusual case where the following occurred: - PG log directory is a separate filesystem from PG data and other oper

Re: uniqueness and null could benefit from a hint for dba

2019-10-23 Thread Tuomas Leikola
That is a nice design. You can create a regular unique index where columns(s)s are not null and then filtered index(es) for the cases where some of the unique columns are null. However my point, specifically, was that if the document in question would have offered alternative solutions, I personal