Data in table changed?

Поиск
Список
Период
Сортировка
От Thomas Holmgren
Тема Data in table changed?
Дата
Msg-id 004801c4005f$471be4c0$0200000a@BALSAM
обсуждение исходный текст
Ответы Re: Data in table changed?  (Stephen Frost <sfrost@snowman.net>)
Re: Data in table changed?  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
Re: Data in table changed?  ("Karl O. Pinc" <kop@meme.com>)
Re: Data in table changed?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all,

I have a large number of clients synchronizing with a central database.
The clients update their local data by polling the database for changes
at fixed intervals. I need an efficient way of determining if data in a
table has been changed (either updated, deleted or inserted). Can this
be achieved without scanning the tables using expensive SQL? (my tables
are _big_!) Is there some way to get a "time for last update" for a
specific table? Or something similar I can use?

Thank you :)

Kind regards,
Thomas Holmgren
Denmark


--
Mvh.
Thomas Holmgren



В списке pgsql-general по дате отправления:

Предыдущее
От: Alexander Cohen
Дата:
Сообщение: More info on table fields
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Data in table changed?