Re: Lack of detailed documentation

2020-04-22 Thread Tom Lane
"David G. Johnston" writes: > It is basically treating the points as if they were a representation of > complex numbers with x being real and y being imaginary. Hah! I was too focused on looking for definitions involving vectors, and didn't think of plain ol' complex numbers. But yes, that's ex

Re: Lack of detailed documentation

2020-04-22 Thread David G. Johnston
On Wed, Apr 22, 2020 at 4:36 PM Tom Lane wrote: > Surely Lockhart[1] got this > definition from someplace, though, and didn't invent it out of thin air. > I actually viewed quite a few YouTube math videos between then and now and looking at it now it seems familiar. It is basically treating the

Re: Lack of detailed documentation

2020-04-22 Thread David G. Johnston
On Wed, Apr 22, 2020 at 5:18 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Apr 22, 2020 at 4:36 PM Tom Lane wrote: > >> One thing that surprised me is that I couldn't find any well-known >> name for what the * and / operators are doing; digging around on >> the net and in so

Re: Lack of detailed documentation

2020-04-22 Thread David G. Johnston
On Wed, Apr 22, 2020 at 4:36 PM Tom Lane wrote: > One thing that surprised me is that I couldn't find any well-known > name for what the * and / operators are doing; digging around on > the net and in some dusty old math textbooks didn't yield any exact > matches. I ended up adding footnotes wit

Re: Lack of detailed documentation

2020-04-22 Thread Tom Lane
I wrote: > One thing that's sort of blocking any real progress on this is the > draconian space constraints imposed by the tabular format, which is > hurting us on a lot of these pages, not just this one. Alvaro did > some preliminary investigation towards finding a better way, > but nobody's trie

Re: Logical replication subscription owner

2020-04-22 Thread Tom Lane
Alvaro Herrera writes: > I had it in my mind that LOGIN was for regular (SQL-based) login, and > REPLICATION was for replication login, and that they were orthogonal. Yeah, that's what I would've expected. Otherwise, is REPLICATION without LOGIN useful at all? regards, t

Re: Logical replication subscription owner

2020-04-22 Thread Alvaro Herrera
On 2020-Apr-22, Stephen Frost wrote: > * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: > > I wonder if a better answer is to allow the connection when the > > REPLICATION priv is granted, ignoring the LOGIN prov. > > Erm, no, I wouldn't have thought that'd make sense- maybe someone > specifica

Re: terminology in example

2020-04-22 Thread Bruce Momjian
Patch applied back to 9.5, thanks. --- On Wed, Apr 1, 2020 at 08:27:59PM -0400, Bruce Momjian wrote: > On Wed, Apr 1, 2020 at 08:37:30AM +0200, Laurenz Albe wrote: > > On Tue, 2020-03-31 at 19:10 -0400, Bruce Momjian wrot

Add that changing the `argname` will raise exception in procedure/function

2020-04-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-createprocedure.html Description: In https://www.postgresql.org/docs/12/sql-createprocedure.html you can add: "It is also not possible to change the argname. Trying to do so will raise

Re: Logical replication subscription owner

2020-04-22 Thread Stephen Frost
Greetings, * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: > On 2020-Apr-15, PG Doc comments form wrote: > > If the logical replication subscription is owned by a role that is not > > allowed to login (for example, if the LOGIN privilege is removed after the > > subscription is created) then th

Re: Logical replication subscription owner

2020-04-22 Thread Alvaro Herrera
On 2020-Apr-15, PG Doc comments form wrote: > If the logical replication subscription is owned by a role that is not > allowed to login (for example, if the LOGIN privilege is removed after the > subscription is created) then the logical replication worker (which uses the > owner to connect to the

filter with json_agg(DISTINCT table.*) behaves differently

2020-04-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/release-10-7.html Description: Following is our finding: Postgres query behaves differently in 2 version Specifically (json_agg(DISTINCT table_name.*) filter(where table_name is not

Document format issues: characters are overlapping in the header of some tables

2020-04-22 Thread Rui Hai Jiang
Hello,  I'm reading this document PostgreSQL 12.2 Documentation(postgresql-12-A4.pdf) which I've downloaded from the official website www.postgresql.org. I found some format issues with the table headers in these pages, 1159,1160,1161,1162,1163,1164. In the table headers, some characters are o