Page 1 of 1

Notification support for Postgresql

Posted: 02.03.2006, 21:21
by snorkel
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

Posted: 02.03.2006, 23:00
by danied
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

Posted: 29.06.2006, 12:52
by zoap
Definitely agree.

Posted: 07.11.2008, 17:04
by snorkel
Anyone know if postgresql notifications work with the latest Zeos?

Posted: 08.11.2008, 09:49
by mdaems
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