Glen Eustace wrote:
Is there some way that one can determine whether a table has changed
i.e. an insert, delete, update, without having to resort to setting a
flag in another table using a triger or rule.
I was wondering whether one of the system relations keep track of
whether a table has been modifed.
How soon do you need to know that a change has occured? I suppose one
could monitor the log. You'd want to keep track of where in the log your
script read up to the last time, in order to avoid having to run through
from the beginning each time.
And you'd want to ensure that you scan the log right before it's
rotated, of course.
A bit of a hack ...
b
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
