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

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

qt - Errors in generated MOC files for QT5 from cmake -