pgsql: pg_event_trigger_dropped_objects: add is_temp column

pg_event_trigger_dropped_objects: add is_temp column

It now also reports temporary objects dropped that are local to the
backend. Previously we weren't reporting any temp objects because it
was deemed unnecessary; but as it turns out, it is necessary if we want
to keep close track of DDL command execution inside one session. Temp
objects are reported as living in schema pg_temp, which works because
such a schema-qualification always refers to the temp objects of the
current session.

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/func.sgml | 7 ++++++
src/backend/catalog/objectaddress.c | 22 ++++++++---------
src/backend/commands/event_trigger.c | 35 +++++++++++++++++++++------
src/backend/utils/adt/format_type.c | 2 +-
src/backend/utils/adt/regproc.c | 4 +--
src/backend/utils/cache/lsyscache.c | 15 ++++++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 3 +--
src/include/utils/lsyscache.h | 1 +
src/test/regress/expected/event_trigger.out | 29 ++++++++++++----------
src/test/regress/sql/event_trigger.sql | 8 +++---
11 files changed, 87 insertions(+), 41 deletions(-)