When a CREATE VIEW statement is issued in a session, the view’s ownership is assigned to the current session user. Example: yugabyte=# […]
Read MoreChange the Owner of a Sequence in YSQL
When you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read MoreCheck for Invalid Indexes in YSQL
If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
Read MoreConsolidate Data From YB Catalog Tables From All Nodes To One Node
🆕 Looking for the Built-In Approach? This Tip shows how to consolidate node-local YSQL catalog and statistics data using postgres_fdw. Starting with […]
Read More