crc function

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

Browse pgsql-general by date

  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