Re: Tablespace with multiple locations

2023-01-03 Thread Peter Eisentraut
On 29.12.22 15:29, PG Doc comments form wrote: I m kindly requesting a clarification regarding a debatable subject in one of my projects, that if it's possible to create one global tablespace and assign many locations like the following example: create tablespace TBS1 location ('/pgdata1','/pgda

Re: Adding visual clues that accesskey exists

2023-01-18 Thread Peter Eisentraut
On 13.01.23 23:07, Corey Huinker wrote: 1. Add static hints to each link, so "Next" becomes "Next [n]". Fairly simple, but visually clumsy, and it might not actually clue the user that they need to hit ALT+n, not just "n". This chrome extension is an example of how it might look https://chrome

Re: Adding visual clues that accesskey exists

2023-01-20 Thread Peter Eisentraut
On 18.01.23 22:49, Corey Huinker wrote: Attached is a patch to add the nav- tags to the header (could just as easily have done the footer) for up/down/left/right and the javascript to find those ids and simulate a click. I've tested this on chrome (where accesskeys work with alt+ ) and firefox

Re: Add missing meson arguments in docs

2023-02-22 Thread Peter Eisentraut
On 22.02.23 02:57, Michael Paquier wrote: -Db_coverage is part of the core options of meson because it is not listed in meson_options.txt, no? Documenting the switch is fine, but it seems like we lack contents here. The paragraph describing -Db_coverage links to regress-coverage, still this onl

Re: Certificate authentication docs in multiple places

2023-03-28 Thread Peter Eisentraut
On 23.03.23 14:33, Steve Atkins wrote: A couple of times recently I’ve been chatting with someone about using certificate authentication, and the docs they’ve found on it are the ones in section 21.12 (Client Authentication -> Certificate Authentication). But the useful documentation about how

Re: confusing positioning of notes in connection settings

2023-04-25 Thread Peter Eisentraut
On 22.04.23 21:53, Jonathan S. Katz wrote: While testing a few other things on the connection settings page[1], I noticed the notes on the "tcp_*" family of settings. While scrolling further down the page, I found myself slightly confused over which note corresponded to which setting (example i

some new glossary entries

2023-05-02 Thread Peter Eisentraut
ary, so I moved things around a bit.From 8ef8a2f08bc4225bfb3528db78e57021d682ec93 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 2 May 2023 08:54:54 +0200 Subject: [PATCH 1/2] doc: New glossary entry "Restartpoint" --- doc/src/sgml/glossary.sgml | 14 ++ 1 file changed, 14 inse

Re: some new glossary entries

2023-05-03 Thread Peter Eisentraut
On 02.05.23 12:55, Daniel Gustafsson wrote: On 2 May 2023, at 12:24, Alvaro Herrera wrote: On 2023-May-02, Daniel Gustafsson wrote: + + LSN + + The other entries doesn't have a glossentry id attribute set, is the use here related to the glossentry.show.acronym param? I debated wi

tables on pgbench man page look garbled

2023-05-09 Thread Peter Eisentraut
The tables "pgbench Operators" and "pgbench Functions" on the pgbench man page (the actual man page, not the HTML reference page) look pretty garbled. Also, on macOS, man prints a warning that the page is invalidly formatted. But the garbledness happens on Linux as well, for example. Apparen

Re: confusing positioning of notes in connection settings

2023-05-31 Thread Peter Eisentraut
On 26.04.23 07:36, Daniel Gustafsson wrote: On 26 Apr 2023, at 10:18, Daniel Gustafsson wrote: On 26 Apr 2023, at 08:08, Peter Eisentraut wrote: I wonder if the notes are even true. The text for tcp_keepalives_interval already says that it is only supported if TCP_KEEPCNT is supported

Re: confusing positioning of notes in connection settings

2023-06-07 Thread Peter Eisentraut
On 05.06.23 19:10, Jonathan S. Katz wrote: On 5/31/23 7:53 AM, Daniel Gustafsson wrote: On 31 May 2023, at 13:16, Peter Eisentraut wrote: The first two hunks are pretty straightforward, they just move the existing text around. For the other two, which are not supported on Windows, I added

Re: confusing positioning of notes in connection settings

2023-06-07 Thread Peter Eisentraut
On 07.06.23 17:34, Jonathan S. Katz wrote: On 6/7/23 11:17 AM, Peter Eisentraut wrote: The proposed text in the patch is "This parameter is supported only on systems that {have this property} (which does not include Windows)." I don't see how the change you are proposing

Re: 3.6 Inheritance Documentation

2023-08-08 Thread Peter Eisentraut
On 02.08.23 21:54, PG Doc comments form wrote: In the provided example, the cities table and the capitals table have a parent-child relationship through inheritance. However, querying the cities table directly (e.g., SELECT name, elevation FROM cities WHERE elevation > 500;) will not automaticall

Re: streaming replication depends on matching glibc versions / LOCALE sort order

2023-08-15 Thread Peter Eisentraut
On 08.08.23 21:05, Dan Stoner wrote: I'm circling back around to this. I've cloned the postgresql git repo and started looking thru doc/src/sgml directory, looking thru the developer FAQ on the wiki, etc. Great! For documentation updates such as this, where would I submit the patch(es)? Is

Re: Replica vs standby

2023-09-06 Thread Peter Eisentraut
On 06.09.23 03:42, Bruce Momjian wrote: There are other cases in our docs where we call something a standby and mean only a physical standby/replica. Should these be clarified? When "hot standby" was added, I argued that it's not really a standby if it's hot. The response was that this is so

Re: Hyperlinks for source file references

2023-09-27 Thread Peter Eisentraut
On 25.09.23 13:09, Daniel Gustafsson wrote: Commit b73c3a11963 introduced xyz hyperlinks for files in the postgres source tree by linking to the gitweb interface at git.postgresql.org. This, IMO, makes the content referred to more accessible, and is especially interesting for README files. The

Re: JSON type unsupported

2023-10-06 Thread Peter Eisentraut
On 26.09.23 17:31, Vik Fearing wrote: For example, we do not have the JSON_SERIALIZE(), JSON()[1], JSON_SCALAR() functions.  We don't have the IS JSON predicate, or a few other things hiding behind T801. AFAICT, commit 03734a7fed, which is new in master, adds exactly those, so maybe we could

Re: T is a mandatory date time separator in RFC3339 but documentation states differently

2023-11-14 Thread Peter Eisentraut
On 14.11.23 19:21, Erik Wienhold wrote: I did not say that occurrences of "ISO 8601" should be replaced with "RFC 3339". Just that the docs should have a cautionary note about the SQL standard using a subset of ISO 8601 and that Postgres does not implement (at the moment) all of its date formats

Re: T is a mandatory date time separator in RFC3339 but documentation states differently

2023-11-15 Thread Peter Eisentraut
On 15.11.23 09:37, Erik Wienhold wrote: On 2023-11-15 08:16 +0100, Peter Eisentraut wrote: The SQL standard does not refer to ISO 8601 to define date formats, it has its own definitions. In fact, PostgreSQL implements more date formats than the SQL standard requires. Really? Then what does

Re: T is a mandatory date time separator in RFC3339 but documentation states differently

2023-11-19 Thread Peter Eisentraut
On 19.11.23 21:34, Erik Wienhold wrote: * Making explicit references to ISO 8601:2004 where section numbers are referenced. Mostly in source comments but also a couple of places in the docs. This is about avoiding confusion as ISO 8601:2019 has been published since then, with different

Re: "name" vs "alias" in datatype table

2023-11-29 Thread Peter Eisentraut
On 23.11.23 21:51, PG Doc comments form wrote: I think there could be some clarification of what is a "name" vs. "alias" on the datatypes table. Right now, what's in the "Aliases" column is sometimes postgres's internal type (e.g. `pg_catalog.int4`), and sometimes the "pretty name", (e.g. `integ

Re: INFORMATION_SCHEMA.routine_column_usage

2023-11-29 Thread Peter Eisentraut
other views are similarly affected. How about this attached patch. From dfe65ace27a5b2e11511e5d929eea356c8ca89e5 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 29 Nov 2023 14:56:41 +0100 Subject: [PATCH] doc: Update info on information schema usage tables Commit f40c6969d0 added the in

Re: INFORMATION_SCHEMA.routine_column_usage

2023-11-30 Thread Peter Eisentraut
On 29.11.23 15:01, Peter Eisentraut wrote: Here https://www.postgresql.org/docs/current/infoschema-routine-column-usage.html <https://www.postgresql.org/docs/current/infoschema-routine-column-usage.html> it is stated that "The view |routine_column_usage| is meant to identify all c

Re: create table explicitly mention that unique|primary key constraint will create an

2024-01-18 Thread Peter Eisentraut
On 27.11.23 03:30, Laurenz Albe wrote: True; I don't find it documented that all objects in pg_class share a namespace and that constraints are implemented by indexes of the same name. But I think that the first part is a property of schemas and had better be documented there. It is documented

Re: create table explicitly mention that unique|primary key constraint will create an

2024-01-31 Thread Peter Eisentraut
On 26.01.24 16:52, Laurenz Albe wrote: On Fri, 2024-01-26 at 19:01 +0530, vignesh C wrote: CFBot shows that the patch does not apply anymore as in [1]: There was a conflict with 46a0cd4cefb. Updated version attached. Sprinkled in some of David's suggestions, and pushed. I was hesitant to bu

Re: create table explicitly mention that unique|primary key constraint will create an

2024-01-31 Thread Peter Eisentraut
On 18.01.24 22:21, David G. Johnston wrote: I started looking at this specific item and immediately got the idea to actually document in user-facing (i.e., not system catalogs) what these object categories are in which object types share the schema namespace. The "Other Object Types" section al

Re: incorrect order? in "D.1. Supported Features" of PostgreSQL 16 manual

2024-02-23 Thread Peter Eisentraut
On 23.02.24 12:23, 小泉 悟 wrote: Upon closer inspection, F305 is also "INTERSECT ALL table operator”. Perhaps F302-02 would be unnecessary. Correct, F302-02 should have been deleted. I have fixed it, thanks. 2024/02/23 18:06、Daniel Gustafsson のメール: On 23 Feb 2024, at 06:36, PG Doc comments

Re: No documentation on how pg_ctl is installed

2024-04-24 Thread Peter Eisentraut
On 23.04.24 14:40, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/app-pg-ctl.html Description: I have used postgresql@14 for several years and have always used pg_ctl to start the postgres server, check st

Re: wal_init_zero / wal_recycle

2024-04-24 Thread Peter Eisentraut
On 24.04.24 10:08, Nicolas Seinlet wrote: while searching the doc to solve an issue, I found the interdependency between those 2 parameters was not obvious. Here: https://www.postgresql.org/docs/14/runtime-config-wal.html#GUC-WAL-INIT-ZERO

Re: The PostgreSQL Select Syntax

2024-05-03 Thread Peter Eisentraut
On 02.05.24 20:08, PG Doc comments form wrote: I'm writing to seek clarification regarding the scope of the formal syntax outlined in the documentation for the SELECT statement (https://www.postgresql.org/account/comments/new/16/sql-select.html/). I understand that this syntax defines the core s

Re: nchar is undocumented

2024-05-06 Thread Peter Eisentraut
On 06.05.24 10:53, Alvaro Herrera wrote: On 2024-May-05, David Rowley wrote: On Sun, 5 May 2024 at 12:41, Erik Wienhold wrote: So, I think we should either remove that one nchar instance (because it doesn't add any real value) or document it properly. The attached patch does the latter. It

Re: Explanations not clear

2024-05-07 Thread Peter Eisentraut
On 06.05.24 19:59, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/collation.html Description: I created a collation specifying the ks-level3 setting and with deterministic set to false. But when I compare

Re: Explanations not clear

2024-05-14 Thread Peter Eisentraut
On 13.05.24 21:10, Jeff Davis wrote: On Wed, 2024-05-08 at 08:52 +0200, Peter Eisentraut wrote: I created a collation specifying the ks-level3 setting and with deterministic set to false. But when I compare "a_b" to "a-b" with this collation I get false. According to the

Avoid too prominent use of "backup" on pg_dump man page

2024-05-29 Thread Peter Eisentraut
0]: https://www.pgevents.ca/events/pgconfdev2024/schedule/session/126-how-postgres-is-misused-and-abused-in-the-wild/From dbf7c0785b9f2ddf85d19f3e41c22c72a600bb66 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 29 May 2024 16:01:26 -0700 Subject: [PATCH] doc: Avoid too prominent use of "b

Re: COALESCE documentation

2024-07-03 Thread Peter Eisentraut
On 02.07.24 12:45, Navrátil, Ondřej wrote: Hello, as per documentation > The |COALESCE| function returns the first of its arguments that is not null. Null is returned only if all arguments are n

Re: Document when ssl_prefer_server_ciphers went in

2024-07-03 Thread Peter Eisentraut
On 03.07.24 11:23, Daniel Gustafsson wrote: In the documentation for ssl_prefer_server_ciphers we only say it's not in "older version" but we omit to specify it further. Since it's a fairly important setting for security I think it makes sense to add the version to help users, as in the small at

Re: tutorial not accurate

2024-07-03 Thread Peter Eisentraut
On 02.07.24 22:00, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-accessdb.html Description: I was able to create a db (mydb) but when I use any of the test SELECT statements, nothing happens. Her

Re: incorrect (incomplete) description for "alter domain"

2024-07-30 Thread Peter Eisentraut
On 29.07.24 17:17, Tom Lane wrote: I wrote: I think the page is technically correct, but I'm inclined to duplicate this text from the CREATE DOMAIN page: where domain_constraint is: [ CONSTRAINT constraint_name ] { NOT NULL | NULL | CHECK (expression) } rather than

Re: Avoid too prominent use of "backup" on pg_dump man page

2024-07-30 Thread Peter Eisentraut
On 31.05.24 10:24, Laurenz Albe wrote: On Thu, 2024-05-30 at 08:21 +0200, Daniel Gustafsson wrote: No objections to using export over backup, but it does make the use of "restore" feel awkward as that's generally an operation on a backup and not an export. -    least one schema/table in the

Re: Incorrect option name for meson build

2024-08-27 Thread Peter Eisentraut
On 26.08.24 09:15, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/catalog-pg-type.html Description: Page: https://www.postgresql.org/docs/16/install-meson.html#CONFIGURE-AUTO-FEATURES-MESON Description: He

Re: DocBook 5.2

2024-09-11 Thread Peter Eisentraut
On 06.09.24 10:50, Jürgen Purtz wrote: For the PG community I would like to raise the question: Do we need DocBook in the distro of any operating system? In the past we developed some stylesheets to adopt DocBook to our needs. They are part of PG's distro and refer to the standard with statemen

Re: Documentation improvement patch

2024-09-11 Thread Peter Eisentraut
On 10.09.24 15:02, Daniel Gustafsson wrote: On 10 Sep 2024, at 13:46, Oleg Sibiryakov wrote: 1. Since we do not want to use here, I suggest we hyphenate it as "built-in". What's your take on it? I think that's the right choice given the hyphenation used in the rest of the docs. There are

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: [DOCS] Docbook 5.x

2017-11-28 Thread Peter Eisentraut
s need to be written differently. You can't use pipes; that would not catch any errors. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

generate.consistent.ids

2017-12-01 Thread Peter Eisentraut
PG10. Patch attached. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services From c03b0f5657d64b457e844a7a6dc49c7a6a7681ae Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 1 Dec 2017 13:30:21 -0500 Subjec

Re: generate.consistent.ids

2017-12-05 Thread Peter Eisentraut
On 12/1/17 13:39, Peter Eisentraut wrote: > I found that the setting > > > > also enables the XSL stylesheets to produce anchors that are consistent > across builds. I would have expected that to increase the build time, > but in my testing the penalty is barely noticeable

Re: [DOCS] Building 10.0 PDFs - fop config

2017-12-05 Thread Peter Eisentraut
27; I have committed this with -Xmx1500M, which seemed to give enough wiggle room. -- 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
m, 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: MacPorts xsltproc is very slow?

2017-12-05 Thread Peter Eisentraut
TPS so > Alice could mess with Bob's documentation. Good point. I have filed a bug about this. -- 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
nd we 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: njobs

2017-12-06 Thread Peter Eisentraut
jobs tables simultaneously" > > The word "tables" is misleading. Suggest removing it. I think the word "tables" is essential for that sentence to be sensible. Why do you think not? -- 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
t; Does 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&#x

Re: Typo

2017-12-12 Thread Peter Eisentraut
ome time ago. Do you see any other 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

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: 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: Typo

2017-12-18 Thread Peter Eisentraut
On 12/12/17 11:26, Peter Eisentraut wrote: > On 12/12/17 07:02, b...@merela.org wrote: >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/10/static/using-explain.html >> Description: >> >> &quo

remove endterms and title ids

2017-12-19 Thread Peter Eisentraut
rious warnings in the FOP build as an incidental benefit.) -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services From 65a26804fb76825f7a98022347aca6a3d17aadb8 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Mon, 19 Ju

Re: remove endterms and title ids

2017-12-27 Thread Peter Eisentraut
the > 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: Element sup in namespace '' encountered in a, but no template matches.

2018-01-05 Thread Peter Eisentraut
matches. > Element sup in namespace '' encountered in a, but no template matches. > Note: Writing man7/CREATE_POLICY.7 It's a stylesheet bug, probably. -- 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 > <mailto:peter.eisentr...@2ndquadrant.com>> wrote: > > On 1/4/18 09:09, PG Doc comments form wrote: > > The following documentation comment has been logged on the we

Re: Regarding built-in logical replication

2018-01-11 Thread Peter Eisentraut
LICATION/SUBSCRIPTION model is possible 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 wou

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 repl

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

Re: overlapping ranges

2018-01-22 Thread Peter Eisentraut
fferently in this respect. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Correction of intermediate certificate handling

2018-01-25 Thread Peter Eisentraut
cert=ssl/client+client_ca.crt"); 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

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: [PATCH] Updating documentation about bulding documentation in Windows.

2018-01-25 Thread Peter Eisentraut
script instead? Using WSL is also a good idea, but then we could just say, use WSL and follow the instructions for the particular Linux distribution. We don't need to repeat all that again. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support,

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 rewrit

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 Sup

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

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

2018-02-03 Thread Peter Eisentraut
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: Pet

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.

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

improve man pages build speed

2018-02-23 Thread Peter Eisentraut
that anyway, so we can save a lot of time by turning this off. (I suppose we'd have to turn it back on if we have have content like that, but we've never had anything like that before, so it doesn't seem particularly pressing.) -- Peter Eisentraut http://www.2ndQuad

Re: Images in the official documentation

2018-02-23 Thread Peter Eisentraut
k. The issue of how to manage the sources is still the same, though. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Images in the official documentation

2018-02-27 Thread Peter Eisentraut
re discussing here. 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: improve man pages build speed

2018-02-28 Thread Peter Eisentraut
On 2/23/18 19:56, Peter Eisentraut wrote: > The attached patch improves the build speed for the man pages on my > system from about 50 seconds to about 15 seconds. > > It looks like the stylesheets are spending a lot of time counting the > links in the man pages so that it ca

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: libpq options

2018-03-06 Thread Peter Eisentraut
chapter and added a bit more in the protocol chapter as well. Committed. -- 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
tml/chunk.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

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

2018-03-28 Thread Peter Eisentraut
ml > > 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,

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: need for SHA3

2018-03-28 Thread Peter Eisentraut
gt; request it? This form is for reporting issues with the documentation. We don't really have a feature request system. If you want it, you need to implement it or find someone to do it. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: create publication descendant tables

2018-03-28 Thread Peter Eisentraut
can't 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: 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 >> > <mailto:peter.eisentr...@2ndquadrant.com>> wrote: >>> Yeah, that looks weird.  I'll look into it. >> >> Just looking at a nearby thread ... some

Re: "IS NOT DOCUMENT" is missing

2018-04-02 Thread Peter Eisentraut
eady has some tests. I'll bet that was an oversight. >> Should we repeat the statement in another item (like the attached >> patch)? Another option is to add a statement in the "IS DOCUMENT" >> item. I'm afraid that NULL return wouldn't be clear. >>

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

2018-04-02 Thread Peter Eisentraut
FOREIGN 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 Eisen

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

2018-04-03 Thread Peter Eisentraut
lly breaks some *other* cases.  It looks correct now. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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
se sections 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 E

Re: authentication methods sections

2018-04-21 Thread Peter Eisentraut
On 4/14/18 17:20, Magnus Hagander wrote: > On Thu, Apr 12, 2018 at 2:37 AM, Peter Eisentraut > <mailto:peter.eisentr...@2ndquadrant.com>> wrote: > > I find that the section authentication methods > <https://www.postgresql.org/docs/devel/static/aut

Re: Request: Revive the security-specific section

2018-05-03 Thread Peter Eisentraut
exist 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.2ndQuadran

updatable cursors and ORDER BY

2018-05-09 Thread Peter Eisentraut
s this 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
d 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: updatable cursors and ORDER BY

2018-06-11 Thread Peter Eisentraut
On 5/28/18 13:17, Bruce Momjian wrote: > On Thu, May 10, 2018 at 12:55:23PM -0400, Tom Lane wrote: >> Peter Eisentraut writes: >>> I think that last part isn't actually written down anywhere. (It only >>> states the converse.) How about a clarification lik

Re: Documented toolchain for building docs on Windows

2018-06-28 Thread Peter Eisentraut
n the > Documentation > appendix (it still lists OpenJade etc). > > I don’t know anything about building on Windows so I might be off, but doesn’t > that need to be updated to match the new toolchain? Yes, I had complained about this before, but nobody responded. I can review a new t

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: \i and \ir separated by \if now...

2018-07-07 Thread Peter Eisentraut
would surely be confused if they don't find \ir after \if. The question is, are they coming to the page to look up \ir, or are they coming there to learn about groups of related commands? Another way to associate \i and \ir is with "see also" type references. -- Peter Eisentraut

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

2018-07-07 Thread Peter Eisentraut
ation 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

  1   2   3   >