This is a discussion on Server side communication within the pgsql Novice forums, part of the PostgreSQL category; --> These are probably quite silly questions: 1. Can Postgres initiate any communication to client side? 2. Is there a ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| These are probably quite silly questions: 1. Can Postgres initiate any communication to client side? 2. Is there a way to run a timer to fire a trigger in a database in postgres? Thanx ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
| ||||
| Alex du Plessis <alexdup01@telkomsa.net> schrieb: > These are probably quite silly questions: > > 1. Can Postgres initiate any communication to client side? IIRC: no. For what reason do you need this? We have LISTEN/NOTITY, is this a solution? > > 2. Is there a way to run a timer to fire a trigger in a database in > postgres? No, but we have tools like CRON for such jobs. And, a TRIGGER is fired on INSERT or UPDATE or DELETE, but not on a specific time. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
| Thread Tools | |
| Display Modes | |
|
|