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: | Raw Message | Whole Thread | 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 ? |