pgtle.unregister_feature_if_exists - Amazon Aurora
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).


The unregister_feature function provides a way to remove functions that were registered to use pg_tle features, such as hooks. For more information, see Using PostgreSQL hooks with your TLE extensions. Returns true after successfully unregistering the feature. Returns false if the feature wasn't registered.

For information about registering pg_tle features for your TLE extensions, see pgtle.register_feature.

Function prototype

pgtle.unregister_feature_if_exists('proc regproc', 'feature pg_tle_features')




  • proc – The name of the stored function that was registered to include a pg_tle feature.

  • feature – The name of the pg_tle feature that was registered with the trusted language extension.


Returns true or false, as follows.

  • true – The function has successfully unregistered the feature from extension.

  • false – The function wasn't able to unregister the feature from the TLE extension.

Usage example

SELECT * FROM pgtle.unregister_feature_if_exists('pw_hook', 'passcheck');