pgsql: Allow IMPORT FOREIGN SCHEMA within pl/pgsql. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Allow IMPORT FOREIGN SCHEMA within pl/pgsql.
Date
Msg-id E1bN5pm-00023m-4c@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Allow IMPORT FOREIGN SCHEMA within pl/pgsql.

Since IMPORT FOREIGN SCHEMA has an INTO clause, pl/pgsql needs to be
aware of that and avoid capturing the INTO as an INTO-variables clause.
This isn't hard, though it's annoying to have to make IMPORT a plpgsql
keyword just for this.  (Fortunately, we have the infrastructure now
to make it an unreserved keyword, so at least this shouldn't break any
existing pl/pgsql code.)

Per report from Merlin Moncure.  Back-patch to 9.5 where IMPORT FOREIGN
SCHEMA was introduced.

Report: <CAHyXU0wpHf2bbtKGL1gtUEFATCY86r=VKxfcACVcTMQ70mCyig@mail.gmail.com>

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/a0943dbbea533e266f2db56d62ad43d9e0ed090a

Modified Files
--------------
src/pl/plpgsql/src/pl_gram.y    | 47 +++++++++++++++++++++++++++++++++--------
src/pl/plpgsql/src/pl_scanner.c |  1 +
2 files changed, 39 insertions(+), 9 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Allow IMPORT FOREIGN SCHEMA within pl/pgsql.
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Put some things in a better order in psql help