Hi All.
Let's say an app searches for some rows and creates "propositions" (new rows). Propositions are presented to the user and (s)he should be able to decide if the row should stay in DB (commit) or should be deleted (rollback).
I am wondering what is best in this case:
create temporary table for every table (*) in which "propositions" resides
add "mark" column to each table marked with * in point 1 to know that the row is temporary
??? (maybe some other method is better)
May you suggest, please?
Best regards,
Jacek