Table node: "Of type" columns not editable. (RM #1233) #229
Description
Issue migrated from Redmine: https://redmine.postgresql.org/issues/1233
Originally created by Thom Brown at 2016-05-25 15:09:21 UTC.
When inheriting columns from a composite type by setting the "Of type" option on the Advanced tab on the Create Table dialog, there's no way of setting defaults or primary keys of the columns taken from the composite type.
For example, there's no way of doing this in PgAdmin4:
CREATE TYPE inventory AS (product_id bigint, product_name text, weight numeric);
CREATE TABLE stock OF inventory (
PRIMARY KEY (product_id),
weight WITH OPTIONS DEFAULT 0
);