I have a table where one of the attributes is the time a row was inserted:
'updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP'.
Is there a way to define this attribute so that a user cannot override the
default value? I have tried this constraint, but it fails for any INSERT:
'updated ... CHECK (updated = CURRENT_TIMESTAMP)'.
___________________________________
Michael Klatt
University of Oklahoma
Environmental Verification and Analysis Center
710 Asp Avenue, Suite 8
Norman, OK 73069
405.447.8412
405.447.8455 FAX
http://www.evac.ou.edu/
"I'm a great motivator. Everyone says they have to work twice as hard when
I'm around."