X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C9E8DD1B564 for ; Thu, 29 Jul 2004 04:30:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87108-08 for ; Thu, 29 Jul 2004 07:30:36 +0000 (GMT) Received: from houston.familyhealth.com.au (fhnet.arach.net.au [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id 04D64D1B541 for ; Thu, 29 Jul 2004 04:30:29 -0300 (ADT) Received: from [192.168.0.40] (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9p1/8.12.9) with ESMTP id i6T7URUi037801; Thu, 29 Jul 2004 15:30:27 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <4108A7B3.2080602@familyhealth.com.au> Date: Thu, 29 Jul 2004 15:30:59 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707) X-Accept-Language: en-us, en MIME-Version: 1.0 To: azah azah Cc: pgsql-php@postgresql.org Subject: Re: default timestamp in postresql References: <235b1a280407290016621836b4@mail.gmail.com> In-Reply-To: <235b1a280407290016621836b4@mail.gmail.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/39 X-Sequence-Number: 2864 > 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