pgtle.install_update_path - Amazon Aurora
Function prototypeRoleArgumentsOutputUsage example
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

pgtle.install_update_path

The install_update_path function provides an update path between two different versions of a TLE extension. This function allows users of your TLE extension to update its version by using the ALTER EXTENSION ... UPDATE syntax.

Function prototype

pgtle.install_update_path(name text, fromvers text, tovers text, ext text)

Role

pgtle_admin

Arguments

  • name – The name of the TLE extension. This value is used when calling CREATE EXTENSION.

  • fromvers – The source version of the TLE extension for the upgrade.

  • tovers – The destination version of the TLE extension for the upgrade.

  • ext – The contents of the update. This value contains objects such as functions.

Output

None.

Usage example

SELECT pgtle.install_update_path(pg_tle_test, 0.1, 0.2,
  $_pgtle_$
    CREATE OR REPLACE FUNCTION my_test()
    RETURNS INT
    AS $$
      SELECT 21;
    $$ LANGUAGE SQL IMMUTABLE;
  $_pgtle_$
);