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

Hi! On Wed, Oct 2, 2019 at 8:06 AM Stephen Frost wrote: > > > I know that I tend towards primary/replica when discussing physical > replication, and we do that quite a bit in the documentation (consider > https://www.postgresql.org/docs/11/warm-standby.html where we seem to be > pretty confused

"DROP INDEX" correction

Hello people! I'm new to this place and this is obviously my first message to you guys. I've been using PostgreSQL for years now, deeply like it and I came to a point when I wish to give some of this love back. :) So; I'm reaching out this mailing list - hopefully the right one - because we foun

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

> On Wed, Oct 2, 2019 at 8:59 AM Selena Deckelmann wrote: Hi! > Whoa! That was a long time ago. Welcome back! :) Hi! On Wed, Oct 2, 2019 at 8:06 AM Stephen Frost wrote: > >> >> >> I know that I tend towards primary/replica when discussing physical >> replication, and we do that quite a bit

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

On 2019-10-02 10:21, Magnus Hagander wrote: > Exactly. Both might be accurate, but one comes with a lot less baggage. > > I support a search and replace.  > > I think it'll take a bit more than just a simple "sed script to > replace", if that's what you mean. But probably not all that much --

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

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 lot less baggage. I support a search and replace.  I think it'll take a bit more than just a simple "sed script to replace", if that's what you me

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

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 lot less > >> baggage. > >> > >> I support a search and replace. > >> > >> I think i

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: I'm surprised to see the word master here

On Wed, Oct 2, 2019 at 3:10 PM Jonathan S. Katz wrote: > 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

WITH RECURSIVE (Documentation section 7.8.1) Note

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/queries-with.html Description: In section 7.8.1, the author comments "Note: Strictly speaking, this process is iteration not recursion, but RECURSIVE is the terminology chosen by the SQL

Pls mention ERROR: 2D000: cannot commit while a subtransaction is active on this page

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html Description: Please add a note after this sentence “A transaction cannot be ended inside a block with exception handlers.” (at the bottom of the page) thus: << I

Re: WITH RECURSIVE (Documentation section 7.8.1) Note

PG Doc comments form writes: > In section 7.8.1, the author comments "Note: Strictly speaking, this process > is iteration not recursion, but RECURSIVE is the terminology chosen by the > SQL standards committee." I think I'm to blame for that wording. > Example: R_2 = F(F(R_0)) > Example: R_5 =

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

Greetings, * Magnus Hagander (mag...@hagander.net) wrote: > On Wed, Oct 2, 2019 at 3:10 PM Jonathan S. Katz > wrote: > > 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 E

Re: "DROP INDEX" correction

Hi Oto, On Wed, Oct 02, 2019 at 09:55:14AM +0200, Oto Brglez wrote: > I suggest that you add a statement/explanation under Parameters > > CONCURRENTLY that would say something like > > "DROP INDEX with CONCURRENTLY can only accept one index." > > I hope that this message will be helpful to someo