[DOCS] CREATE SEQUENCE minvalue for descending sequence
Hello, while reading your documentation about create sequence I found that you mention the minvalue for a descending sequence is -263-1. But as far as I know the minvalue of long is -263+1. The mentioned documentation is at: https://www.postgresql.org/docs/9.6/static/sql-createsequence.html
[DOCS] Default names for CRL and CA files in the backend
Commit a445cb92ef5b3a31313ebce30e18cc1d6e0bdecb removed the default names for serverside CRL and CA files, but the defaults were left in the "SSL Server File Usage” table with a small note. I completely missed the note, even after having been fiddling about with the code in question. Removing the filenames from the table, and altering the note per the attached patch, makes the docs clearer IHMO. cheers ./daniel ca_crl_files.patch Description: Binary data -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Default names for CRL and CA files in the backend
On Thu, Aug 17, 2017 at 7:31 AM, Daniel Gustafsson wrote: > Commit a445cb92ef5b3a31313ebce30e18cc1d6e0bdecb removed the default names for > serverside CRL and CA files, but the defaults were left in the "SSL Server > File > Usage” table with a small note. I completely missed the note, even after > having been fiddling about with the code in question. Removing the filenames > from the table, and altering the note per the attached patch, makes the docs > clearer IHMO. Here are additional notes on the matter. From libpq.sgml: In some cases, the client certificate might be signed by an intermediate certificate authority, rather than one that is directly trusted by the server. To use such a certificate, append the certificate of the signing authority to the postgresql.crt file, then its parent authority's certificate, and so on up to a certificate authority, root or intermediate, that is trusted by the server, i.e. signed by a certificate in the server's root.crt file. Am I reading that correctly? The last sentence should not mention root.crt as well. The paragraph after that assume that ssl_ca_file is set to root.crt so it looks fine to use it. But that's not assumed here. In sslinfo.sgml: This function is really useful only if you have more than one trusted CA certificate in your server's root.crt file, or if this CA has issued some intermediate certificate authority certificates. In runtime.sgml: Note that the server's root.crt lists the top-level CAs that are considered trusted for signing client certificates. In principle it need not list the CA that signed the server's certificate, though in most cases that CA would also be trusted for client certificates. Perhaps this should be changed as well. In config.sgml: In previous releases of PostgreSQL, the name of this file was hard-coded as root.crt. [...] In previous releases of PostgreSQL, the name of this file was hard-coded as root.crt. Why not mentioning the version of Postgres where the change has begun? I find confusing not to precise such level of details. -- Michael -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Dead link for 'DocBook XSL Stylesheets'
On 8/10/17 15:50, [email protected] wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.6/static/docguide-toolsets.html > Description: > > Hi, > > This link is dead. The DocBook wiki was moved to GitHub. The correct link is > now https://github.com/docbook/wiki/wiki/DocBookXslStylesheets. This has been fixed in PostgreSQL 10. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] CREATE SEQUENCE minvalue for descending sequence
On Wed, Aug 16, 2017 at 10:00 PM, Klemens Eisenstecken wrote: > Hello, > > while reading your documentation about create sequence I found that you > mention the minvalue for a descending sequence is -2^63-1. > > But as far as I know the minvalue of long is -2^63+1. > > The mentioned documentation is at: > https://www.postgresql.org/docs/9.6/static/sql-createsequence.html Logically the minimum value of long is -2^63, the maximum being 2^63 - 1, but as you say the default minvalue of a descending sequence is -2^63 + 1, so the docs are wrong. Note that Postgres has changed this idiotic minimal value behavior in 10, using now the real minimum value of the types used with a sequence. -- Michael createseq-docfix.patch Description: Binary data -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
