how to detect last change

#1

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

#2

Sorry, WHEN the last change...

Jan Poslusny wrote:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how to detect last change

comp.databases.postgresql.general comp.databases.postgresql.general

how to detect last change - 03-02-2004 , 04:20 AM

Re: how to detect last change - 03-02-2004 , 04:28 AM