diff options
| -rw-r--r-- | contrib/spi/refint.c | 2 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 6 |
2 files changed, 5 insertions, 3 deletions
diff --git a/contrib/spi/refint.c b/contrib/spi/refint.c index 954e12c5905..ca9ffa72881 100644 --- a/contrib/spi/refint.c +++ b/contrib/spi/refint.c @@ -480,6 +480,8 @@ check_foreign_key() relname = args[0]; + sprintf(ident, "%s$%u", trigger->tgname, rel->rd_id); + plan = find_plan(ident, &FPlans, &nFPlans); ret = SPI_execp(plan->splan[r], kvals, NULL, tcount); /* we have no NULLs - so we pass ^^^^ here */ diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 89974eaa8da..7e3d44292d7 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -281,13 +281,13 @@ catalogs. <variablelist> <varlistentry> <term> -rules and views +rules <listitem> <para> <application>pg_dump</application> -does not understand user-defined rules and views and +does not understand user-defined rules and will fail to dump them properly. (This is due to the fact that -rules are stored as plans in the catalogs and not textually). +rules are stored as plans in the catalogs and not textually.) <varlistentry> <term> |