Re: How to make 'tail -f' in PostgreSQL? - Mailing list pgsql-admin

In article <3BBA0C49.226148@sochi.net.ru>, "Michael B. Babakov"
<M.Babakov@sochi.net.ru> wrote:

> Do you know how in PostgreSQL to do the receipt of datas in process of
> their
> entering as a programm 'tail-f' or need to check in cycle new records
> entering
> every seconds?
>

Well, this would require a sort of "continuous transaction" against a
table, which is a paradox--you only get to see the database at a given
point in time BETWEEN other transactions.

You probably want to look into the NOTIFY command.  The applications
writing data could issue a NOTIFY to indicate when they have written a
row, and the applications reading data could re-run their query when they
receive a NOTIFY event.

--
Jeff Boes                                             vox 616.226.9550
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                      jboes@nexcerpt.com