Re: Simplify the logic a bit (src/bin/scripts/reindexdb.c) - Mailing list pgsql-hackers

From Ranier Vilela
Subject Re: Simplify the logic a bit (src/bin/scripts/reindexdb.c)
Date
Msg-id CAEudQAoXZGQNgk2M4rW3vs_C5_X9Y09QsYawZLRxV15W+D329Q@mail.gmail.com
Whole thread Raw
In response to Re: Simplify the logic a bit (src/bin/scripts/reindexdb.c)  (Álvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Simplify the logic a bit (src/bin/scripts/reindexdb.c)
List pgsql-hackers
Hi Álvaro.

Em qui., 27 de fev. de 2025 às 16:50, Álvaro Herrera <alvherre@alvh.no-ip.org> escreveu:
On 2025-Feb-14, Ranier Vilela wrote:

> Attached is the prototype version v1.
> What do you think?

I think this is still a bit confused.  The new function's comment says
"prepare the list of tables to ..." but what it really receives is a
list of _indexes_ (as evidenced by the fact that they're compared to
pg_index.indexrelid).  So on input the user_list is an index list, and
on output it has been changed into a list of tables, and the list of
indexes is the function's return value?  That seems quite weird.
  Yeah, I think that is confusing.

  I
propose to change the API of this new function thus:

static void
get_parallel_tabidx_list(PGconn *conn,
                SimpleStringList *index_list,
                SimpleStringList *table_list,
                bool echo);

where index_list is inout and the table_list is just an output argument.
Ok.
 

I would also remove the 'type' argument, because I don't see a need to
keep it.
Ok.

Thanks for your guidance.

v2 attached, please comment if you have any further objections.

best regards,
Ranier Vilela
Attachment

pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: Get rid of WALBufMappingLock
Next
From: Srinath Reddy
Date:
Subject: Re: bug: ALTER TABLE ADD VIRTUAL GENERATED COLUMN with table rewrite