Function pg_event_trigger_ddl_commands does not exist for event trigger on Greenplum 6.x

Products

• VMware Tanzu Greenplum

Issue/Introduction

When using event trigger on Greenplum 6.x there is no function pg_event_trigger_ddl_commands does not exist.

Resolution

The function pg_event_trigger_ddl_commands does not exist in Greenplum 6.x because Greenplum  6.x incorporates PostgreSQL versions 8.4 thru version 9.4. PostgreSQL introduces pg_event_trigger_ddl_commands in version 9.5:

https://www.postgresql.org/docs/9.5/release-9-5.html

 

Greenplum 7.x is based on PostgreSQL version 12 and supports pg_event_trigger_ddl_commands:

https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-sql_commands-CREATE_TRIGGER.html

https://www.postgresql.org/docs/12/event-triggers.html