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

2023-08-08 Thread Joe Conway
hopefully committed. Once the Commitfest is started (2023-09-01) it is no longer Open for new submissions (I forget the exact state name, but it is In-progress or something similar) -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com

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

2023-06-23 Thread Joe Conway
ree to get examples, etc from the slides: https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf I can also help with wordsmithing and committing the changes once we have them fully baked. -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Servi

Re: [DOCS] Let's document a bytea bug

2020-08-03 Thread Joe Conway
On 8/3/20 4:20 PM, Bruce Momjian wrote: > On Fri, Jul 31, 2020 at 10:13:48AM +0500, Andrey M. Borodin wrote: >> Hi Anna! >> >> > 23 мая 2018 г., в 20:33, Anna Akenteva >> > написал(а): >> > >> > >> > Some time ago I've encountered a problem with the bytea type: we can't >> > SELECT >> > bytea

Re: SET ROLE documentation not entirely correct

2019-08-01 Thread Joe Conway
On 4/27/19 4:02 PM, Joe Conway wrote: > On 4/25/19 11:25 AM, Steven Winfield wrote: >> Again, that's much clearer than what is currently there. It might help >> if some of the language/definitions from pg_has_role() is used, though. >> >> For example: >> A

Re: RESET does not work as described

2019-06-27 Thread Joe Conway
On 6/26/19 11:39 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/bug-reporting.html > Description: > > The initial value returned when current_setting() is passed an unset > parameter is ''. > Afte

Re: graphviz file extension

2019-05-24 Thread Joe Conway
On 5/24/19 3:08 AM, Peter Eisentraut wrote: > It has come to my attention that the preferred file extension for > graphviz files is .gv rather than the .dot we are using. So I propose > to change that for the one file we have so far (gin.dot) before we add > more files in the future. Agreed -- b

Re: Docs for Generated Columns

2019-05-24 Thread Joe Conway
On 5/23/19 5:50 PM, Tobias Bussmann wrote: > while reading though the docs of the upcoming pg12 features, I > stumbled upon some wording regarding generated columns: both in > create_table.sgml [1] and create_foreign_table.sgml [2] the paragraph > for the GENERATED ALWAYS AS clause is introduced wi

Re: SET ROLE documentation not entirely correct

2019-04-27 Thread Joe Conway
On 4/25/19 11:25 AM, Steven Winfield wrote: > Again, that's much clearer than what is currently there. It might help > if some of the language/definitions from pg_has_role() is used, though. > > For example: > A role X is a "MEMBER" of another role Y if there is a chain of GRANTs > from X to Y via

Re: SET ROLE documentation not entirely correct

2019-04-27 Thread Joe Conway
On 4/25/19 5:58 PM, Jonathan S. Katz wrote: > Good news - I did test against an older snapshot. With a newer snapshot, > the SVG on the GIN implementation page[1] is responsive but not the one > on the storage page layout[2], which is what the proposed fix in the > other thread handles. > [2] http

Re: SET ROLE documentation not entirely correct

2019-04-27 Thread Joe Conway
On 4/26/19 3:14 PM, Jonathan S. Katz wrote: > On 4/26/19 3:04 PM, Jonathan S. Katz wrote: >> On 4/25/19 6:54 PM, Joe Conway wrote: >>> On 4/25/19 5:59 PM, Jonathan S. Katz wrote: >>>> On 4/25/19 5:26 PM, Joe Conway wrote: >>>>> >>>>> Is

Re: PL/R points to wrong place

2019-04-27 Thread Joe Conway
On 4/15/19 2:27 PM, Joe Conway wrote: > On 4/15/19 12:41 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/11/external-pl.html >>> Descript

Re: SET ROLE documentation not entirely correct

2019-04-25 Thread Joe Conway
On 4/25/19 5:59 PM, Jonathan S. Katz wrote: > On 4/25/19 5:26 PM, Joe Conway wrote: >> >> Is there any written instruction anywhere with guidance on how the SVGs >> should be made? > > https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=doc/src/sgml/images/

Re: SET ROLE documentation not entirely correct

2019-04-25 Thread Joe Conway
On 4/25/19 5:22 PM, Jonathan S. Katz wrote: > On 4/25/19 4:52 PM, Jonathan S. Katz wrote: >> On 4/25/19 3:20 PM, Joe Conway wrote: >>> On 4/25/19 3:06 PM, Stephen Frost wrote: >>>> Yeah, I'm seeing it cut off in Chrome too, initially, and then it seems >&g

Re: SET ROLE documentation not entirely correct

2019-04-25 Thread Joe Conway
On 4/25/19 3:06 PM, Stephen Frost wrote: > Greetings, > > * Tom Lane (t...@sss.pgh.pa.us) wrote: >> Joe Conway writes: >> > On 4/25/19 1:08 PM, Joe Conway wrote: >> >> There is one image which can be used as an example though: >> >> https://git.

Re: SET ROLE documentation not entirely correct

2019-04-25 Thread Joe Conway
On 4/25/19 1:08 PM, Joe Conway wrote: > There is one image which can be used as an example though: > > https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=doc/src/sgml/storage.sgml;hb=HEAD Here is a more precise URL: https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;

Re: SET ROLE documentation not entirely correct

2019-04-25 Thread Joe Conway
On 4/25/19 12:39 PM, Steven Winfield wrote: >> We *just* very recently added the ability to add images. Not sure I want >> to attempt creating one for this, but perhaps after I write the patch >> you could give it a go with an image to match your thoughts? > > That's great. Is there a page somewhe

Re: SET ROLE documentation not entirely correct

2019-04-25 Thread Joe Conway
On 4/25/19 11:25 AM, Steven Winfield wrote: >> Additionally s/INHERITS/INHERIT/ > > Good spot. > >> The wording should be something like >> >> 8<--- >> The specified role_name must be a role that the current session user is >> a member of directly or indirectly. >> 8<--- > > That

Re: SET ROLE documentation not entirely correct

2019-04-24 Thread Joe Conway
On 4/23/19 11:52 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/sql-set-role.html > Description: > > In the course of trying to sanitise our roles and permissions I found the > notes in the SET ROL

Re: Passphrase protected SSL key and reloads

2019-04-24 Thread Joe Conway
(moved from Hackers to docs) On 1/5/19 4:26 PM, Joe Conway wrote: > On https://www.postgresql.org/docs/11/ssl-tcp.html it says: > > "Using a passphrase also disables the ability to change the server's >SSL configuration without a server restart."

Re: Update section on NFS

2019-04-24 Thread Joe Conway
On 4/24/19 4:54 AM, Peter Eisentraut wrote: > 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 cove

Re: Update section on NFS

2019-04-23 Thread Joe Conway
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 that advice was correct. An async mounted NFS file sy

Re: Update section on NFS

2019-04-23 Thread Joe Conway
On 4/23/19 6:10 AM, Peter Eisentraut wrote: > Attached is a patch that rewrites the section on NFS. The old section > was ancient and didn't seem very helpful. > > AFAIK, the only strict requirement for using NFS with PostgreSQL is the > hard mount. Anything else we should mention? > > I also r

Re: PL/R points to wrong place

2019-04-15 Thread Joe Conway
On 4/15/19 12:41 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/11/external-pl.html >> Description: > >> Project lives >> https://github.com/postgres-plr/plr > > Hey Joe, is this a

Re: dblink_error_message return value

2019-02-17 Thread Joe Conway
On 10/2/18 8:45 AM, Joe Conway wrote: > On 09/25/2018 03:58 PM, Joe Conway wrote: >> On 09/25/2018 01:50 PM, Joe Conway wrote: >>> On 08/08/2018 11:57 AM, Tom Lane wrote: >>>> =?utf-8?q?PG_Doc_comments_form?= writes: >>>>> The following documen

Re: Bug reporting guidelines order of instructions

2019-01-18 Thread Joe Conway
On 1/17/19 9:29 AM, Alvaro Herrera wrote: > On 2019-Jan-17, Magnus Hagander wrote: > >> Per the docs comment today, I will remove the notes about majordomo at >> https://www.postgresql.org/docs/current/bug-reporting.html. >> >> However, this one also suggests email to the pgsql-bugs report as the

Re: dblink_error_message return value

2018-10-02 Thread Joe Conway
On 09/25/2018 03:58 PM, Joe Conway wrote: > On 09/25/2018 01:50 PM, Joe Conway wrote: >> On 08/08/2018 11:57 AM, Tom Lane wrote: >>> =?utf-8?q?PG_Doc_comments_form?= writes: >>>> The following documentation comment has been logged on the website: >>>>

Re: dblink_error_message return value

2018-09-25 Thread Joe Conway
On 09/25/2018 01:50 PM, Joe Conway wrote: > On 08/08/2018 11:57 AM, Tom Lane wrote: >> =?utf-8?q?PG_Doc_comments_form?= writes: >>> The following documentation comment has been logged on the website: >>> Documentation says: >> >>> Return Value >>

Re: dblink_get_result returns NULL if remote query throws error

2018-09-25 Thread Joe Conway
On 09/25/2018 01:06 PM, Joe Conway wrote: > On 09/25/2018 11:41 AM, PG Doc comments form wrote: >> The following documentation comment has been logged on the website: >> >> Page: >> https://www.postgresql.org/docs/9.3/static/contrib-dblink-get-result.html >> De

Re: dblink_error_message return value

2018-09-25 Thread Joe Conway
On 08/08/2018 11:57 AM, Tom Lane wrote: > =?utf-8?q?PG_Doc_comments_form?= writes: >> The following documentation comment has been logged on the website: >> Documentation says: > >> Return Value >> Returns last error message, or an empty string if there has been no error in >> this connection. >>

Re: dblink_get_result returns NULL if remote query throws error

2018-09-25 Thread Joe Conway
On 09/25/2018 11:41 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: > https://www.postgresql.org/docs/9.3/static/contrib-dblink-get-result.html > Description: > > Please consider clarifying this page: > https://www.postgresql.org/do