On 11 January 2018 at 10:44, David Rowley <david.row...@2ndquadrant.com> wrote: >>> 18. Why two RESET SESSION AUTHORIZATIONs? >>> >>> reset session authorization; >>> drop trigger trig_d_1_15 ON part_d_1_15; >>> drop function func_d_1_15(); >>> -- Policy expression contains SubPlan >>> reset session authorization; >> >> The second reset is actually in a different paragraph. The reason it's >> there is to ensure we have reset it regardless of the earlier cleanup. > > hmm, I was reviewing the .out file, which does not have the empty > lines. Still seems a bit surplus.
I believe the output file does not have the blank lines present in the .sql file. I was referring to the paragraph in the *.sql* file. -- Thanks, -Amit Khandekar EnterpriseDB Corporation The Postgres Database Company
