diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-04-04 16:36:21 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-04-04 16:38:11 -0300 |
| commit | 7d7c99790b2a7e6f4e5287a3fb29f73cedbb2105 (patch) | |
| tree | ef7d8067c2aec850421e5d14f7f763820f13f317 /src | |
| parent | 446f7f5d789fe9ecfacd998407b5bee70aaa64f7 (diff) | |
| download | postgresql-7d7c99790b2a7e6f4e5287a3fb29f73cedbb2105.tar.gz postgresql-7d7c99790b2a7e6f4e5287a3fb29f73cedbb2105.zip | |
Restore erroneously removed ONLY from PK check
This is a blind fix, since I don't have SE-Linux to verify it.
Per unwanted change in rhinoceros, running sepgsql tests. Noted by Tom
Lane.
Discussion: https://postgr.es/m/32347.1522865050@sss.pgh.pa.us
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/adt/ri_triggers.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/utils/adt/ri_triggers.c b/src/backend/utils/adt/ri_triggers.c index 90ddbe55167..fc034ce6019 100644 --- a/src/backend/utils/adt/ri_triggers.c +++ b/src/backend/utils/adt/ri_triggers.c @@ -1915,7 +1915,7 @@ RI_Initial_Check(Trigger *trigger, Relation fk_rel, Relation pk_rel) /*---------- * The query string built is: * SELECT fk.keycols FROM [ONLY] relname fk - * LEFT OUTER JOIN pkrelname pk + * LEFT OUTER JOIN ONLY pkrelname pk * ON (pk.pkkeycol1=fk.keycol1 [AND ...]) * WHERE pk.pkkeycol1 IS NULL AND * For MATCH SIMPLE: @@ -1943,7 +1943,7 @@ RI_Initial_Check(Trigger *trigger, Relation fk_rel, Relation pk_rel) fk_only = fk_rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE ? "" : "ONLY "; appendStringInfo(&querybuf, - " FROM %s%s fk LEFT OUTER JOIN %s pk ON", + " FROM %s%s fk LEFT OUTER JOIN ONLY %s pk ON", fk_only, fkrelname, pkrelname); strcpy(pkattname, "pk."); |