Re: getting table name from partition

2021-08-03 Thread Bruce Momjian
On Thu, Jul 29, 2021 at 06:24:17PM -0400, Bruce Momjian wrote: > 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: > >

Re: Another pg_dump using split and gzip for large databases

2021-08-03 Thread Bruce Momjian
On Thu, Jul 29, 2021 at 03:10:34PM -0400, Bruce Momjian wrote: > On Thu, Jul 29, 2021 at 07:15:21PM +0200, Daniel Gustafsson wrote: > > > On 29 Jul 2021, at 17:29, Bruce Momjian wrote: > > > > > > On Thu, Jul 29, 2021 at 05:23:20PM +0200, Daniel Gustafsson wrote: > > >>> On 29 Jul 2021, at 16:58,

Re: psql's commit df9f599b is not documented

2021-08-03 Thread Stephen Frost
Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > Dave Cramer writes: > > I would agree. If it's worth coding it's worth documenting. Unless of > > course the intention is that this is temporary. > > Documenting it would mean committing to keeping it indefinitely, > which I think was exactly w

Re: psql's commit df9f599b is not documented

2021-08-03 Thread Tom Lane
Dave Cramer writes: > I would agree. If it's worth coding it's worth documenting. Unless of > course the intention is that this is temporary. Documenting it would mean committing to keeping it indefinitely, which I think was exactly what people didn't want to do. It's a kluge and we might find o

Re: psql's commit df9f599b is not documented

2021-08-03 Thread David G. Johnston
On Tuesday, August 3, 2021, Dave Cramer wrote: > > > I would also argue that putting them in the release notes is not enough. > Am I expected to go through the release notes after I don't find it in the > documentation ? > No > Do we have other undocumented features ? > > Yes, while rare, deci

Re: psql's commit df9f599b is not documented

2021-08-03 Thread Dave Cramer
On Mon, 2 Aug 2021 at 20:56, Bruce Momjian wrote: > On Mon, Aug 2, 2021 at 05:24:14PM -0700, David G. Johnston wrote: > > On Mon, Aug 2, 2021 at 5:03 PM Bruce Momjian wrote: > > > > > > I think we put it in the PG 11 release notes so people who used > Postgres > > previously would know

Re: Common case not at all clear

2021-08-03 Thread Anthony Berglas
Hello David, Thanks for that, I had thought that you were a committer. Sounds like it might all be a bit too difficult. Anthony On Tue, Aug 3, 2021 at 9:39 AM David G. Johnston wrote: > On Mon, Aug 2, 2021 at 4:30 PM Anthony Berglas > wrote: > >> You are talking about optimistic locking, com

Re: Common case not at all clear

2021-08-03 Thread Anthony Berglas
Hello David, You are talking about optimistic locking, commonly used for web applications where there is no transaction kept open during user think time. A COMMIT between the SELECT and the UPDATE. This is also what was needed for traditional MySql running only in AutoCommit mode. It requires n