From: | "Horst Herb" <hherb(at)malleenet(dot)net(dot)au> |
---|---|
To: | <pgsql-general(at)hub(dot)org> |
Subject: | crc function |
Date: | 2000-09-16 06:20:35 |
Message-ID: | 003001c01fa6$56c8b440$0100a8c0@hugin |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jarmo Paavilainen | 2000-09-16 08:32:30 | CREATE USER and ODBC |
Previous Message | lec | 2000-09-16 04:42:30 | Re: 7.0.2 and 6.5.3 performance |