I have a table that I want to keep track of the user who last modified
it and the timestamp of the modification. Should I use a trigger or a rule?
CREATE TABLE stampedtable (stampedtableid SERIAL PRIMARY KEY,updatestamp timestamp NOT NULL DEFAULT now(),updateuser
nameNOT NULL DEFAULT current_user,sometext text
);
I suspect that I want a rule, but all the examples in the documentation
seem to update a separate table and not override (or add) the
insert/update to the timestamp and name columns.
Thanks,
-Neal
