Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > =?iso-8859-2?Q?...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 3021 of 3323
Post > Topic >>

=?iso-8859-2?Q?Monitoring_new_records?=

by messias@[EMAIL PROTECTED] (=?iso-8859-2?Q?messias?=) Feb 28, 2008 at 08:06 PM

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



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
 




 4 Posts in Topic:
=?iso-8859-2?Q?Monitoring_new_records?=
messias@[EMAIL PROTECTED]  2008-02-28 20:06:42 
Re: Monitoring new records
andrej.groups@[EMAIL PROT  2008-02-29 10:30:40 
=?iso-8859-2?Q?Re:_Re:__Monitoring_new_records?=
messias@[EMAIL PROTECTED]  2008-02-29 13:16:00 
Re: Monitoring new records
sdavis2@[EMAIL PROTECTED]  2008-02-29 08:00:15 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 4:54:56 CST 2008.