| From: | messias <messias(at)fw(dot)hu> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Monitoring new records |
| Date: | 2008-02-28 19:06:42 |
| Message-ID: | E1JUo5a-0007ok-00@osiris.swi.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | s anwar | 2008-02-28 19:53:51 | Postgres 8.3 - C function taking and returning arrays |
| Previous Message | Ennio-Sr | 2008-02-28 16:44:56 | pidof not working for postgresql-8.3 ? |