postgresql - Notify FUNCTION in PGSQL to pass column values to C# -
i have trigger created in pgsql notify c# app when new row created in table matching condition on column value.
function send msgfail c#:
create or replace function notify_fail() returns trigger ' begin notify msgfail; return null; end; 'language plpgsql; trigger call function when new row insert:
create trigger failtrigger after insert or update on jm each row execute procedure notify_fail(); when (new.message_string '%error%') execute procedure notify_fail(); this works fine far.
question : want modify function return contents of 1 or more columns c# application.
if new row insert call function. inside function: return column1. is possible?
npgsql.dll version : 2.0.11.91
currently not supported npgsql craig notes.
one set of tools may find helpful managing http://pgxn.org/dist/pg_message_queue/
it isn't functional in terms of supporting multiple subscribers in high performance configurations simple , works quite getting arbitrary data notify listeners.
Comments
Post a Comment