how to detect last change

Started by Jan Poslusnyabout 22 years ago2 messagesgeneral
Jump to latest
#1Jan Poslusny
pajout@gingerall.cz

Hi,
is some 'technical' way to detect where the last change (i.e. insert or
update or delete) was performed on specified table ?
I know I can write appropriate triggers, but I am interesting in
exploring these informations from postgreSQL guts...

Regards, pajout.

#2Jan Poslusny
pajout@gingerall.cz
In reply to: Jan Poslusny (#1)
Re: how to detect last change

Sorry, WHEN the last change...

Jan Poslusny wrote:

Show quoted text

Hi,
is some 'technical' way to detect where the last change (i.e. insert
or update or delete) was performed on specified table ?
I know I can write appropriate triggers, but I am interesting in
exploring these informations from postgreSQL guts...

Regards, pajout.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster