From the name of the field, I though you meant to want auto_now_add not auto_now so that it takes now date only when creating the row (not when updating the row). However, although this might solve your problem, but I can't understand why your trigger did not work fine.. please can you share your tg_fun_name function difinition.