Re: Server side communication - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: Server side communication
Date
Msg-id 20060601181140.GC4899@KanotixBox
Whole thread Raw
In response to Server side communication  (Alex du Plessis <alexdup01@telkomsa.net>)
List pgsql-novice
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°

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: SQL Count Magic Required.... First Iteration...
Next
From: Sean Davis
Date:
Subject: Re: SQL Count Magic Required.... First Iteration...