3.1. Functions

shardman.make_table_global(table oid)

Converts a regular table to a global one. Global tables exist on any Shardman node and contain the same data. Use them for joins with sharded tables. Global tables cannot be deleted or altered. Use shardman.make_table_local to convert a global table back to a regular one.

shardman.make_table_local(table oid)

Converts a global table to a regular one. The global table is converted to a regular table on the replication group where the former was created in a call to shardman.make_table_global. The global table will not exist on other nodes after completion of this function. See shardman.make_table_global for more information.

shardman.broadcast_all_sql(statement text)

Executes statement on every replication group.

shardman.broadcast_sql(statement text)

Executes statement on every replication group but the current one.