Unix Technical Forum

Server side communication

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 09:55 PM
Alex du Plessis
 
Posts: n/a
Default Server side communication

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 09:55 PM
Andreas Kretschmer
 
Posts: n/a
Default Re: Server side communication

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:37 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com