| Lists: | pgsql-generalpgsql-novice |
|---|
| From: | "Adam O'Toole" <adamnb1(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | backend triggers communication with front-end |
| Date: | 2005-07-26 21:22:58 |
| Message-ID: | BAY102-F240E3EB4D909385996A689FBCD0@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-novice |
<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>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 663 bytes |
| From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: backend triggers communication with front-end |
| Date: | 2005-07-27 11:13:53 |
| Message-ID: | 200507270713.53116.terry@esc1.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-novice |
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
| From: | "Adam O'Toole" <adamnb1(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | connection string - DNS |
| Date: | 2005-08-04 16:30:12 |
| Message-ID: | BAY102-F37983FF4F04181E57224E6FBC40@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-novice |
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!
| From: | "Adam O'Toole" <adamnb1(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | connection string - DNS |
| Date: | 2005-08-04 16:32:09 |
| Message-ID: | BAY102-F37A8622D5E299FF3B60585FBC40@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-novice |
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!
| From: | "Adam O'Toole" <adamnb1(at)hotmail(dot)com> |
|---|---|
| To: | adamnb1(at)hotmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: connection string - DNS |
| Date: | 2005-08-08 15:34:06 |
| Message-ID: | BAY102-F3638EA1D6E64E9413D8DD5FBB80@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-novice |
Any insight on this at all? I can't seem to find any info on it else-where..
Thanks