<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top"><span class=""
id="result_box"lang="en"><span class="hps">check</span> <span class="hps">the log of</span> <span
class="hps">postgresql,</span><span class="hps">there</span> <span class="hps">you can take the</span> <span
class="hps">tablename</span> <span class="hps">and the date of</span> <span class="hps">the
modification</span></span><br/><br /><hr style="width: 100%; height: 2px;" /><br />Ing. Lennin Caro Pérez<br />
Usuario:GNU/LINUX<br/> PHP Developer<br /> PostgreSQL DBA<br /> Oracle DBA<br /> Linux counter id 474393<br /><br />---
On<b>Mon, 2/27/12, Tatsuo Ishii <i><ishii@postgresql.org></i></b> wrote:<br /><blockquote style="border-left: 2px
solidrgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br />From: Tatsuo Ishii <ishii@postgresql.org><br
/>Subject:Re: [HACKERS] How to know a table has been modified?<br />To: Kevin.Grittner@wicourts.gov<br />Cc:
pgsql-hackers@postgresql.org<br/>Date: Monday, February 27, 2012, 12:04 PM<br /><br /><div class="plainMail">>>
ForTRIGGER, I cannot thinking of any way. Any idea will be<br />>> welcome.<br />> <br />> It would
requirecreating "cooperating" triggers in the database and<br />> having a listener, but you might consider the<br
/>>triggered_change_notifications() trigger function included in 9.2. <br />> It works at least as far back as
9.0;I haven't tried it any further<br />> back.<br /><br />Thanks for the info. It's a little bit overkill for my
purposethough.<br />(on busy systems, the notification would be too frequent).<br /><br />I would think that creating a
smallroutine periodically consults<br />pg_stat_all_tables view and records the last update datetime for each<br
/>table(unfortunately the view does not have last modification date).<br />--<br />Tatsuo Ishii<br />SRA OSS, Inc.
Japan<br/>English: <a href="http://www.sraoss.co.jp/index_en.php"
target="_blank">http://www.sraoss.co.jp/index_en.php</a><br/>Japanese: <a href="http://www.sraoss.co.jp"
target="_blank">http://www.sraoss.co.jp</a><br/><br />-- <br />Sent via pgsql-hackers mailing list (<a
href="/mc/compose?to=pgsql-hackers@postgresql.org"
ymailto="mailto:pgsql-hackers@postgresql.org">pgsql-hackers@postgresql.org</a>)<br/>To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgsql-hackers"
target="_blank">http://www.postgresql.org/mailpref/pgsql-hackers</a><br/></div></blockquote></td></tr></table>
