• Tom Lane's avatar
    Adjust psql \d query to avoid use of @> operator. · 471d5585
    Tom Lane authored
    It seems that the parray_gin extension has seen fit to introduce a
    "text[] @> text[]" operator, which conflicts with the core
    "anyarray @> anyarray" operator, causing ambiguous-operator failures
    if the input arguments are coercible to text[] without being exactly
    that type.  This strikes me as a bad idea, but it's out there and
    people use it.  As of v10, that breaks psql's query that tries to
    test "pg_statistic_ext.stxkind @> '{d}'", since stxkind is char[].
    The best workaround seems to be to avoid use of that operator.
    We can use a scalar-vs-array test "'d' = any(stxkind)" instead;
    that's arguably more readable anyway.
    
    Per report from Justin Pryzby.  Backpatch to v10 where this
    query was added.
    
    Discussion: https://postgr.es/m/20171022181525.GA21884@telsasoft.com
    471d5585
describe.c 153 KB