Re: Server side communication

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Server side communication
Date: 2006-06-01 18:11:41
Message-ID: 20060601181140.GC4899@KanotixBox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Alex du Plessis <alexdup01(at)telkomsa(dot)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°

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-06-01 18:28:29 Re: SQL Count Magic Required.... First Iteration...
Previous Message operationsengineer1 2006-06-01 18:04:12 Re: SQL Count Magic Required.... First Iteration...