Re: Correction in doc of failover ready steps

2024-07-23 Thread shveta malik
On Wed, Jul 24, 2024 at 9:02 AM Zhijie Hou (Fujitsu) wrote: > > Thanks for the patch. > > Here is one comment: > > The second query has a condition 'WHERE slot_name IS NOT NULL', but I > think it belongs to the first query. Because the slot_name of second query > is built by CONCAT() which means i

RE: Correction in doc of failover ready steps

2024-07-23 Thread Zhijie Hou (Fujitsu)
On Wednesday, July 24, 2024 10:56 AM shveta malik wrote: > > On Tue, Jul 23, 2024 at 5:10 PM Amit Kapila wrote: > > > > One minor comment: > > - if the table copy is finished (See > linkend="catalog-pg-subscription-rel"/>). > > + On the subscriber node, use the following SQL to identif

Re: Correction in doc of failover ready steps

2024-07-23 Thread shveta malik
On Tue, Jul 23, 2024 at 5:10 PM Amit Kapila wrote: > > One minor comment: > - if the table copy is finished (See linkend="catalog-pg-subscription-rel"/>). > + On the subscriber node, use the following SQL to identify which main > + slots should be synced to the standby that we plan to

Re: Correction in doc of failover ready steps

2024-07-23 Thread Amit Kapila
On Tue, Jul 23, 2024 at 9:40 AM shveta malik wrote: > > On Tue, Jul 23, 2024 at 8:14 AM Zhijie Hou (Fujitsu) > wrote: > > > > I also agree that separating the 2 queries makes sense. > > Please find the patch with the suggested change. > One minor comment: - if the table copy is finished (See

Re: Undocumented optionality of handler_statements

2024-07-23 Thread Philipp Salvisberg
On 23 Jul 2024, at 01:39, Michael Paquier wrote:On Mon, Jul 22, 2024 at 01:55:52PM +, PG Doc comments form wrote:Inhttps://www.postgresql.org/docs/16/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPINGhandler_statements are documented as optional.However, the following example shows that ha