Re: History functionality

[Quoted] "Michel Cadot" <micadot{at}altern{dot}org> writes:

>>Now i need to have a history funtionality for a few of my
>>tables. This must include the old values, time and date of change
>>and user who changed the value.

>Have a look at triggers:

Yes, triggers are the way to do it. But it seems that wanting history on tables is very common and perhaps even the main use of triggers. Given a table definition it is possible to generate a history table and triggers to update the history. Is there a program to generate these definitions automatically?

-- 
Ed Avis <ed_at_membled.com>