Unnecessary Option in Refresh MATERIALIZED VIEW Dialog

[NishchayDBA]

Hi Team,

The option "Refresh MATERIALIZED VIEW WITH NO DATA Concurrently" is erroneously displayed in the pgAdmin interface, as shown in the attached screenshot. This option is not supported by PostgreSQL and results in an error when executed.

Steps to Reproduce:

1. Open pgAdmin and navigate to a MATERIALIZED VIEW.
2. Select the option to refresh the MATERIALIZED VIEW.
3. Observe the list of refresh methods in the interface.
4. Attempt to execute the "WITH NO DATA Concurrently" method.

Observed Behavior:

The option "Refresh MATERIALIZED VIEW WITH NO DATA Concurrently" is available for selection.
Executing this option results in the following PostgreSQL error message:

2024-12-28 10:11:08.980 +08 [27264] ERROR: CONCURRENTLY and WITH NO DATA options cannot be used together
2024-12-28 10:11:08.980 +08 [27264] STATEMENT: REFRESH MATERIALIZED VIEW CONCURRENTLY my_schema.my_materialized_view WITH NO DATA;

I think the option "WITH NO DATA Concurrently" should not be displayed, as PostgreSQL does not support this combination of options. The WITH NO DATA mode is meant for metadata updates and does not involve data repopulation, making the CONCURRENTLY keyword redundant and invalid.

Additionally, this issue may lead to confusion for users and failed operations, especially for those unfamiliar with the limitations of PostgreSQL's REFRESH MATERIALIZED VIEW syntax.

It would be great if this option "WITH NO DATA Concurrently" will be remove from the refresh method dropdown in pgAdmin.

Additional Information:

pgAdmin version: pgAdmin4 8.14 Desktop Mode
PostgreSQL version: PostgreSQL 15.8 on x86
Screenshots attached for clarity.