Re: Shrinking SVG (Again)
So now we have two glossaries being proposed [1] [2], and they don't have much in common with each other. What to do now? If we can get the authors to agree on what patch to submit, we can move forward. I suggest to make a glossary be 0001, and then the other patches can be 0002 or further. Yes, we should work on the glossary with priority because other things depend on it, not only the explanation of figures. The two proposals differs in their nature: [1] is focused on PG-specific terms like WAL, Background Writer, Background Worker, ... and such terms that are broadly used but may differ from the meaning in other DBMS like Segment or Data Dictionary. It's only a starting point. Currently it misses the terms of important features like MVCC, Backup, Replication, ... . [2] also contains fundamental terms but is focused on universal terms of the DBMS community like SELECT, Null, Rollback, ... . It's important to check, whether the existing documentation starts with something like "A is a ...". In my opinion such redundancies aren't a problem as long as they don't contradict each other. On the contrary, I support this approach. J. Purtz
Re: PDF doc build is broken on recent Fedora
Hello Tom, 13.02.2020 23:37, Tom Lane wrote: > By chance I tried to build our PDF docs on a Fedora 30 > installation, and it doesn't work. xsltproc seems to > get hung up in a tight loop before it starts to produce > any output. The HTML build works fine, though. > > Relevant package versions: > > docbook-style-xsl-1.79.2-9.fc30.noarch > libxslt-1.1.33-1.fc30.x86_64 > > Anybody seen this, or have an idea what to poke at? I've just reproduced this on Fedora 29, 30, 31. On Fedora 29 I see almost the same package versions: docbook-style-xsl-1.79.2-8.fc29.noarch libxslt-1.1.33-1.fc29.x86_64 But it's not reproduced on Fedora 28, where I have: docbook-style-xsl-1.79.2-7.fc28.noarch libxslt-1.1.32-2.fc28.x86_64 I will explore this further... Best regards, Alexander
Re: PDF doc build is broken on recent Fedora
15.02.2020 12:09, Alexander Lakhin wrote: > I've just reproduced this on Fedora 29, 30, 31. > On Fedora 29 I see almost the same package versions: > docbook-style-xsl-1.79.2-8.fc29.noarch > libxslt-1.1.33-1.fc29.x86_64 > > But it's not reproduced on Fedora 28, where I have: > docbook-style-xsl-1.79.2-7.fc28.noarch > libxslt-1.1.32-2.fc28.x86_64 > > I will explore this further... It seems Peter was here first: https://gitlab.gnome.org/GNOME/libxslt/issues/16 Best regards, Alexander
the date() function is undocumented while quite necessary
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-datetime.html Description: I can't find anywhere the documentation of the SQL DATE() function which extracts the date part out of a timestamp. Please note that according to my tests, one can't use the cast operator when defining expression-based indexes, while the date(column) expression is accepted. It makes the DATE() function way more useful than one may think.
Re: the date() function is undocumented while quite necessary
PG Doc comments form writes: > I can't find anywhere the documentation of the SQL DATE() function which > extracts the date part out of a timestamp. It's a type cast written in function-like syntax, as documented in https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-TYPE-CASTS We don't really encourage that notation, because it's confusing and it doesn't work for every possible type name, which is why you won't find it mentioned very many places. > Please note that according to my tests, one can't use the cast operator when > defining expression-based indexes, while the date(column) expression is > accepted. You can if you put parentheses around it: regression=# create table t1 (f1 timestamp); CREATE TABLE regression=# create index on t1 (f1::date); ERROR: syntax error at or near "::" LINE 1: create index on t1 (f1::date); ^ regression=# create index on t1 ((f1::date)); CREATE INDEX This is per the restriction explained in the CREATE INDEX docs, that any expression-to-be-indexed that doesn't look like a function call requires parentheses. https://www.postgresql.org/docs/current/indexes-expressional.html https://www.postgresql.org/docs/current/sql-createindex.html regards, tom lane
Re: PDF doc build is broken on recent Fedora
Alexander Lakhin writes: > It seems Peter was here first: > https://gitlab.gnome.org/GNOME/libxslt/issues/16 Indeed. Looks like I need to pester Fedora to absorb that fix. Thanks for doing the research! regards, tom lane
