Hi Murtuza,
Please find below review comments.
- "Location" and "Variables" fields are not getting display under Properties Panel.
- When we remove/add the Variables fields, we are executing query individually for each parameters. We should execute it in single query as below.
e.g.
Multiple Query :-
ALTER TABLESPACE "1 tb"
SET (random_page_cost=123);
ALTER TABLESPACE "1 tb"
SET (seq_page_cost=345);
Single Query :-
ALTER TABLESPACE "1 tb"
SET (random_page_cost=123, seq_page_cost=345);
Multiple Query :-
ALTER TABLESPACE "1 tb"
RESET (random_page_cost);
ALTER TABLESPACE "1 tb"
RESET (seq_page_cost);
Single Query :-
ALTER TABLESPACE "1 tb"
RESET (random_page_cost, seq_page_cost);
Other functionalities are working fine. Let us know in case of any issues.
Thanks,
Neel Patel