summaryrefslogtreecommitdiff
path: root/contrib/ltree/expected/xl_ltree.out
blob: 75441a7e41dc94680ae37209269fa21e7a41c0a6 (plain)
1
2
3
4
5
6
7
8
9
10
--Column of types “citext”, “ltree” cannot be used as distribution column
--ltree - labels of data stored in a hierarchical tree-like structure
CREATE TABLE xl_dc27 (
    product_no integer,
    product_id ltree PRIMARY KEY,
    name MONEY,
    purchase_date TIMETZ,
    price numeric
) DISTRIBUTE BY HASH (product_id); --fail
ERROR:  Column product_id is not a hash distributable data type