Fix updates to handle sequences

[nikkhils]

The post-update script was handling preserving initprivs for newly
added catalog tables and views. However, newly added catalog sequences
need separate handling otherwise update tests start failing. We also
now grant privileges for all future sequences in the update tests.

In passing, default the PG_VERSION in the update tests to 12 since we
don't work with PG11 anymore.

[mkindahl]

The post-update script was handling preserving initprivs for newly
added catalog tables and views. However, newly added catalog sequences
need separate handling otherwise update tests start failing. We also
now grant privileges for all future sequences.

You don't. You only grant privileges for all future sequences in the update test. Not as part of the extension installation, which would be strange.

In passing, default the PG_VERSION in the update tests to 12 since we
don't work with PG11 anymore.

[mkindahl]

LGTM. You need to fix the commit message though so that it doesn't look like the extension sets default privileges for all installations. The change you have is only for the update test.

[nikkhils]

LGTM. You need to fix the commit message though so that it doesn't look like the extension sets default privileges for all installations. The change you have is only for the update test.

Ah yes, the commit message suggests that whole sale. Will change

[codecov]

Codecov Report

Merging #3339 (8ee6768) into master (71e8f13) will decrease coverage by 0.01%.
The diff coverage is n/a.

@@            Coverage Diff             @@
##           master    #3339      +/-   ##
==========================================
- Coverage   90.58%   90.57%   -0.02%     
==========================================
  Files         211      211              
  Lines       35536    35536              
==========================================
- Hits        32192    32188       -4     
- Misses       3344     3348       +4     

Impacted Files	Coverage Δ
src/loader/bgw_message_queue.c	85.52% <0.00%> (-2.64%)	⬇️

---

Continue to review full report at Codecov.

Legend - Click here to learn more
Δ = absolute <relative> (impact), ø = not affected, ? = missing data
Powered by Codecov. Last update d800e2f...8ee6768. Read the comment docs.