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.
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? |