Alam Surya wrote:
hello all......
I have a litle question, do i have acces linux command from postgresql
query like send message to others linux user in LAN ? any feature for that ?
You could use a system() call in a C function, or you could use Peter
Eisentraut's pl/sh language:
http://webmail.postgresql.org/~petere/plsh.html
Of course, if you use trigger functions to send email messages you
lose transactional integrity with respect to the underlying data vs.
the email message in the face of a transaction abort. Therefore some
people do this in middleware after the transaction associated with the
email message has been committed.
Hope that helps,
Mike Mascari
ma*****@mascari.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
