Search Postgresql Archives

Storing old and new tuple values after an UPDATE, INSERT or DELETE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Is it possible to modify source code in executor to keep a log of old tuples
and new tuples after an UPDATE, INSERT or DELETE command is executed? (so
basically Store Old Tuple Values -> UPDATE/INSERT/DELETE Command -> Store
New Tuple Values)

For example is it possible to modify the execMain.c file in
backend/executor/ such that before the ExecutorRun you save the tuples in a
log file and after running ExecutorRun you log the new tuples also. 
How can this be achieved  (if at all possible)?
 If it is not possible to do this by modifying execMain.c file how else can
I do it? (may be nodeModifyTable.c)

Please correct me if my understanding is wrong. I am new to Postgresql and
to source code programming specially. 
I would really appreciate it a lot. Thank you in advance. 
-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/Storing-old-and-new-tuple-values-after-an-UPDATE-INSERT-or-DELETE-tp3269108p3269108.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux