RE: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events

2020-06-11 Thread Vianello Fabio
PERFORM pg_notify('Table', Cast(NEW."ID" as text)); RETURN NEW; END; $BODY$; ALTER FUNCTION public.incupdate1_notice() OWNER TO postgres; I hope that help someone, because the bug last from "years". I tried in version 10 11 and 12, so it is present since

RE: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events

2020-06-09 Thread Vianello Fabio
Vianello. From: David G. Johnston [mailto:david.g.johns...@gmail.com] Sent: martedì 9 giugno 2020 17:10 To: Vianello Fabio Cc: PostgreSQL Hackers ; pgsql-b...@lists.postgresql.org; Kyotaro Horiguchi ; Euler Taveira Subject: Re: BUG #16481: Stored Procedure Triggered by Logical Replication is

RE: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events

2020-06-09 Thread Vianello Fabio
Is PostgreSQL a serious product? For me the answer is "NO". A product with a bug that last for years and the community knows. It is not serious. BR, Fabio. From: Euler Taveira [mailto:euler.tave...@2ndquadrant.com] Sent: lunedì 8 giugno 2020 12:51 To: Kyotaro Horiguchi Cc: Vian

RE: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events

2020-06-08 Thread Vianello Fabio
Horiguchi [mailto:horikyota@gmail.com] Sent: lunedì 8 giugno 2020 10:28 To: Vianello Fabio ; pgsql-b...@lists.postgresql.org; pgsql-hackers@lists.postgresql.org Subject: Re: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events Hello. It seems to me a bu