Postgresql reception message from database

nestermihai · Post by **nestermihai** » 05.12.2008, 09:52

How can reception message from database Postgresql 8 in application write in Lazarus?
For example: user send comand for delete record, and in Postgrsql 8 in triger DELETE, for this record, appli RAISE EXCEPTION 'Operatiune message.....!';
How can reception this message in Lazarus application when use Zeoslib components?

Tanks very much!

mariuszekpl · Post by **mariuszekpl** » 05.12.2008, 12:13

can you publish sample application ?
You don't have EXCEPTION MESAGE ?

Post by **seawolf** » 05.12.2008, 12:44

I suppose you need to use listen and notify function which are currently not implemented

btrewern · Post by **btrewern** » 05.12.2008, 15:14

LISTEN and NOTIFY are slightly different. I think the OP is talking about RAISE NOTICE and RAISE EXCEPTION which can be used in stored procedures to display messages. See here http://www.postgresql.org/docs/8.3/inte ... sages.html

I thought there was a patch in the testing version which logged these messages to the TZSQLMonitor file. Can't find the forum thread at the moment.

Ben

Post by **mdaems** » 06.12.2008, 15:15

btrewern,

You're talking about
- Topic http://zeos.firmos.at/viewtopic.php?t=2021
- Commit 487 in testing branch (Single feature patch)
- Commit 491 which merged this feature to 6.6-patches
- Release 6.6.4 : already contains this 'feature'

Mark