{

ForeignKeyCacheInfo *fk = lfirst(cell);

/*

* Refuse to attach a table as partition that this partitioned table

* already has a foreign key to. This isn't useful schema, which is

* proven by the fact that there have been no user complaints that

* it's already impossible to achieve this in the opposite direction,

* i.e., creating a foreign key that references a partition. This

* restriction allows us to dodge some complexities around

* pg_constraint and pg_trigger row creations that would be needed

* during ATTACH/DETACH for this kind of relationship.

*/

if (fk->confrelid == RelationGetRelid(partRel))

ereport(ERROR,

(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),

errmsg("can't attach table \"%s\" as a partition which is referenced by foreign key \"%s\"",

RelationGetRelationName(partRel),

get_constraint_name(fk->conoid))));

clone = lappend_oid(clone, fk->conoid);

}

ALTER TABLE fk_partitioned_fk ATTACH PARTITION fk_partitioned_fk_2

FOR VALUES IN (1600);

-- leave these tables around intentionally

-- Verify that attaching a table that's referenced by an existing FK

-- in the parent throws an error

CREATE TABLE fk_partitioned_pk_6 (a int PRIMARY KEY);

CREATE TABLE fk_partitioned_fk_6 (a int REFERENCES fk_partitioned_pk_6) PARTITION BY LIST (a);

ALTER TABLE fk_partitioned_fk_6 ATTACH PARTITION fk_partitioned_pk_6 FOR VALUES IN (1);

ERROR: can't attach table "fk_partitioned_pk_6" as a partition which is referenced by foreign key "fk_partitioned_fk_6_a_fkey"

DROP TABLE fk_partitioned_pk_6, fk_partitioned_fk_6;

-- This case is similar to above, but the referenced relation is one level

-- lower in the hierarchy. This one fails in a different way as the above,

-- because we don't bother to protect against this case explicitly. If the

-- current error stops happening, we'll need to add a better protection.

CREATE TABLE fk_partitioned_pk_6 (a int PRIMARY KEY) PARTITION BY list (a);

CREATE TABLE fk_partitioned_pk_61 PARTITION OF fk_partitioned_pk_6 FOR VALUES IN (1);

CREATE TABLE fk_partitioned_fk_6 (a int REFERENCES fk_partitioned_pk_61) PARTITION BY LIST (a);

ALTER TABLE fk_partitioned_fk_6 ATTACH PARTITION fk_partitioned_pk_6 FOR VALUES IN (1);

ERROR: cannot ALTER TABLE "fk_partitioned_pk_61" because it is being used by active queries in this session

DROP TABLE fk_partitioned_pk_6, fk_partitioned_fk_6;

-- test the case when the referenced table is owned by a different user

create role regress_other_partitioned_fk_owner;

grant references on fk_notpartitioned_pk to regress_other_partitioned_fk_owner;

CREATETABLEfk_partitioned_pk_6 (aintPRIMARY KEY);

CREATETABLEfk_partitioned_fk_6 (aintREFERENCES fk_partitioned_pk_6) PARTITION BY LIST (a);

ALTERTABLE fk_partitioned_fk_6 ATTACH PARTITION fk_partitioned_pk_6 FORVALUESIN (1);

DROPTABLE fk_partitioned_pk_6, fk_partitioned_fk_6;

CREATETABLEfk_partitioned_pk_6 (aintPRIMARY KEY) PARTITION BY list (a);

CREATETABLEfk_partitioned_pk_61 PARTITION OF fk_partitioned_pk_6 FORVALUESIN (1);

CREATETABLEfk_partitioned_fk_6 (aintREFERENCES fk_partitioned_pk_61) PARTITION BY LIST (a);

ALTERTABLE fk_partitioned_fk_6 ATTACH PARTITION fk_partitioned_pk_6 FORVALUESIN (1);

DROPTABLE fk_partitioned_pk_6, fk_partitioned_fk_6;

create role regress_other_partitioned_fk_owner;

grantreferenceson fk_notpartitioned_pk to regress_other_partitioned_fk_owner;