On Wed, 2007-05-09 at 14:20 +0100, Darren Bird wrote:
> Is there a way of asking Postgresql if a particular table was changed
> without going back through the logs - like a last modified flag or
> even just a changed flag?
If the table change caused a rewrite of the table it will have a new
relfilenode (and a new file in the data directory).
You might look at that file's creation time. This will not catch all
modifications to the table.
Hope that helps,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
