Warning When Creating FOR EACH STATEMENT Trigger On Logical Replication Subscriber Side - Mailing list pgsql-hackers

From Avi Weinberg
Subject Warning When Creating FOR EACH STATEMENT Trigger On Logical Replication Subscriber Side
Date
Msg-id DB9PR07MB71804E876904F432ACCD253BCB149@DB9PR07MB7180.eurprd07.prod.outlook.com
Whole thread Raw
Responses Re: Warning When Creating FOR EACH STATEMENT Trigger On Logical Replication Subscriber Side  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers

Hi Hackers,

 

There is no error or warning when creating FOR EACH STATEMENT trigger on  Logical Replication subscriber side, but it is not doing anything.  Shouldn't a warning be helpful?

 

CREATE TRIGGER set_updated_time_trig

   AFTER INSERT OR UPDATE OR DELETE ON test

    FOR EACH STATEMENT EXECUTE FUNCTION set_updated_time();

 

Thanks

 

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

pgsql-hackers by date:

Previous
From: Ronan Dunklau
Date:
Subject: Re: Asynchronous execution support for Custom Scan
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas