Monitoring new records - Mailing list pgsql-novice

From messias
Subject Monitoring new records
Date
Msg-id E1JUo5a-0007ok-00@osiris.swi.hu
Whole thread Raw
Responses Re: Monitoring new records  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
List pgsql-novice
Hello



I am new in SQL programing and I have a problem. I would like to

monitor the new records which is inserted into an SQL table.

I found some solution which mentioned a queue (log) table which can

be filled by a trigger. The client would read from that queue table,

and delete the readed data.

I think this solution can work with only one client.

But I would have more than one client at the same time, and I do not

know how I can delete the data from the queue table.

I can make queue table for every client, but I think this is not a

nice solution.

I am affraid of lost client....

I am intrested in every solution which can solve my problem.



Any help would is appreciated.



Thanks Ferenc Banhidi



pgsql-novice by date:

Previous
From: "s anwar"
Date:
Subject: Postgres 8.3 - C function taking and returning arrays
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Monitoring new records