]> granicus.if.org Git - postgresql/commit
Fix pg_dump's handling of event triggers.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 23 Jul 2017 00:20:09 +0000 (20:20 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 23 Jul 2017 00:20:09 +0000 (20:20 -0400)
commit82ebda7fffac8f4c796ef7d36d377bebca620528
treebadba8788f081b495232c8d5e5c39ba2e6597499
parent73fbf3d3d0a59d79f75a8202e03863fe462d052f
Fix pg_dump's handling of event triggers.

pg_dump with the --clean option failed to emit DROP EVENT TRIGGER
commands for event triggers.  In a closely related oversight,
it also did not emit ALTER OWNER commands for event triggers.
Since only superusers can create event triggers, the latter oversight
is of little practical consequence ... but if we're going to record
an owner for event triggers, then surely pg_dump should preserve it.

Per complaint from Greg Atkins.  Back-patch to 9.3 where event triggers
were introduced.

Discussion: https://postgr.es/m/20170722191142.yi4e7tzcg3iacclg@gmail.com
src/bin/pg_dump/pg_backup_archiver.c
src/bin/pg_dump/pg_dump.c
src/bin/pg_dump/t/002_pg_dump.pl