Also changes pg_tablegroup entry corresponding to tablegroup_name to properly reflect new grpname and grpowner (if the user has proper permissions or ownership to issue the ALTER TABLEGROUP statement. and ALTER TABLEGROUP tablegroup_name OWNER TO. Add ALTER TABLEGROUP statements to support ALTER TABLEGROUP tablegroup_name RENAME TO.Add new ysqlsh describe metacommands for tablegroups: \dgr to describe tablegroups, \dgrt lists all tables/indexes within the specified tablegroup (or within all tablegroups if grpname is not specified), and \d is modified to include tablegroup information in the footer, if any.For example, the total number of RPC calls is dropped from 66 to 58 for a simple table like CREATE TABLE t(k INT PRIMARY KEY). Reducing the number of RPC calls speeds up CREATE TABLE statement. Buffered operations may share single RPC with read operation.For CREATE INDEX, if NO TABLEGROUP was provided, then presplitting for the index is allowed otherwise, an error is issued. For CREATE TABLE, usage is blocked in the grammar. Block usage of TABLEGROUP with the SPLIT clause.Allow UPDATE statement to change primary key columns.Improve error message when UPDATE changes partition so its clear what went wrong, fixed yb_pg_foreign_key pg_regress test for semantic merge conflict when updating primary keys and row-level partitioning.Fix wrong result by avoiding pushdown of UPDATE statement with the RETURNING clause. Fix restore from a distributed backup fails for tables using SPLIT INTO without a primary key.Prevent consistency violations when a partitioned table has foreign key constraints due to erroneous classification as a single-row transaction.Remove spurious error message "0A000: Alter table is not yet supported" from CREATE OR REPLACE VIEW.Set index_backfill_rpc_timeout_ms default from 60000 to 30000 and change backfill_index_timeout_grace_margin_ms default from 50 to 500.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |