A desperate newbie question:

I have a _lot_ of tables, where a crc checksum needs to be calculated after every 
insert/update on all fields (but OID and CRC). I have no problems writing my external 
crc function, but:

 What would be the most elegant way to achieve that? Could I use inheritance in a way 
to implement a rule / trigger function that calculates  the checksum, and all derived 
tables would automatically inherit that function? How would the function know about 
the different columns?

It would be a nightmare writing an extra function for each and every table. Up to now, 
the client software is calculating the checksum and iserting the value into the CRC 
column, but I would prefer to have this function on the server side and automatically 
executed without fail.

Regards,
Horst


Reply via email to