## E.143. Release 9.3.1

Release date: 2013-10-10

This release contains a variety of fixes from 9.3.0. For information about new features in the 9.3 major release, see Section E.144.

### E.143.1. Migration to Version 9.3.1

A dump/restore is not required for those running 9.3.X.

However, if you use the `hstore` extension, see the first changelog entry.

### E.143.2. Changes

- Ensure new-in-9.3 JSON functionality is added to the `hstore` extension during an update (Andrew Dunstan)

  Users who upgraded a pre-9.3 database containing `hstore` should execute

      ALTER EXTENSION hstore UPDATE;

  after installing 9.3.1, to add two new JSON functions and a cast. (If `hstore` is already up to date, this command does nothing.)

- Fix memory leak when creating B-tree indexes on range columns (Heikki Linnakangas)

- Fix memory leak caused by `lo_open()` failure (Heikki Linnakangas)

- Serializable snapshot fixes (Kevin Grittner, Heikki Linnakangas)

- Fix deadlock bug in libpq when using SSL (Stephen Frost)

- Fix timeline handling bugs in pg_receivexlog (Heikki Linnakangas, Andrew Gierth)

- Prevent `CREATE FUNCTION` from checking `SET` variables unless function body checking is enabled (Tom Lane)

- Remove rare inaccurate warning during vacuum of index-less tables (Heikki Linnakangas)