From patchwork Wed Aug 1 21:27:14 2012 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Eric Leblond X-Patchwork-Id: 174605 Return-Path: X-Original-To: incoming@patchwork.ozlabs.org Delivered-To: patchwork-incoming@bilbo.ozlabs.org Received: from vger.kernel.org (vger.kernel.org [209.132.180.67]) by ozlabs.org (Postfix) with ESMTP id 4E3B12C009B for ; Thu, 2 Aug 2012 07:28:38 +1000 (EST) Received: (majordomo@vger.kernel.org) by vger.kernel.org via listexpand id S1755421Ab2HAV2g (ORCPT ); Wed, 1 Aug 2012 17:28:36 -0400 Received: from ks28632.kimsufi.com ([91.121.96.152]:49518 "EHLO ks28632.kimsufi.com" rhost-flags-OK-OK-OK-OK) by vger.kernel.org with ESMTP id S1755468Ab2HAV2f (ORCPT ); Wed, 1 Aug 2012 17:28:35 -0400 Received: from ip-92-50-100-48.unitymediagroup.de ([92.50.100.48] helo=tiger.regit.org) by ks28632.kimsufi.com with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.72) (envelope-from ) id 1SwgT4-0005bd-Jc; Wed, 01 Aug 2012 23:28:34 +0200 From: Eric Leblond To: netfilter-devel@vger.kernel.org Cc: Eric Leblond Subject: [PATCH 3/5] pgsql schema: fix timestamp default value Date: Wed, 1 Aug 2012 23:27:14 +0200 Message-Id: <1343856436-11129-4-git-send-email-eric@regit.org> X-Mailer: git-send-email 1.7.10.4 In-Reply-To: <1343856436-11129-1-git-send-email-eric@regit.org> References: <1343856436-11129-1-git-send-email-eric@regit.org> Sender: netfilter-devel-owner@vger.kernel.org Precedence: bulk List-ID: X-Mailing-List: netfilter-devel@vger.kernel.org Set timestamp default value to now() not now which is the time at table creation. Reported-by: Mr Dash Four --- doc/pgsql-ulogd2.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/pgsql-ulogd2.sql b/doc/pgsql-ulogd2.sql index 0fc2b45..dc954ed 100644 --- a/doc/pgsql-ulogd2.sql +++ b/doc/pgsql-ulogd2.sql @@ -62,7 +62,7 @@ CREATE TABLE ulog2 ( ip_fragoff smallint default NULL, label smallint default NULL, mac_id bigint default NULL, - timestamp timestamp NOT NULL default 'now' + timestamp timestamp NOT NULL default now() ) WITH (OIDS=FALSE); CREATE INDEX ulog2_oob_family ON ulog2(oob_family);