[DOCS] SQLState: 42501
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/static/errcodes-appendix.html Description: Please tell me how to solve the error Error: ERROR: could not set permissions on directory "/opt/home/postgres/adc-data/config_data": Operation not permitted SQLState: 42501 ErrorCode: 0 Error occurred in: CREATE TABLESPACE CONFIG_DATA OWNER adcdbuser LOCATION '/opt/home/postgres/adc-data/config_data' -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
[DOCS] clarify constraint exclusion vs prepared statements
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.2/static/ddl-partitioning.html Description: Section 5.9.6 of the documentation discusses caveats re use of constraint exclusion on partitioned tables. It seems the restriction that the query constraints must be expressed in terms of constants has been lifted, and now constraints may be expressed in terms of parameterised values. I'm wondering if the restriction would still apply, though, in the case that the query is being prepared in advance, then the constraint value passed in as a parameter at execution time. It seems to me that constraint exclusion would not be applied in this case, but would like clarification on this point. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
[DOCS] release date formatting
It has been pointed out a while ago that the "release date" formatting in the release notes is too flamboyant, more so under the new stylesheets. Here is a patch to make the formatting a bit more subdued. (Obviously, this needs to be expanded to older release notes as well.) -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services 0001-doc-Refine-release-date-formatting.patch Description: invalid/octet-stream -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
