Re: How to make 'tail -f' in PostgreSQL?

In article <3BBA0C49(dot)226148(at)sochi(dot)net(dot)ru>, "Michael B. Babakov"
<M(dot)Babakov(at)sochi(dot)net(dot)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(at)nexcerpt(dot)com