staticvoidRangeVarCallbackForAlterRelation(constRangeVar*rv,Oidrelid,

Oidoldrelid,void*arg);

staticPartitionSpec*transformPartitionSpec(Relationrel,PartitionSpec*partspec,char*strategy);

staticvoidComputePartitionAttrs(Relationrel,List*partParams,AttrNumber*partattrs,

staticvoidComputePartitionAttrs(ParseState*pstate,Relationrel,List*partParams,AttrNumber*partattrs,

List**partexprs,Oid*partopclass,Oid*partcollation,charstrategy);

staticvoidCreateInheritance(Relationchild_rel,Relationparent_rel);

staticvoidRemoveInheritance(Relationchild_rel,Relationparent_rel);

if (stmt->partspec)

{

ParseState*pstate;

charstrategy;

intpartnatts;

AttrNumberpartattrs[PARTITION_MAX_KEYS];

Oidpartopclass[PARTITION_MAX_KEYS];

Oidpartcollation[PARTITION_MAX_KEYS];

List*partexprs=NIL;

pstate=make_parsestate(NULL);

pstate->p_sourcetext=queryString;

partnatts=list_length(stmt->partspec->partParams);

stmt->partspec=transformPartitionSpec(rel,stmt->partspec,

&strategy);

ComputePartitionAttrs(rel,stmt->partspec->partParams,

ComputePartitionAttrs(pstate,rel,stmt->partspec->partParams,

partattrs,&partexprs,partopclass,

partcollation,strategy);

ComputePartitionAttrs(Relationrel,List*partParams,AttrNumber*partattrs,

ComputePartitionAttrs(ParseState*pstate,Relationrel,List*partParams,AttrNumber*partattrs,

List**partexprs,Oid*partopclass,Oid*partcollation,

charstrategy)

{

ereport(ERROR,

(errcode(ERRCODE_UNDEFINED_COLUMN),

errmsg("column \"%s\" named in partition key does not exist",

pelem->name)));

pelem->name),

parser_errposition(pstate,pelem->location)));

attform= (Form_pg_attribute)GETSTRUCT(atttuple);

if (attform->attnum <=0)

ereport(ERROR,

(errcode(ERRCODE_INVALID_OBJECT_DEFINITION),

errmsg("cannot use system column \"%s\" in partition key",

pelem->name)));

pelem->name),

parser_errposition(pstate,pelem->location)));

partattrs[attn]=attform->attnum;

atttype=attform->atttypid;

a int

) PARTITION BY RANGE (b);

ERROR: column "b" named in partition key does not exist

LINE 3: ) PARTITION BY RANGE (b);

^

-- cannot use system columns in partition key

CREATE TABLE partitioned (

a int

) PARTITION BY RANGE (xmin);

ERROR: cannot use system column "xmin" in partition key

LINE 3: ) PARTITION BY RANGE (xmin);

^

-- functions in key must be immutable

CREATE FUNCTION immut_func (a int) RETURNS int AS $$ SELECT a + random()::int; $$ LANGUAGE SQL;

CREATE TABLE partitioned (

-- specify PARTITION BY for a partition

CREATE TABLE fail_part_col_not_found PARTITION OF parted FOR VALUES IN ('c') PARTITION BY RANGE (c);

ERROR: column "c" named in partition key does not exist

LINE 1: ...TITION OF parted FOR VALUES IN ('c') PARTITION BY RANGE (c);

^

CREATE TABLE part_c PARTITION OF parted (b WITH OPTIONS NOT NULL DEFAULT 0) FOR VALUES IN ('c') PARTITION BY RANGE ((b));

-- create a level-2 partition

CREATE TABLE part_c_1_10 PARTITION OF part_c FOR VALUES FROM (1) TO (10);