Notification support for Postgresql

snorkel · Post by **snorkel** » 02.03.2006, 21:21

The Postgresql side of things really needs to have notification support.
Currently if you execut a function that uses raise notice, zeos has no way of getting that notice from the server.

The commercial PostgresDAC supports this, they have a event on the connection/database component called OnNotice, and it fires when notifcations are available.

I would love to start using Zeos again but can't until this feature is implemented.

Thanks,

Snorkel

danied · Post by **danied** » 02.03.2006, 23:00

I agree.
I have a database, I have implemented some notices in the database side, waiting for the possibility to have them raised at the application level.
Important function for me also.

Thanks

Daniel

zoap · Post by **zoap** » 29.06.2006, 12:52

Definitely agree.

snorkel · Post by **snorkel** » 07.11.2008, 17:04

Anyone know if postgresql notifications work with the latest Zeos?

Post by **mdaems** » 08.11.2008, 09:49

Yes,

I do know nobody showed up to convert the TZIBEventAlerter to a Postgres EventAlerter. There's one advatage for somebody who wants to convert it now : the TZIBEventAlerter is now part of the zeosdbo package itself.

No,

Support for postgresql is still not available.

So please, just make it available. If you implement it as a copy of the IB implementation, you can publish it here as a separate download. If you take the effort of making a database independent component with supporting dbc classes (= the good way) then I'll do everything to include it in the official 7.X release.

Mark