How to obtained raise notice with unidac components:

[niton_dev]

I would like to know how to I can to obtained message of raise notice using TUniConnection and TUniSQL or TUniQuery components with postgresql 8.4.2. and Codegear Delphi 2007. It's possible?

Example

I have this functions:

CREATE OR REPLACE FUNCTION TEST() RETURNS TRIGGER AS
$BODY$
BEGIN
RAISE NOTICE 'TEST OF RAISE NOTICE';
RETURN NEW;
END;
$BODY$
LANGUAGE 'PLPGSQL';

CREATE TRIGGER TEST_CONSUMER
BEFORE INSERT OR UPDATE
ON CONSUMER
FOR EACH ROW
EXECUTE PROCEDURE TEST();

I need to obtained message of raise notice when I insert or update the consumer table.

Please ignore any errors, if any in postgresql function.

Thanks for help me.

[bork]

Hello

To get the Notice messages from the PostgreSQL server you should use the OnNotice event of TPgConnection.

[hughespa]

Is there a way to do this with UniDAC components though?

Regards, Paul.

[bork]

The PostgreSQL notice message is a PostgreSQL feature and is not supported by UniDAC. We plan to implement the possibility of handling warning or notice messages by UniDAC, but it is in the investigating phase only.

[hughespa]

It would be very useful.

Regards, Paul.