Re: Clarify how triggers relate to transactions

2021-07-30 Thread Tom Lane
Laurenz Albe writes: > On Wed, 2021-04-28 at 13:24 +0200, Laurenz Albe wrote: >> On Tue, 2021-04-27 at 14:26 +, PG Doc comments form wrote: >>> If I understand correctly, it would be helpful to add this sentence or a >>> corrected version of it: "Triggers always execute in the same transaction

Re: [PATCH] add link to domain data types section from locale documentation

2021-07-30 Thread Tom Lane
Laurenz Albe writes: > On Fri, 2021-07-23 at 23:07 +0200, Jürgen Purtz wrote: >> Done at the proposed pages - and a few more. > Looks good to me - changed to "ready for committer". Pushed with a bit of editorialization: * I removed the glossary entry for "Domain (Internet)". AFAICS we have not

Re: Common case not at all clear

2021-07-30 Thread Anthony Berglas
OK, I'll put something for you to review. Most programmers simply ignore locking and wonder why it sometimes goes wrong. On Fri, Jul 30, 2021 at 2:22 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jul 29, 2021 at 8:44 PM Anthony Berglas > wrote: > >> My point is that while

Re: Common case not at all clear

2021-07-30 Thread Anthony Berglas
My point is that while I can follow the academic style discussion, most of my colleagues could not. They just need to have a clear idea of how to handle the common case, which is to use a database using some programming language. Early on, for Read Committed, it should discuss and ideally provide

documentation describing the range of a number type 'integer' is incorrect

2021-07-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-numeric.html Description: https://www.postgresql.org/docs/13/datatype-numeric.html says that the range of a numeric type integer is -2147483648 to +2147483647 but PGTYPESnumeric_t

Re: getting table name from partition

2021-07-30 Thread Pavel Stehule
Hi pá 30. 7. 2021 v 0:24 odesílatel Bruce Momjian napsal: > On Wed, Jul 14, 2021 at 01:45:12PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/13/ddl-partitioning.html > > Description: > > >