Re: [DOCS] Docbook 5.x

2017-11-23 Thread Peter Eisentraut
On 11/15/17 16:06, Peter Eisentraut wrote: > Here is the final patch set for the conversion. I have committed this. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: State which instances must have "wal_level=logical" in Logical Replication in Postgres 10

2017-12-16 Thread Peter Eisentraut
instances that must have wal_level = > logical > defined. That is explained in the section before the one you are looking at. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Is PQgetResult() guaranteed to return the whole SQL command result?

2017-12-13 Thread Peter Eisentraut
the number of result sets. But the relationship should always be deterministic. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Replication parameters in recovery.conf

2017-12-05 Thread Peter Eisentraut
e are trying to get rid of it (by moving these settings to postgresql.conf, mostly). So I don't think we need to spend a lot of time rationalizing this at this point. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Flex is not a GNU package

2017-12-05 Thread Peter Eisentraut
them, be sure > to get Flex 2.5.31 or later and > committed -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Potentially misplaced "we trust"

2017-12-12 Thread Peter Eisentraut
es this sentence mean that every correct plan will *in most cases* > output > the same row set? Or something different altogether? This is a slightly silly way of saying, if the code is correct, then every plan will output the same set of rows. I think it's OK to leave it like that. -- Peter E

Re: Typo

2017-12-12 Thread Peter Eisentraut
numbers in the next that don't match the EXPLAIN output? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

updatable cursors and ORDER BY

2018-05-09 Thread Peter Eisentraut
s note outdated? A brief look into history of CheckSelectLocking() suggests that it might never have been correct. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: updatable cursors and ORDER BY

2018-05-10 Thread Peter Eisentraut
to be updatable, or the + DECLARE command will error if an updatable cursor + cannot be created for the supplied query. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Request: Revive the security-specific section

2018-05-03 Thread Peter Eisentraut
in every aspect of the system. So as a user when I'm dealing with operating system integration, or schema design, or backups, or replication, or monitoring, etc., then I want to know about the security concerns on that subject. -- Peter Eisentraut http://www.2ndQuadrant.com/ Pos

Re: remove endterms and title ids

2017-12-27 Thread Peter Eisentraut
docbooc-xsl dir. But these are sections inside ref pages, so they don't have numbers. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: J.2. Tool Sets/Appendix J. Documentation missing package

2018-01-05 Thread Peter Eisentraut
.3 Debian Packages > > "docbook" and "dbtopub" missed in install command. > > make world works after above to package installed. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: J.2. Tool Sets/Appendix J. Documentation missing package

2018-01-05 Thread Peter Eisentraut
On 1/5/18 16:38, Magnus Hagander wrote: > On Fri, Jan 5, 2018 at 7:18 PM, Peter Eisentraut > <peter.eisentr...@2ndquadrant.com > <mailto:peter.eisentr...@2ndquadrant.com>> wrote: > > On 1/4/18 09:09, PG Doc comments form wrote: > > The following docu

Re: overlapping ranges

2018-01-20 Thread Peter Eisentraut
rst of > the month, which will cause conflicts. The last date needs to be the final > day of the same month. I don't think so, because the upper bound of the range is not included in the range. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Suppo

Re: typo: overlay

2018-01-19 Thread Peter Eisentraut
gt; > in the overlay example, there should only be 'xxx' instead of ''. (the > 'xxx' is being replaced with 'hom'.) The example correctly illustrates that the replacement string does not have to have the same length as the string being replaced. -- Peter Eisentraut

Re: Correction of intermediate certificate handling

2018-01-25 Thread Peter Eisentraut
quot;); test_connect_fails($common_connstr, "sslmode=require sslcert=ssl/client.crt"); If you change the Makefile rule for generating the client CA to omit the -extensions v3_ca option, then the first test will fail. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL D

Re: Can take filesystem bkp of pg data folder when server is running

2018-01-25 Thread Peter Eisentraut
omething I am missing here? It might work sometimes, especially if you are trying it on a dummy setup, but it's not going to work in general. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Regarding built-in logical replication

2018-01-11 Thread Peter Eisentraut
ible between different PostgreSQL > versions, which is only possible using pglogical. The documentation is correct. (The only caveat is that there are currently no other versions than 10 that have built-in logical replication, but if there were any, it would work.) -- Peter Eisentraut

Re: removal of md5 from example code

2018-01-30 Thread Peter Eisentraut
oving the password column from this example or replacing the > md5 hash with something more secure (a secure hash algorithm with a salt). We don't have any other hash functions built in and exposed at the SQL level. (Maybe that is a problem.) Do you have any other ideas how to rewrite tha

Re: [DOCS] list of credits for release notes

2018-02-02 Thread Peter Eisentraut
On 10/3/17 03:16, Alexander Lakhin wrote: > While working on translation I've found a wrong name in credits: > Fakhroutdinov Evgenievich That's how the name was entered in bug #14682. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remo

Re: [DOCS] list of credits for release notes

2018-02-03 Thread Peter Eisentraut
On 2/3/18 00:08, Alexander Lakhin wrote: > Hello, > 03.02.2018 00:56, Peter Eisentraut wrote: >> On 10/3/17 03:16, Alexander Lakhin wrote: >>> While working on translation I've found a wrong name in credits: >>> Fakhroutdinov Evgenievich >> That's how the na

Re: Update encryption options doc for SCRAM-SHA-256

2018-02-03 Thread Peter Eisentraut
ion items, because I don't want to go into the details of how SCRAM works on the wire. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services From 34eff9bd65ca051c3ba173476e3f9360ee0d51b9 Mon Sep 17 00:00:00 2001 From: Peter Eise

Re: Pushing btree opclass implementor's docs to the main SGML docs

2018-02-06 Thread Peter Eisentraut
latter would make more sense if anyone was inspired to > write something comparable in length to the existing per-index-type > chapters. But I'm not volunteering to do that, so if it's a chapter it'd > be a mighty thin one to start with. xindex seems better to me. -- Peter Eis

Re: removal of md5 from example code

2018-02-22 Thread Peter Eisentraut
oving the password column from this example or replacing the > md5 hash with something more secure (a secure hash algorithm with a salt). This has been fixed in the master branch. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: how to modify the navfooter

2018-08-14 Thread Peter Eisentraut
quot;magic incantations" are that generate this > navfooter? This comes from the DocBook XSL stylesheets. The stuff in stylesheet.xsl and similar is just a customization layer on top of those. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

semi-dead ibm.com links

2018-08-14 Thread Peter Eisentraut
All but one of the links at the end of <https://www.postgresql.org/docs/11/static/installation-platform-notes.html#INSTALLATION-NOTES-AIX> redirect to some generic documentation home page. Anyone care enough to find updated locations? -- Peter Eisentraut http://www.2ndQuadra

Re: Dead link to hp docs

2018-08-14 Thread Peter Eisentraut
I have committed the proposed changes now. We can substitute better links when we have them, but for now we don't appear to have any. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Release note trimming: another modest proposal

2018-08-09 Thread Peter Eisentraut
a lot of downloads. Why not go further and just ship the release notes of the current major version. If you want to look at the release notes of version 11, read the documentation for version 11. Who reads the documentation of version 12 to get the release notes of version 11? -- Peter Eisentraut

Re: Correction for 9.6 documentation for OpenBSD

2018-07-15 Thread Peter Eisentraut
nt the setup of popular packages in the main documentation, but we currently don't, and we would have to do it more consistently across platforms. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: uncommon syntax in datatype.sgml

2018-07-17 Thread Peter Eisentraut
On 16.07.18 20:42, Liudmila Mantrova wrote: > I have noticed uncommon English syntax in datatype.sgml, with two full > sentences following a colon in the same paragraph. I don't understand what's wrong with that. -- Peter Eisentraut http://www.2ndQuadrant.com/ Post

Re: bad url in docs

2018-09-06 Thread Peter Eisentraut
hp.com seem to have gone away on or about 28Aug2018. > They also fall under the heading of HP OpenVMS Systems Doc which may explain > why they've disappeared. This has already been fixed in git and will be in the next minor releases. Thanks. -- Peter Eisentraut http://www.2nd

Re: Documentation of pg_index.indcollation missing some info in older versions?

2018-07-07 Thread Peter Eisentraut
gt; collation to use for the index, or zero if the column is not of a collatable > data type." It's a standard convention in the PostgreSQL system catalogs that OID zero means "none". There are likely many places where this is not explicitly documented. -- Peter Eisentraut

Re: Documented toolchain for building docs on Windows

2018-07-13 Thread Peter Eisentraut
On 29.06.18 18:51, Daniel Gustafsson wrote: >> On 29 Jun 2018, at 15:08, Peter Eisentraut >> wrote: >> >> On 6/28/18 13:19, Daniel Gustafsson wrote: >>> Unless someone steps up before 11 is rolled, maybe builddoc.pl should be >>> made >>> into

Re: Blanks in the first line before the first word in the code boxes

2018-04-04 Thread Peter Eisentraut
tml > > If you search for "WITH RECURSIVE search_graph(id, link, data, depth)” > the expression in the CTE is much more indented than similar CTEs above > it. This was that way in the source. Probably originally 8-space tabs. I've fixed it now. -- Peter Eisentraut

authentication methods sections

2018-04-11 Thread Peter Eisentraut
ctions up one level in the hierarchy so they end up on separate HTML pages. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services From ef0ffbfae26a344310cd710c1249b0a8018bccee Mon Sep 17 00:00:00 2001 From: Peter Eisent

Re: Blanks in the first line before the first word in the code boxes

2018-03-28 Thread Peter Eisentraut
On 3/28/18 21:30, Peter Eisentraut wrote: > On 3/23/18 08:56, Daniel Westermann wrote: >> is it only me who sees blanks before the first word in the first line of >> the code boxes, e.g. here: >> >> https://www.postgresql.org/docs/9.6/static/sql-createtable.html >>

Re: Blanks in the first line before the first word in the code boxes

2018-03-28 Thread Peter Eisentraut
reatetable.html > > For the devel documentation it is fine: > https://www.postgresql.org/docs/devel/static/sql-createtable.html > > Tested in Firefox and Chrome. Yeah, that looks weird. I'll look into it. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

Re: Blanks in the first line before the first word in the code boxes

2018-03-28 Thread Peter Eisentraut
On 3/28/18 21:36, Jonathan S. Katz wrote: > >> On Mar 28, 2018, at 9:32 PM, Peter Eisentraut >> <peter.eisentr...@2ndquadrant.com >> <mailto:peter.eisentr...@2ndquadrant.com>> wrote: >>> Yeah, that looks weird.  I'll look into it. >> >>

Re: create publication descendant tables

2018-03-28 Thread Peter Eisentraut
be added) and inheritance roots (which can). > 2.) Will it only work on current descendants or will it also work on > future descendants? only current -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: MacPorts xsltproc is very slow?

2018-03-28 Thread Peter Eisentraut
hunk.xsl"/> > + href="https://cdn.docbook.org/release/xsl-nons/current/xhtml/chunk.xsl"/> That would affect those who are currently relying on catalog entries redirecting the old URLs to their local copy. I think we will at least need to wait for a new release with new catal

Re: Blanks in the first line before the first word in the code boxes

2018-04-02 Thread Peter Eisentraut
IGN TABLE [ IF EXISTS ] [ ONLY ] ... (with a line break) but before it looks like ... ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] ... (without a line break). So maybe some part of the processing code thinks it should do some kind of "indentation" here. -- Peter Eisentraut

Re: "IS NOT DOCUMENT" is missing

2018-04-02 Thread Peter Eisentraut
. >> > > Patch applied and backpatched to Postgres 10. Thank.s Per the nearby discussion, this should probably also be backpatched further. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Fix links to pg_stat_replication and definition of checkpoint_warning GUC

2018-03-03 Thread Peter Eisentraut
> think the word "checkpoint" is unnecessary here. I tried to rephrase > this definition in fix_checkpoint_warning_definition_doc.patch. This was more appropriate when the related parameter was called checkpoint_segments, but now it indeed seems confusing. Also fixed. -- Peter Eisent

Re: Images in the official documentation

2018-02-27 Thread Peter Eisentraut
Certainly more so then some-person-on-github's latest idea for how to convert ASCII art into diagrams. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Documented toolchain for building docs on Windows

2018-06-29 Thread Peter Eisentraut
On 6/28/18 13:19, Daniel Gustafsson wrote: > Unless someone steps up before 11 is rolled, maybe builddoc.pl should be made > into a exit immediately no-op since "nothing" is better than “broken”? I'm thinking, just delete the file and the documentation section. --

Re: tables (and other objects) are automatically put into a schema named "public"

2018-11-12 Thread Peter Eisentraut
xamples and says "by default". I don't think the statement is incorrect or inappropriate. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Broken link in Appendix H.3

2018-12-07 Thread Peter Eisentraut
PL/Py > is broken. Specifically, the link shown is > http://python.projects.postgresql.org/backend/, which redirects to > http://python.projects.pgfoundry.org/backend/ and returns 404. I don't know > what the correct link should be, if any. This was already removed in the PostgreSQL 10 docume

Re: bad url in docs

2018-09-13 Thread Peter Eisentraut
On 07/09/2018 01:27, Tom Lane wrote: > Peter Eisentraut writes: >> On 07/09/2018 00:58, PG Doc comments form wrote: >>> Page: https://www.postgresql.org/docs/10/static/libpq-ssl.html >>> Version 10 >>> The pointers off to hp.com seem to have gone away on

Re: Responsive images in pgweb docs

2019-04-04 Thread Peter Eisentraut
, presumably for the reasons you identified inside the SVG code. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services From e2647f228f7cb4b553e858b61a0e86f7740b627e Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Th

Re: First SVG graphic

2019-03-28 Thread Peter Eisentraut
On 2019-03-28 01:50, Tom Lane wrote: > Peter Eisentraut writes: >> This has been committed. The SVG images are committed as well, so no >> new tools are required. > > Buildfarm member alabio seems less than pleased. See <https://askubuntu.com/questions/695560/assist

Re: First SVG graphic

2019-03-28 Thread Peter Eisentraut
w, let's see if it recovers. > > > FYI, it did recover. Per above, I think this is something we should > document.  It seems like this is a Debian/Ubuntu-specific packaging issue. We could document it, but I wonder if it's just a transient thing. -- Peter Eisentraut http

Re: Responsive images in pgweb docs

2019-04-01 Thread Peter Eisentraut
screen. Is that better? > > Yes - we can control how much of the screen the image will take up with > the Bootstrap grid CSS classes, which is what the patch on the pgweb > side does. How do you do it outside of Bootstrap? -- Peter Eisentraut http://www.2ndQuadrant.com/

Re: Responsive images in pgweb docs

2019-04-01 Thread Peter Eisentraut
bile. Image scaling is currently intentionally disabled for the HTML output (see ignore.image.scaling in stylesheet-html-common.xsl). But if we turn it on, then the images will automatically be huge if you have large screen. Is that better? -- Peter Eisentraut http://www.2nd

Re: First SVG graphic

2019-03-14 Thread Peter Eisentraut
of the tools ... The portability is not something I'm concerned about, but Ditaa requires Java, so that might annoy some people. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: First SVG graphic

2019-03-14 Thread Peter Eisentraut
else we'll forever > be fighting silly markup errors. That's not a productive use of > anybody's time. Let me rephrase: I'm agree that portability is important, and I'm confident that the tools in question are portable enough. -- Peter Eisentraut http://www.2ndQuadrant.com/ Post

Re: First SVG graphic

2019-03-11 Thread Peter Eisentraut
to proceed in this direction. (We can have some discussion about whether we want to commit the intermediate SVG files and what the directory layout should be etc. I didn't bother with that in my patch yet.) -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development

Re: First SVG graphic

2019-03-08 Thread Peter Eisentraut
How do you get from the Inkscape SVG files to the what you call "optimized SVG" files? I loaded the gin_inkscape.svg file into Inkscape, saved it back out as "Plain SVG", but the resultant file did not look at all similar to the existing gin.svg. -- Peter Eisentraut

Re: First SVG graphic

2019-02-08 Thread Peter Eisentraut
uate > it in deep. If it is an urgent problem (I have seen that the > commitfest-entry is tagged as "release 12") we shall shift the pg_dump > figure to a later release. The problem is that images don't show up in man pages, so we can't put any images in there, or it w

Re: First SVG graphic

2019-02-07 Thread Peter Eisentraut
for IDs. (At some point, underscores where not allowed. I'm surprised that that's no longer the case.) I also wouldn't put "_svg" into the ID. The format is irrelevant to the ID. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: First SVG graphic

2019-01-25 Thread Peter Eisentraut
On 24/01/2019 00:53, Bruce Momjian wrote: > This is a pretty complicated issue with a lot of back-story. I am > thinking Tatsuo or me will probably commit it before March. Isn't that all the more reason to add it to the commitfest? -- Peter Eisentraut http://www.2ndQuadra

Re: Update to equivalent SQL in 8.1.4. Serial Types

2019-04-08 Thread Peter Eisentraut
ld start with > the line > > CREATE SEQUENCE tablename_colname_seq AS INTEGER; fixed -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Docs for Generated Columns

2019-05-27 Thread Peter Eisentraut
d review. Please find attached my proposed > little doc patch for this issue. committed -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: SQL-2016 in docs

2019-06-03 Thread Peter Eisentraut
On 2019-05-30 16:34, Oleg Bartunov wrote: > On Mon, May 27, 2019 at 2:33 PM Peter Eisentraut > wrote: >> >> On 2019-05-12 10:14, Oleg Bartunov wrote: >>> I noticed that in our docs for PG12 there is no SQL-2016, but we actually >>> have JSON Path implementati

Add XSL stylesheet to fix up SVG files

2019-06-11 Thread Peter Eisentraut
generated by Graphviz. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services From d60477ca234f761c5a3509f31b975576f63564ca Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 11 Jun 2019 11:49:21 +0200 Sub

Re: Add XSL stylesheet to fix up SVG files

2019-06-19 Thread Peter Eisentraut
On 2019-06-11 13:19, Peter Eisentraut wrote: > Commit 29046c44f36099f4c979b1491fcf27db2f9184f9 manually edited the SVG > file generated by Ditaa, which was kind of what we wanted to avoid > having to do. Here is an automated way to take care of the same thing, > by using an XSL

Re: SQL-2016 in docs

2019-05-14 Thread Peter Eisentraut
re the patch ? I have now updated the feature list to SQL:2016. All the SQL/JSON-related features are currently set to "NO". Please propose patches to update that. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Formatting of warning about using ident

2019-06-26 Thread Peter Eisentraut
you want to change it to a warning box, then you also need to rephrase the surrounding text. But I don't really see the need. It seems fine as it is. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: TOC: List of Figures

2019-07-07 Thread Peter Eisentraut
ould you use them for? Who goes to the documentation (or any other book-like material) thinking, I'm in the mood to look at some tables today, let's see what's in them. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: TOC: List of Figures

2019-07-08 Thread Peter Eisentraut
eover, we had an image for every topic. Then learning by just flipping through the images would be interesting. But we are not nearly there yet. Promoting a list of images now would just make those looking for that kind of learning sad. -- Peter Eisentraut http://www.2ndQua

Update section on NFS

2019-04-23 Thread Peter Eisentraut
file systems can be added more easily. Can anyone suggest some succinct advice on what file systems are supported on Windows (see XXX in the patch)? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Update section on NFS

2019-04-23 Thread Peter Eisentraut
On 2019-04-23 13:00, Martín Marqués wrote: > Didn''t read the proposed patch, but would like to point out that I > would also add that it has to be mounted without file attribute caching. Why? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 S

Re: Update section on NFS

2019-04-23 Thread Peter Eisentraut
On 2019-04-23 16:15, Joe Conway wrote: > On 4/23/19 9:47 AM, Peter Eisentraut wrote: >> On 2019-04-23 14:31, Joe Conway wrote: >>> Looks like you dropped the advice WRT the asynchronous mount option. >>> Isn't that is still relevant? >> >> I don't think tha

Re: Update section on NFS

2019-04-23 Thread Peter Eisentraut
On 2019-04-23 14:31, Joe Conway wrote: > Looks like you dropped the advice WRT the asynchronous mount option. > Isn't that is still relevant? I don't think that advice was correct. An async mounted NFS file system will flush data on fsync, which is what one wants. -- Peter Eise

Re: Update section on NFS

2019-04-24 Thread Peter Eisentraut
On 2019-04-23 18:53, Tom Lane wrote: > Peter Eisentraut writes: >> On 2019-04-23 16:15, Joe Conway wrote: >>> I don't think so. Not sure if you have an account at Red Hat, but this >>> ticket covers it: >>> https://access.redhat.com/solutions/48199 > >

Re: Update section on NFS

2019-04-26 Thread Peter Eisentraut
On 2019-04-26 09:41, Thomas Munro wrote: > Those options are Linux-specific -- maybe just say so? committed with that change -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Formatting of warning about using ident

2019-07-22 Thread Peter Eisentraut
On 2019-07-01 13:48, Daniel Gustafsson wrote: >> On 26 Jun 2019, at 15:09, Peter Eisentraut >> wrote: >> >> On 2019-06-14 10:47, Daniel Gustafsson wrote: >>> The warning about using ident for authorization or access control is using a >>> with an

Re: Do not use C++ style comments (// comments). Strict ANSI C compilers do not accept them.

2019-09-26 Thread Peter Eisentraut
On 2019-09-25 00:13, Tom Lane wrote: > Peter Eisentraut writes: >> PostgreSQL 12 requires C99, so those guidelines should probably be >> rephrased from "because old compilers don't accept it" to "because we >> like it that way". > > Yeah, or more

Re: I'm surprised to see the word master here

2019-10-02 Thread Peter Eisentraut
t probably not all that much -- but > there can certainly be cases where nearby langaugae also has to be > changed to make it work properly. But I have a hard time seeing it as > being a *huge* undertaking. I find this proposal to be dubious and unsubstantiated. Do we need to get rid of &q

Use proper em and en dashes

2019-10-19 Thread Peter Eisentraut
L commands). -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services From 953847e5d5ead9987e29817c75a2a6ae990befd7 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sat, 19 Oct 2019 18:43:18 +0200 Subject: [PATCH] doc:

Re: doc correction

2019-10-29 Thread Peter Eisentraut
"a generated column" for easier reading The current wording seems more precise. It's the expression that does the referencing, not the column itself. There could be other things attached to a column to could reference other things or not. -- Peter Eisentraut http://w

Re: Use proper em and en dashes

2019-10-25 Thread Peter Eisentraut
On 2019-10-19 18:54, Peter Eisentraut wrote: > Here is a patch to make more use of and in the docs, > instead of the plain ASCII "-". I think this is nicer to read in some > cases and in other cases makes the appearance consistent with the text > generated by the Do

Re: I'm surprised to see the word master here

2019-09-24 Thread Peter Eisentraut
that word from our > docs ? $ git grep -w master | wc -l 611 You might be thinking of "slave". -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Do not use C++ style comments (// comments). Strict ANSI C compilers do not accept them.

2019-09-24 Thread Peter Eisentraut
le being preferred to // style since I'm > not entierly convinced postgres compiles on C89 anyways. PostgreSQL 12 requires C99, so those guidelines should probably be rephrased from "because old compilers don't accept it" to "because we like it that way". -- Peter Eisentraut

Re: Fix contributor name-related inconsistencies in release-12.sgml

2019-09-24 Thread Peter Eisentraut
hese individuals use when posting to these mailing lists, in whichever order they prefer. So as far as I'm concerned, the forms listed in the release notes for PG10 and PG11 are canonical and should continue to be used. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: I'm surprised to see the word master here

2019-09-25 Thread Peter Eisentraut
Is > that only the case when they appear in tandem? Again, you might be confusing this. I don't recall any such initiative nor do I see any commits to that effect. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: I'm surprised to see the word master here

2019-10-09 Thread Peter Eisentraut
be banned. In which case that would certainly propagate to the web site, the wiki, other nearby resources, some of which certainly do use that term liberally in various configurations. So we should think that through regardless. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL De

Re: Link to "Upgrading a PostgreSQL Cluster" in Release Notes

2020-01-09 Thread Peter Eisentraut
probably no big extra effort to do other supported branches as well. Committed to 12, 11, 10. After that the patch didn't apply anymore and nobody should be upgrading to that anyway. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Link to "Upgrading a PostgreSQL Cluster" in Release Notes

2020-01-03 Thread Peter Eisentraut
. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: optionally schema-qualified for table_name

2020-03-25 Thread Peter Eisentraut
the example. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: An XSLT example script

2020-04-23 Thread Peter Eisentraut
On 2020-04-21 21:04, Bruce Momjian wrote: On Tue, Apr 21, 2020 at 08:10:09PM +0200, Peter Eisentraut wrote: On 2020-04-14 10:03, Jürgen Purtz wrote: The example "XSLT Stylesheet for Converting SQL/XML Output to HTML" is tagged as , but it isn't a figure, it's an example scri

Re: Rendering pi more nicely in PDF

2020-04-29 Thread Peter Eisentraut
e packages for this. We should write instructions for this in any case. (With this you can undo the other patches discussed here and just write and it should look correctly.) -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training &

Re: Documentation: 21.5. Default Roles

2020-04-29 Thread Peter Eisentraut
shipped with the name as it did, and users know it as such. If we start retroactively renaming all functionality when we change our mind, it will create complete madness. New ideas belong into the master branch. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development

Re: Rendering pi more nicely in PDF

2020-04-29 Thread Peter Eisentraut
into the built PDF. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Additional Chapter for Tutorial

2020-04-29 Thread Peter Eisentraut
be hands-on, how do you get started, how do you get some results. Your material is more of an overview of the whole system. What's a new user supposed to do with that? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training

Re: An XSLT example script

2020-04-21 Thread Peter Eisentraut
r examples, figures and tables and shows it in the wrong list. We should change the tagging. Why is it wrong to make this a figure? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Add A Glossary

2020-05-19 Thread Peter Eisentraut
On 2020-05-19 08:17, Laurenz Albe wrote: The term "cluster" is unfortunate, because to most people it suggests a group of machines, so the term "instance" is better, but that ship has sailed long ago. I don't see what would stop us from renaming some things, with

Re: documentation pdf build fail (HEAD)

2020-03-24 Thread Peter Eisentraut
, but other processors don't necessarily require it. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: optionally schema-qualified for table_name

2020-03-24 Thread Peter Eisentraut
for this then. The same criticism applies to the documentation patch, I think. We don't usually make the schema part explicit. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Adding xreflable

2020-05-22 Thread Peter Eisentraut
see and which are both sect2s in the same chapter, then you get a rendered text of see Section 24.1.1 and autovacuum which is bizarre. If you want the link appearance to change only in the release notes, then the right approach is to use the tag, as was done before. -- Peter Eise

Re: Change JOIN tutorial to focus more on explicit joins

2020-09-04 Thread Peter Eisentraut
that one of them is unprofessional and then leave it at that and give no further guidance. I think we should leave this out. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

  1   2   >