Hi, Peter,
Peter Manchev wrote:
> Is it possible to get the last time(stamp) when the content of a given
> table in pgsql has changed???
My solution would be to add a trigger to the table which updates a
timestamp in a second table on every insert/update/delete.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
