ALTER INDEX documentation is incomplete

2024-10-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-alterindex.html Description: I am trying to find out whether the syntax `ALTER INDEX name ATTACH PARTITION index_name` accepts a schema-qualified index_name. However, there is no furth

Re: Logical replication - initial data synchronization

2024-10-18 Thread Laurenz Albe
On Fri, 2024-10-18 at 13:05 +0200, Koen De Groote wrote: > I feel like people don't complain because at some point they figure it out, > and then it's no longer an issue for them. But it was initially, and it did > cost them time. Most people will work with PostgreSQL for their job and > their job

Re: Logical replication - initial data synchronization

2024-10-18 Thread Koen De Groote
> But perhaps active voice can make it even clearer: That would be nice. It immediately clarifies the actor, instead of basically saying "it's expected that an action was performed". To give some context, jobs over the past decade have taught me to work on a default setting of "If it isn't explic

Re: Savepoint

2024-10-18 Thread Laurenz Albe
On Fri, 2024-10-18 at 06:50 +, PG Doc comments form wrote: > https://www.postgresql.org/docs/16/sql-insert.html#SQL-ON-CONFLICT > > In section on conflict nothing that there will be implicit savepoint (sub > transaction). But this is important to know to mark function as PARALLEL > UNSAFE. Wh

Re: Logical replication - initial data synchronization

2024-10-18 Thread Laurenz Albe
On Thu, 2024-10-17 at 16:00 -0400, Bruce Momjian wrote: > > To me, > > > > >    When logical replication of a table typically starts, a snapshot is > > >    taken of the table's data on the publisher database and copied to the > > >   subscriber > > > > Does not clarify that. > > > > It's the re

Savepoint

2024-10-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-insert.html Description: https://www.postgresql.org/docs/16/sql-insert.html#SQL-ON-CONFLICT In section on conflict nothing that there will be implicit savepoint (sub transaction). But