-
Hello Felipe Diego,
Good day!
Thank you for posting here.
The options that says: “A query that references catalog tables such as pg_table_def and user-created functions like current_schema() can only exclusively run on the leader node.” was deemed incorrect because this option suggests that both catalog tables (like pg_table_def) and user-created functions (like current_schema()) must exclusively run on the leader node. However, this is not entirely correct. While the current_schema() function is indeed a leader node function, queries referencing catalog tables like pg_table_def can be executed across compute nodes as well, depending on the query.
The last option is correct because this option specifically and accurately states that current_schema() is a leader node-only function. This means it can only be executed on the leader node. The key part of the correct option(last one given) is that it explains why this causes a problem: the query references a pg_table_def system table that resides on the compute nodes, leading to an error. This is the correct interpretation of the issue.
I hope this helps. If you have more queries, pls let us know.I hope this helps. If you have more queries, pls let us know.
Regards,
Neil @ Tutorials Dojo
