Package "postgresql-9.5"

  postgresql-9.5 (9.5.25-0ubuntu0.16.04.1) xenial; urgency=medium

  * New upstream version (LP: #1915254)
    + Fix CREATE INDEX CONCURRENTLY to wait for
      concurrent prepared transactions (Andrey Borodin)

      At the point where CREATE INDEX CONCURRENTLY
      waits for all concurrent transactions to complete so that it can see
      rows they inserted, it must also wait for all prepared transactions
      to complete, for the same reason. Its failure to do so meant that
      rows inserted by prepared transactions might be omitted from the new
      index, causing queries relying on the index to miss such rows.
      In installations that have enabled prepared transactions
      (max_prepared_transactions > 0),
      it's recommended to reindex any concurrently-built indexes in
      case this problem occurred when they were built.

    + Details about this and many further changes can be found at:
      https://www.postgresql.org/docs/9.5/static/release-9-5-25.html

 -- Christian Ehrhardt <email address hidden> Wed, 10 Feb 2021 11:47:36 +0100

  postgresql-9.5 (9.5.21-0ubuntu0.16.04.1) xenial; urgency=medium

  * New upstream release (LP: #1863108)
    - A dump/restore is not required however, if you use the contrib/intarray
      extension with a GiST index, and you rely on indexed searches for the <@
      operator, see the release notes for details in regard to a related fix.
    - Details about these and many further changes can be found at:
      https://www.postgresql.org/docs/9.5/static/release-9-5-20.html
      https://www.postgresql.org/docs/9.5/static/release-9-5-21.html

 -- Christian Ehrhardt <email address hidden> Thu, 13 Feb 2020 15:18:20 +0100