Timestamps for BLOB fields

From: Jason Larke <jlarke(at)uu(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Timestamps for BLOB fields
Date: 2001-04-13 22:26:33
Message-ID: 200104132226.SAA03821@anthem.aa.ans.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm putting together a small database to track communication with
our customers as we make some changes to our service. I want the
database to store a diary of all the email we have with each
customer on this subject, and I'm using BLOBs to store that
information.

I also want to have a timestamp for the last change date of this
email diary, so we can easily see which customers we haven't
talked to lately.

Normally I'd do this with a trigger, but I'm not sure how to do
that in this case. Once the diary is created, the oid for it
doesn't change, so I can't trigger on the diary field in the
table. The actual contents of the BLOB are in a system table and
I can't trigger on them.

Anyone have any ideas? Should I just depend on the client to
update the timestamp? That certainly wouldn't be hard, but it
feels sloppy.

Thanks for any help you can provide.

Browse pgsql-general by date

  From Date Subject
Next Message John Havard 2001-04-13 22:30:12 Re: Using pl/pgsql or sql for in/out functions for types
Previous Message Lamar Owen 2001-04-13 20:42:56 Re: Shared memory failure?