Thread: backend triggers communication with front-end

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
changeto the database. If more then one person is connected to the database and person (x) makes a change, I want
otherclients 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 

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:
> 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!