Does TRUNCATE emit changes with REPLICA IDENTITY FULL?

2019-11-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-truncate.html Description: Hi, The documentation says that TRUNCATE ignores ON DELETE triggers, but it doesn't explicitly mention what happens if we use `wal_level = logical` and

Re: Does 'instead of delete' trigger support modification of OLD

2019-11-11 Thread Liudmila Mantrova
> 8 нояб. 2019 г., в 0:26, Bruce Momjian написал(а): > > First, notice "only", which was missing from the later sentence: > >For INSERT and UPDATE >operations [only], the trigger may modify the >NEW row before returning it. > > which I have now added with my applied patch to all

Re: The word "virgin" used incorrectly and probably better off replaced

2019-11-11 Thread Tom Lane
Alvaro Herrera writes: > One problem with doing it that way is that the proposed parenthical > comment partly duplicates the text immediately following it, so I'm no > longer so sure that adding it is good; I think that changing "local > additions" to "local additions and changes" might be

Re: The word "virgin" used incorrectly and probably better off replaced

2019-11-11 Thread Alvaro Herrera
On 2019-Nov-08, Tom Lane wrote: > Alvaro Herrera writes: > > On 2019-Nov-08, Tom Lane wrote: > >> So the patch becomes s/virgin/pristine/g plus add a parenthetical > >> definition for the first use? Works for me. > > > Well, there are three uses of the word "virgin". The first is for > >