backend triggers communication with front-end
<html><div style='background-color:'><DIV>
<DIV class=RTE>
<DIV class=RTE>
<DIV class=RTE>
<DIV class=RTE>Hello everyone,</DIV>
<DIV class=RTE>I am searching for a way to have my postgresql 7.4.7 backend be triggered to let the front end know there has been a change to the database. If more then one person is connected to the database and person (x) makes a change, I want other clients to then be aware of that, and refresh there screen so they are not then looking at out of date data. </DIV>
<DIV class=RTE>Any insight? Thank you so much, have a great day.</DIV>
<DIV class=RTE>Adam O'Toole </DIV></DIV></DIV></DIV></DIV></div></html>
See "27.6. Asynchronous Notification" in documentation of ideas on how to
accomplish this.
On Tuesday 26 July 2005 05:22 pm, Adam O'Toole saith:
Show quoted text
Hello everyone,
I am searching for a way to have my postgresql 7.4.7 backend be triggered
to let the front end know there has been a change to the database. If more
then one person is connected to the database and person (x) makes a change,
I want other clients to then be aware of that, and refresh there screen so
they are not then looking at out of date data. Any insight? Thank you so
much, have a great day.
Adam O'Toole
Hi there.
I am connecting to my Postgresql 7.4.7 sever with psql-odbc from my VB.NET
frontend. Right now I am using the Postgres server IP address in the odbc
connection string. My question, I want to use a DNS server, how will my
connection string change. Will I just specify the DNS address for the
�SERVER=� parameter in the connection string, or will I specify a new
parameter �DNS=�. Here is my connection string right now:
OdbcConnection.ConnectionString =
"Protocol=6.4;Debug=0;Parse=0;SERVER=10.4.1.179;DRIVER=PostgreSQL;
ConnSettings=;MaxLongVarcharSize=8190;MaxVarcharSize=254;Socket=4096;TrueIsMinus1=0;DATABASE=mediaRegistry;Optimizer=1;UID=****;PWD=****;
Thank you!
Hi there.
I am connecting to my Postgresql 7.4.7 sever with psql-odbc from my VB.NET
frontend. Right now I am using the Postgres server IP address in the odbc
connection string. My question, I want to use a DNS server, how will my
connection string change. Will I just specify the DNS address for the
�SERVER=� parameter in the connection string, or will I specify a new
parameter �DNS=�. Here is my connection string right now:
OdbcConnection.ConnectionString =
"Protocol=6.4;Debug=0;Parse=0;SERVER=10.4.1.179;DRIVER=PostgreSQL;
ConnSettings=;MaxLongVarcharSize=8190;MaxVarcharSize=254;Socket=4096;TrueIsMinus1=0;DATABASE=mediaRegistry;Optimizer=1;UID=****;PWD=****;
Thank you!