crc function
| От | Horst Herb |
|---|---|
| Тема | crc function |
| Дата | |
| Msg-id | 003001c01fa6$56c8b440$0100a8c0@hugin обсуждение исходный текст |
| Список | 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 andCRC). 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 functionthat calculates the checksum, and all derived tables would automatically inherit that function? How would the functionknow 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 calculatingthe checksum and iserting the value into the CRC column, but I would prefer to have this function on the serverside and automatically executed without fail. Regards, Horst
В списке pgsql-general по дате отправления: