Asynchronni udalosti v Pg (dbms_alert-like)

[Jan Kasprzak]

Horak Daniel wrote:
: > 	potreboval bych v Pg klientovi cekat, az mu nekdo do jeho
: > tabulky da nejaky zaznam. Polling ve stylu "SELECT count(*) 
: > FROM tabulka"
: > kazdou vterinu mi neprijde rozumny. Oracle ma takove ty dbms_alerty,
: > na ktere muze jeden klient cekat a druhy je muze posilat (napriklad
: > z triggeru ktery visi na INSERTu do te tabulky).
: > 
: > 	Umi Pg neco takoveho?
: 
: viz NOTIFY (http://www.postgresql.org/idocs/index.php?sql-notify.html),
: LISTEN (http://www.postgresql.org/idocs/index.php?sql-listen.html)
: 
	Jo. Tohle je presne ono. Diky.

-Y.

-- 
| Jan "Yenya" Kasprzak  <kas at {fi.muni.cz - work | yenya.net - private}> |
| GPG: ID 1024/D3498839      Fingerprint 0D99A7FB206605D7 8B35FCDE05B18A5E |
| http://www.fi.muni.cz/~kas/   Czech Linux Homepage: http://www.linux.cz/ |
|-- If you start doing things because you hate others and want to screw  --|
|-- them over the end result is bad.   --Linus Torvalds to the BBC News  --|