Maintained with ☕️ by
IcePanel logo

The temporal_tables extension, version 1.2.2 is generally available

Share

Services

## Feature The `temporal_tables` extension, version 1.2.2 is generally available. This extension provides support for temporal tables. A temporal table records the period of time when a row is valid from a database perspective. For more information, see [Configure PostgreSQL extensions](https://cloud.google.com/sql/docs/postgres/extensions). You can now perform `CREATE CAST` and `DROP CAST` statements as a database user with the `cloudsqlsuperuser` role. For more information, see [About PostgreSQL users and roles](https://cloud.google.com/sql/docs/postgres/users). The rollout of the following minor versions, extension versions, and plugin versions is **underway**: **Minor versions** * 12.17 is upgraded to 12.19. * 13.13 is upgraded to 13.15. * 14.10 is upgraded to 14.12. * 15.5 is upgraded to 15.7. **Extension and plugin versions** * google\_ml\_integration is upgraded from 1.2 to 1.3. * pg\_partman is upgraded from 4.7.4 to 5.0.1 (for PostgreSQL versions 14 and later). * pgvector is upgraded from 0.6.0 to 0.7.0. * Plv8 is upgraded from 3.2.0 to 3.2.2. * PostGIS is upgraded from 3.2.5 to 3.4.0 (for PostgreSQL versions 12 and later). If you use a maintenance window, then the updates to the minor, extension, and plugin versions happen according to the timeframe that you set in the window. Otherwise, the updates occur within the next few weeks. The new maintenance version is `[PostgreSQL version].R20240514.00_04`. To learn how to check your maintenance version, see [Self service maintenance](https://cloud.google.com/sql/docs/postgres/self-service-maintenance#before%5Fyou%5Fbegin/self-service-maintenance). To find your maintenance window or to manage maintenance updates, see [Find and set maintenance windows](https://cloud.google.com/sql/docs/postgres/set-maintenance-window). ## Feature You can now choose to receive a maintenance notification 5 weeks before the maintenance update of your Cloud SQL instance is scheduled to occur. This option is named **Week 5**. In addition, some labels in the Google Cloud Console have been renamed to align with this new option: * **Order of update** is renamed to **Maintenance timing** * **Earlier** is renamed to **Week 1** * **Later** is renamed to **Week 2** For more information, see [Maintenance settings](https://cloud.google.com/sql/docs/postgres/maintenance#management) and [Find and set maintenance windows](https://cloud.google.com/sql/docs/postgres/set-maintenance-window).