listen to notification

[saqib556612]

Hello i am using postgress on cloud and i created triggerfunction and trigger in pgAdmin. Here is my trigger function

CREATE FUNCTION public.row_notifiy_n() RETURNS trigger LANGUAGE 'plpgsql' COST 100 VOLATILE NOT LEAKPROOF AS $BODY$ BEGIN PERFORM pg_notify( 'rowChanged', json_build_object( 'operation', TG_OP, 'record', row_to_json(new) )::text ); Return new; END; $BODY$;

ALTER FUNCTION public.row_notifiy_n() OWNER TO "abc";

and trigger is

CREATE TRIGGER notify AFTER INSERT OR DELETE OR UPDATE ON public."Logs" FOR EACH ROW EXECUTE PROCEDURE public.row_notifiy_n();

ALTER TABLE public."Logs" ENABLE ALWAYS TRIGGER notify;

How i can listen this in flutter

[IsemicolonI]

Apparently, in old versions, you could listen to notifications with connection.notifications.listen(), but with the replacement of Connection with PostgreSQLConnection, this feature no longer exists in created connection and no document exist for notification listening. I also filed this issue and am waiting for help

[isoos]

Not sure: are you looking for notification listeners? https://pub.dev/documentation/postgres/latest/postgres/Connection/channels.html https://pub.dev/documentation/postgres/latest/postgres/Channels-class.html

[IsemicolonI]

I read the source code almost 1 hour ago and realized how to do this, but it is better to put an example in Example so that there is no need to read the API reference or source code.