Patchwork [3/5] pgsql schema: fix timestamp default value

login
register
mail settings
Submitter Eric Leblond
Date Aug. 1, 2012, 9:27 p.m.
Message ID <1343856436-11129-4-git-send-email-eric@regit.org>
Download mbox | patch
Permalink /patch/174605/
State Accepted
Headers show

Comments

Eric Leblond - Aug. 1, 2012, 9:27 p.m.
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(-)
Pablo Neira - Aug. 3, 2012, 9:29 a.m.
On Wed, Aug 01, 2012 at 11:27:14PM +0200, Eric Leblond wrote:
> Set timestamp default value to now() not now which is the time at
> table creation.
> 
> Reported-by: Mr Dash Four

Applied, thanks.
--
To unsubscribe from this list: send the line "unsubscribe netfilter-devel" in
the body of a message to majordomo@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html

Patch

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);