thanks all, it solve now. On Thu, 29 Jul 2004 15:30:59 +0800, Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx> wrote: > > Previously in mysql table field as below , will be add automatic in > > database when execute insert statement. > > > > = submittime timestamp NOT NULL > > > > But in postresql the timestamp cannot insert automatic when execute > > insert statement. > > How can I solve this problem instead of change the php code? > > Make it: > > submittime timestamp not null default current_timestamp > > Chris > >