PL/python event_trigger - Mailing list pgsql-bugs

From Weatherby,Gerard
Subject PL/python event_trigger
Date
Msg-id SA1PR14MB5855CD454EBDF3E0EC636A21B9B22@SA1PR14MB5855.namprd14.prod.outlook.com
Whole thread Raw
List pgsql-bugs
*** Attention: This is an external email. Use caution responding, opening attachments or clicking on links. ***

It seems event triggers can not be writen in plypython3u

CREATE OR REPLACE FUNCTION log_schema_changes()

RETURNS EVENT_TRIGGER

LANGUAGE plpython3u

 AS $$

import plpy

plyp.warning(TD)

$$;

 

Generates error “ERROR:  trigger functions can only be called as triggers”

Version info is: psql (15.6 (Ubuntu 15.6-1.pgdg20.04+1), server 15.7 (Ubuntu 15.7-1.pgdg22.04+1))

 

-----------------------------------

 

GERARD WEATHERBY

Application Architect

 

NMRhub

nmrhub.org

 

signature_1087073379

 

 

Attachment

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18565: Job finishes successfully but reruns unwanted!!!
Next
From: Tom Lane
Date:
Subject: Re: BUG #18563: Where is tha "FIRST" aggregate function??