Devart Forums

Posted: **Wed 23 Feb 2005 07:46**

hello

how can i get back an RAISE NOTICE from a function?

a sample of the function:

CREATE OR REPLACE FUNCTION "public"."friedl" () RETURNS integer AS
$body$
begin
  raise notice 'error is on';
  return 0;
end;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

Posted: **Thu 24 Feb 2005 10:56**

You can use PgSqlConnection.InfoMessage event.
Sample:

Code: Select all

private void OnInfoMessage(object sender, PgSqlInfoMessageEventArgs args) {
    
      MessageBox.Show(args.Message);
 }
private void Test() {
    ...
    pgSqlConnection.InfoMessage += new PgSqlInfoMessageEventHandler(OnInfoMessage);
    ...
    command.ExecuteNonQuery()
}

Devart Forums

Raise Notice in Function

Raise Notice in Function