if (!pg_class_ownercheck(RelationGetRelid(rel),stxowner))

aclcheck_error(ACLCHECK_NOT_OWNER,get_relkind_objtype(rel->rd_rel->relkind),

RelationGetRelationName(rel));

if (!allowSystemTableMods&&IsSystemRelation(rel))

ereport(ERROR,

(errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),

errmsg("permission denied: \"%s\" is a system catalog",

RelationGetRelationName(rel))));

}

Assert(rel);

end;

$$;

-- Verify failures

CREATE TABLE ext_stats_test (x int, y int, z int);

CREATE STATISTICS tst;

ERROR: syntax error at or near ";"

LINE 1: CREATE STATISTICS tst;

^

CREATE STATISTICS tst ON a, b FROM nonexistent;

ERROR: relation "nonexistent" does not exist

CREATE STATISTICS tst ON a, b FROMpg_class;

CREATE STATISTICS tst ON a, b FROMext_stats_test;

ERROR: column "a" does not exist

CREATE STATISTICS tst ONrelname, relname, relnatts FROMpg_class;

CREATE STATISTICS tst ONx, x, y FROMext_stats_test;

ERROR: duplicate column name in statistics definition

CREATE STATISTICS tst ONrelnatts +relpages FROMpg_class;

CREATE STATISTICS tst ONx +y FROMext_stats_test;

ERROR: only simple column references are allowed in CREATE STATISTICS

CREATE STATISTICS tst ON (relpages, reltuples) FROMpg_class;

CREATE STATISTICS tst ON (x, y) FROMext_stats_test;

ERROR: only simple column references are allowed in CREATE STATISTICS

CREATE STATISTICS tst (unrecognized) ONrelname, relnatts FROMpg_class;

CREATE STATISTICS tst (unrecognized) ONx, y FROMext_stats_test;

ERROR: unrecognized statistics kind "unrecognized"

DROP TABLE ext_stats_test;

-- Ensure stats are dropped sanely, and test IF NOT EXISTS while at it

CREATE TABLE ab1 (a INTEGER, b INTEGER, c INTEGER);

CREATE STATISTICS IF NOT EXISTS ab1_a_b_stats ON a, b FROM ab1;

$$;

CREATETABLEext_stats_test (xint, yint, zint);

CREATE STATISTICS tst;

CREATE STATISTICS tstON a, b;

CREATE STATISTICS tstFROM sometab;

CREATE STATISTICS tstON a, bFROM nonexistent;

CREATE STATISTICS tstON a, bFROM pg_class;

CREATE STATISTICS tstON relname, relname, relnattsFROM pg_class;

CREATE STATISTICS tstON relnatts+ relpagesFROM pg_class;

CREATE STATISTICS tstON (relpages, reltuples)FROM pg_class;

CREATE STATISTICS tst (unrecognized)ON relname, relnattsFROM pg_class;

CREATE STATISTICS tstON a, bFROM ext_stats_test;

CREATE STATISTICS tstON x, x, yFROM ext_stats_test;

CREATE STATISTICS tstON x+ yFROM ext_stats_test;

CREATE STATISTICS tstON (x, y)FROM ext_stats_test;

CREATE STATISTICS tst (unrecognized)ON x, yFROM ext_stats_test;

DROPTABLE ext_stats_test;

CREATETABLEab1 (aINTEGER, bINTEGER, cINTEGER);