On Tue, Dec 05, 2006 at 17:31:53 +0530, deepak pal <deepak.05pal@xxxxxxxxx> wrote: > hi can we make a field auto incrementing field using Time Stamp data type You can use a column default that uses current_timestamp for its expression. If you also want to handle updates or override cases where people supply values for that column, then you should look at using before triggers.