[xept]

For Django there's https://github.com/Opus10/django-pgtrigger that makes it possible to define triggers right in your models, so you have everything in one place.