Re: TOC: List of Figures

On 7/2/19 4:43 AM, Daniel Gustafsson wrote: >> On 2 Jul 2019, at 10:13, Jürgen Purtz wrote: > >> After the integration of figures into the documentation it may be helpful to >> extent the TOC with a 'List of Figures'. Any opinion? > > +1, I think we should. +1 > >> The alternative is a downs

Re: TOC: List of Figures

On 7/8/19 4:21 PM, Daniel Gustafsson wrote: >> On 8 Jul 2019, at 22:10, Tom Lane wrote: > >> let's wait till there's a >> meaningful number of figures and then reconsider whether there's use in >> a list of them. It's not like it will be any harder to make that change >> in a year or two than it

Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]

On 7/10/19 6:13 AM, David Harper wrote: >> I actually agree with your opinion that "midnight" is fine. >> That text has been that way for over fifteen years[1], and >> nobody's complained before that it was ambiguous. > > Conversely, how many users over the past fifteen years have read that table,

Re: Formatting of warning about using ident

On 7/22/19 10:09 AM, Tom Lane wrote: > Peter Eisentraut writes: >> In general, I would argue in favor of fewer "note", "warning", etc. >> Some documentation pages are now just a sequence of "note"s and little >> proper text. If the normal text properly explains a topic and its pros >> and cons, t

Re: Release notes on "reserved OIDs"

On 9/4/19 11:11 AM, Tom Lane wrote: > I'm planning to make a pass over the release notes soon, and will > update this one when I get to it. -list (figured it was off topic but apropos) -- Bruce had reached out to me offlist that he is about to be traveling and may need to have someone else look o

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

On 10/2/19 7:39 AM, Chris Travers wrote: > > > On Wed, Oct 2, 2019 at 12:57 PM Erikjan Rijkers > wrote: > > On 2019-10-02 12:46, Peter Eisentraut wrote: > > On 2019-10-02 10:21, Magnus Hagander wrote: > >> Exactly. Both might be accurate, but one comes with a

Re: Update documentation - include supported windows version for release 12

On 10/17/19 3:12 AM, Michael Paquier wrote: > On Tue, Oct 15, 2019 at 11:56:38AM +0200, Emil Iggland wrote: >> PostgreSQL 12 has been released and is available for download from the >> EnterpriseDB website. >> The documentation should be updated to reflect the supported versions. >> Attached patch

Re: legacy assumptions

Hi, On 11/25/19 12:47 PM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/datatype-json.html > Description: > > I'm wondering if this one line of section 8.14 JSON Types > (https://www.postgresql.org/d

Re: Postgres.js driver - for Node.js

On 1/8/20 3:06 PM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > I recently finished a fast, 0 dependency driver for Node.js with a very user > friendly api. Congratulations! > I think would be great to include in the documentation and the W

Re: Postgres.js driver - for Node.js

On 1/8/20 7:00 PM, Jonathan Buhacoff wrote: > I'm wondering if the short list in the documentation [2] could be > replaced with a link to the corresponding wiki page [1] ? >> [1] https://wiki.postgresql.org/wiki/List_of_drivers#Drivers >> [2] https://www.postgresql.org/docs/current/external-interf

Re: Postgres.js driver - for Node.js

On 1/8/20 7:59 PM, Tom Lane wrote: > "Jonathan S. Katz" writes: >> On 1/8/20 7:00 PM, Jonathan Buhacoff wrote: >>> I'm wondering if the short list in the documentation [2] could be >>> replaced with a link to the corresponding wiki page [1] ? > >&g

Listing Drivers in the Docs (was: "Re: Postgres.js driver - for Node.js")

Hi, For this first round, going to truncate a bit of Stephen's thoughts (sorry Stephen) just to cover where we are at: On 1/9/20 12:00 PM, Stephen Frost wrote: > Greetings, > > * Jonathan S. Katz (jk...@postgresql.org) wrote: >> On 1/8/20 7:59 PM, Tom Lane wrote: >>&

Re: Documentation: 21.5. Default Roles

On 2/3/20 3:42 PM, Bruce Momjian wrote: > On Thu, Jan 23, 2020 at 07:12:08PM -0500, R Ransbottom wrote: >> On Mon, Jan 20, 2020 at 12:23:48PM +0900, Ian Barwick wrote: >>> On 2020/01/19 12:56, R Ransbottom wrote: >> I would hope to find correct documentation somewhere--that somewhere >> >>> In

Re: Documentation: 21.5. Default Roles

On 2/4/20 3:34 AM, Magnus Hagander wrote: > On Mon, Feb 3, 2020 at 9:59 PM Jonathan S. Katz wrote: >> So, if there was something done to redirect people from specific >> deprecated documentation pages historically, it was before my time. Most >> of the redirects have bee

Re: Documentation: 21.5. Default Roles

On 2/6/20 12:11 AM, Bruce Momjian wrote: > On Tue, Feb 4, 2020 at 11:31:19AM -0500, Jonathan Katz wrote: >>> Using this feature to handle the rename of a file *between* major >>> versions, thus leaving the changes in master, should be safe (as long >>> as we add an entry to that table in pgweb). >

Re: Duplicating website's formatting in local doc builds

On 2/11/20 1:37 PM, Tom Lane wrote: > I'm wondering how to do $SUBJECT. The fine manual suggests > > make STYLE=website html > > but what I'm getting here with that is not a very close approximation > of what I see at postgresql.org. It's closer than the default, > but it's not the same f

Re: Duplicating website's formatting in local doc builds

On 2/11/20 1:37 PM, Tom Lane wrote: > I also wonder why duplicating the website's style isn't the default. > Doesn't seem like having authors optimize for some other style is > what we really want. Oh, and specifically for this, my guess is because it requires one to make a call over a network to

Re: Duplicating website's formatting in local doc builds

On 2/11/20 2:32 PM, Tom Lane wrote: > "Jonathan S. Katz" writes: >> On 2/11/20 1:37 PM, Tom Lane wrote: >>> I also wonder why duplicating the website's style isn't the default. >>> Doesn't seem like having authors optimize for some o

Re: Duplicating website's formatting in local doc builds

On 2/11/20 3:41 PM, Peter Geoghegan wrote: > On Tue, Feb 11, 2020 at 11:40 AM Jonathan S. Katz > wrote: >> Anyway, attached is a first attempt at a patch. I tried a few different >> variations but in my quick review of it, I could not figure out how to >> make a XSLT

Re: Duplicating website's formatting in local doc builds

On 2/11/20 3:49 PM, Jonathan S. Katz wrote: > On 2/11/20 3:41 PM, Peter Geoghegan wrote: >> On Tue, Feb 11, 2020 at 11:40 AM Jonathan S. Katz >> wrote: >>> Anyway, attached is a first attempt at a patch. I tried a few different >>> variations but in my quick rev

Re: Duplicating website's formatting in local doc builds

On 2/11/20 10:56 PM, Jonathan S. Katz wrote: > On 2/11/20 3:49 PM, Jonathan S. Katz wrote: >> On 2/11/20 3:41 PM, Peter Geoghegan wrote: >>> On Tue, Feb 11, 2020 at 11:40 AM Jonathan S. Katz >>> wrote: >>>> Anyway, attached is a first attempt at a patch.

Re: Duplicating website's formatting in local doc builds

On 2/12/20 8:15 AM, Jonathan S. Katz wrote: > On 2/11/20 10:56 PM, Jonathan S. Katz wrote: >> On 2/11/20 3:49 PM, Jonathan S. Katz wrote: >>> On 2/11/20 3:41 PM, Peter Geoghegan wrote: >>>> On Tue, Feb 11, 2020 at 11:40 AM Jonathan S. Katz >>>> wrote: &g

Re: Duplicating website's formatting in local doc builds

On 2/14/20 6:06 PM, Tom Lane wrote: > "Jonathan S. Katz" writes: >> To load the webfont, the "main.css" file uses a CSS "@import" >> instruction, which has a limitation that it can only be used as the top >> of the file. As main.css is not the fi

Re: Duplicating website's formatting in local doc builds

On 2/14/20 8:56 PM, Peter Geoghegan wrote: > On Fri, Feb 14, 2020 at 5:51 PM Tom Lane wrote: >> Hm, I wouldn't go into that much detail; it'd likely soon be out of >> date anyway. I had in mind something more like "If the STYLE=website >> option is used, the generated HTML files will include refe

Re: Documentation: 21.5. Default Roles

On 4/9/20 4:57 PM, Bruce Momjian wrote: > On Thu, Feb 6, 2020 at 10:59:09AM -0500, Jonathan Katz wrote: >> On 2/6/20 12:11 AM, Bruce Momjian wrote: >>> On Tue, Feb 4, 2020 at 11:31:19AM -0500, Jonathan Katz wrote: > Using this feature to handle the rename of a file *between* major > versi

Re: pre-requiste for installation

On 4/12/20 8:21 AM, Ankush Chawla wrote: > hi  > > what is the pre-requiste packages for Postgres Installation on SUSE Linux > > I have already transferred .run file > > What would be pre-requiste package, hardware or software requirements , > any readme available? I believe these are listed on

Re: Developer FAQ / What information is available to learn PostgreSQL internals?

On 4/16/20 4:20 AM, Marc Rechté wrote: > > https://wiki.postgresql.org/wiki/Developer_FAQ > > This link is dead: introduction to Hacking PostgreSQL - With lots of > code review! > https://linux.org.au/conf/2007/att_data/Miniconfs(2f)PostgreSQL/attachments/hacking_intro.pdf It appears that is has

Re: PDF documentation bug: different table columns overlap and are unreadable

On 4/17/20 3:37 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/index.html > Description: > > In the PDF documentation, some table columns overflow and overlap with the > next column. This makes the

Re: Documentation: 21.5. Default Roles

address, i.e. the new page. If it is, we issue a 301 (permanent redirecTt). - If it's still not found, we abort. I believe this gives us the desired behavior. Thoughts on the patch? Thanks, Jonathan From e2120f0a80697d13dc6d951f363d01feb60c9b9d Mon Sep 17 00:00:00 2001 From: "Jonathan S

Re: List of pages from versions 9, 10, and 11 that don't exist in "current"

On 4/25/20 1:12 PM, Michael Christofides wrote: > Hi there, > > Does anyone have an easy way of seeing which pages from the 9.x, 10, > or 11 docs don't have a "current" version? I don't have an easy way, but I have a pedantic way: 1. Set up the pgweb app[1] 2. Set up the requirements for the doc

Re: Documentation: 21.5. Default Roles

On 4/28/20 2:19 PM, Magnus Hagander wrote: > On Sat, Apr 25, 2020 at 1:38 AM Jonathan S. Katz <mailto:jk...@postgresql.org>> wrote: > > On 4/9/20 11:45 PM, Bruce Momjian wrote: > > On Thu, Apr  9, 2020 at 08:47:56PM -0400, Jonathan Katz wrote: > >>

Re: Another modest proposal for docs formatting: catalog descriptions

On 5/4/20 9:52 PM, Tom Lane wrote: > As of HEAD, building the PDF docs for A4 paper draws 538 "contents > ... exceed the available area" warnings. While this is a nice step > forward from where we were (v12 has more than 1500 such warnings), > we're far from done fixing that issue. > > A large ch

Re: Another modest proposal for docs formatting: catalog descriptions

On 5/5/20 7:42 PM, Tom Lane wrote: > Here's a really quick-n-dirty prototype patch that just converts the > pg_aggregate table to the proposed style, plus a screenshot for those > who don't feel like actually building the docs with the patch. Not opposed to building the docs, but the screenshot ex

Re: Another modest proposal for docs formatting: catalog descriptions

On 5/6/20 5:18 PM, Alvaro Herrera wrote: > Hello > > I think the recent changes to CSS might have broken things in the XSLT > build; apparently the SGML tooling did things differently. Compare the > screenshot of tables 67.2 and 67.3 ... 9.6 on the left, master on the > right. Is the latter form

Re: Another modest proposal for docs formatting: catalog descriptions

On 5/10/20 12:27 PM, Tom Lane wrote: > Just FTR, here's a complete patch for this. Cool. I'll play around with it tonight once I clear out release work. Per upthread reference, I believe you've become a CSS maven yourself. > I successfully regenerated > the column names, types, and ordering from

Re: Another modest proposal for docs formatting: catalog descriptions

On 5/10/20 2:03 PM, Jonathan S. Katz wrote: > On 5/10/20 12:27 PM, Tom Lane wrote: >> Just FTR, here's a complete patch for this. > > Cool. I'll play around with it tonight once I clear out release work. > Per upthread reference, I believe you've become a CSS ma

Re: Another modest proposal for docs formatting: catalog descriptions

On 6/1/20 6:57 PM, Tom Lane wrote: > =?UTF-8?B?Sm9zZWYgxaBpbcOhbmVr?= writes: >> I have spotted this change recently at progress monitoring devel docs ( >> https://www.postgresql.org/docs/devel/progress-reporting.html#CREATE-INDEX-PROGRESS-REPORTING). >> Current version seems a little chaotic sinc

Re: Version 13 documentation layout is harder to read than version 12

On 9/29/20 3:00 PM, Tom Lane wrote: > Niels Andersen writes: >> 2. Is there a middle ground? >> * Version 12 had 6 columns, version 13 has one. >> * Could we have fewer columns? What if we had 3 columns: One for >> operator or function, one for the details and description, and on

Re: Possible Example Error in Documentation

On 11/5/20 7:37 PM, Tom Lane wrote: > PG Doc comments form writes: >> The following documentation comment has been logged on the website: >> Page: https://www.postgresql.org/docs/12/plpgsql-transactions.html >> Description: > >> We are using Postgres 12. When I use the example given for >> transa

Re: link may be broken

On 12/4/20 5:39 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/index.html > Description: > > Hello, > > the following page: > > https://www.postgresql.org/about/featurematrix/detail/340/ > > con

Re: The sub-categories do not have anchors on this page

On 12/17/20 10:11 AM, David G. Johnston wrote: > On Thu, Dec 17, 2020 at 8:01 AM Bruce Momjian > wrote: > > On Thu, Dec 10, 2020 at 05:59:15PM -0300, Álvaro Herrera wrote: > > On 2020-Dec-10, Steven Pousty wrote: > > > > > They certainly do at the top of t

Re: scram-sha-256 authentication

On 1/4/21 12:04 PM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/auth-password.html > Description: > > How do you encode a plain password to the corresponding SCRAM-SHA-256 > encryption? Using online

Re: Update to reflect that TLS1 and TLSv1.1 are now deprecated

On 3/24/21 5:49 AM, Daniel Gustafsson wrote: > The recently published RFC 8996 deprecates the use of TLSv1 and TLSv1.1, the > attached rewords where we say our default of 1.2 is industry best practice > with > a link to the authoritative source. I would s/as of/stated in/ and add a comma after RF

Re: Documentation: 21.5. Default Roles

On 4/1/21 3:34 PM, Stephen Frost wrote: > Greetings, > > * Stephen Frost (sfr...@snowman.net) wrote: >> I've written a patch to begin to make this change and sent it into >> -hackers for comments, thread is here: >> >> https://postgr.es/m/20201120211304.gg16...@tamriel.snowman.net > > Just to wr

Re: Documentation: 21.5. Default Roles

On 4/2/21 9:11 AM, Stephen Frost wrote: > Greetings, > > * Jonathan S. Katz (jk...@postgresql.org) wrote: >> Thanks Stephen! Do we have any additional follow up on the pgweb side? > > Yes and no. :) > > Once the next set of minor releases is pushed out, I'll d

Re: mingw.org fails to load anything of value

On 4/3/21 7:01 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/installation-platform-notes.html > Description: > > 16.7.4. MinGW/Native Windows refers to the site http://www.mingw.org which > for me

Re: mingw.org fails to load anything of value

On 4/4/21 9:30 AM, Jonathan S. Katz wrote: > On 4/3/21 7:01 AM, PG Doc comments form wrote: >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/13/installation-platform-notes.html >> Description: >>

Re: mingw.org fails to load anything of value

On 4/4/21 9:30 PM, Michael Paquier wrote: > On Sun, Apr 04, 2021 at 09:47:08AM -0400, Jonathan S. Katz wrote: >> Diving deeper while updating the links, I stumbled across this note: >> >> "The MinGW.org web‑site is undergoing an overhaul, whilst in the process >>

Re: Link t the souce code

On 5/6/21 6:05 PM, Tom Lane wrote: > Alvaro Herrera writes: >> I agree -- if the user wanted packages, they would not be reading that >> page of the docs. I'd just have it point to the same page that the >> download page points to for source downloads, not a version-specific >> one, as in the att

Re: pgpool: APPARENT DEADLOCK!!! Complete Status: Managed Threads: 3 Active Threads: 3

Hi Moin, On 5/18/21 3:30 AM, Moin Akther wrote: > Dear Team, > >   > > We are facing issue whenever application is connecting to pgpool 4^th Node. This email address is for contributing to the PostgreSQL documentation[1]. The Pgpool project provides contact information on reporting issues here

Re: failed to connect to PostgreSQL server on "db01:5432" using INET socket

Hi, On 5/24/21 12:45 AM, Moin Akther wrote: > Dear Team, > >   > > We are getting below error logs from pgpool. > >   > > May 18 07:48:31 pgpool[22685]: [7-1] 2021-05-18 07:48:31: pid 22685: > LOG: failed to connect to PostgreSQL server on "db01:5432" using INET socket > May 18 07:48:31 pgpool

Re: Git is not an acronym

On 6/10/21 7:40 AM, Daniel Gustafsson wrote: > Commit 651377933e031 cleaned up references to CVS replacing them with Git. > Replacing CVS with Git in acronyms.sgml seems a bit incorrect though as Git > isn't an acronym (but CVS is, hence the original item replaced). We also > never > refer to Git

Re: Use of the word master

On 8/5/21 2:26 PM, Dave Cramer wrote: > PostgreSQL: Documentation: 13: 30.1. Publication > > > > "A /publication/ can be defined on any physical replication master." > > I would propose "any physical replication prima

Re: I came here to determine how much storage a boolean variable uses

On 8/30/21 11:31 AM, David G. Johnston wrote: > On Sun, Aug 29, 2021 at 11:59 PM PG Doc comments form > mailto:nore...@postgresql.org>> wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/datatype.html >

Re: ORDER BY in materialized view example?

On 11/23/21 12:44 PM, Tom Lane wrote: Peter Eisentraut writes: On 23.11.21 07:18, Maciek Sakrejda wrote: An example in the materialized view documentation [1] includes an ORDER BY clause without a clear reason. Does it help build the index more efficiently? I suppose it's also sort of like a C

Re: Add TypeScript driver

On 1/4/22 2:40 AM, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/external-interfaces.html Description: Hi. I am Eray Hanoglu, author of postgresql-client javascript driver written in TypeScript (https://w

Re: missing a white space in the last sentence of 51.6. Executor

On 1/17/22 2:02 PM, Tom Lane wrote: PG Doc comments form writes: The last sentence of 51.6. Executor appears: "...feeding that up toModifyTable to perform the insertion." Hm, the space is definitely there in the source file: A simple INSERT ... VALUES command creates a trivial plan

documentation on HOT

Hi, While working on the 2020-02-10 release announcement, in order to better describe one of the fixes, I tried to find a reference in the docs that described what HOT is, how it works, etc. in a user-friendly manner. This lead me to the acronyms page[1], which lead me to a document in the r

Re: documentation on HOT

On 2/6/22 8:56 PM, David G. Johnston wrote: On Sun, Feb 6, 2022 at 6:08 PM Jonathan S. Katz <mailto:jk...@postgresql.org>> wrote: Given the importance of HOT, it seems like this would be a good topic to document. I would suggest something higher-level for general users i

Re: Should we really recommend "-A md5 or -A password"?

On 5/31/22 8:35 AM, Magnus Hagander wrote: On Tue, May 31, 2022 at 2:29 PM Daniel Westermann (DWE) > wrote: Hi, I just came across this: "Also, specify -A md5 or -A password so that the default trust authentication mode is not used;

Re: Can we still dump version 7?

On 5/31/22 10:55 AM, Tom Lane wrote: "Daniel Westermann (DWE)" writes: I guess this statement is not true anymore? "Current releases of the dump programs can read data from any server version back to 7.0." https://www.postgresql.org/docs/current/upgrading.html Ugh, missed that, thanks for sp

Re: Can we still dump version 7?

On 5/31/22 12:21 PM, Tom Lane wrote: "Jonathan S. Katz" writes: On 5/31/22 10:55 AM, Tom Lane wrote: I wonder whether we should update this or just remove it --- it's clearly something that's likely to get missed again. While burdensome, +1 for updating. We don't

Re: documentation on HOT

On 7/22/22 8:51 AM, Bruce Momjian wrote: On Thu, Jul 21, 2022 at 10:02:18PM -0400, Bruce Momjian wrote: On Sun, Feb 6, 2022 at 09:29:56PM -0500, Jonathan Katz wrote: I agree with Bruce's point that we should have a new section (or subsection). As I mentioned in my previous post, given HOT invo

Re: Search engine linking to latest docs

On 7/25/22 6:08 PM, Trevor Gross wrote: Hey all, I think the PG community is pretty aware that there are some issues with search engines taking users to the right versions of the docs. You google something simple like "postgres drop column" and the first postgresql.org

Re: pl Lua

On 10/17/22 6:03 AM, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/external-pl.html Description: Your page, https://www.postgresql.org/docs/15/external-pl.html Please include another, active Lua binding

Re: Usability ideas: text width and headers that are links

Hi, Thanks for the suggestions. Comments inline: On 10/21/22 9:54 AM, Niels Bom wrote: Hi! I have 2 small ideas to improve the usability of the PostgreSQL documentation. I'm looking at v15 (1) mostly. Idea 1: Give the text width of the main content a max width. Why? Can you please provide

Re: No multi range functions on version 12

On 12/15/22 6:46 AM, Magnus Hagander wrote: On Thu, Dec 15, 2022 at 12:45 PM PG Doc comments form mailto:nore...@postgresql.org>> wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/rangetypes.html

<    1   2