SF.net SVN: ledger-smb: [1259] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1259
          http://svn.sourceforge.net/ledger-smb/?rev=1259&view=rev
Author:   linuxpoet
Date:     2007-06-06 18:38:03 -0700 (Wed, 06 Jun 2007)

Log Message:
-----------
fixed default of current_date to now()

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-07 01:30:49 UTC (rev 1258)
+++ trunk/sql/Pg-database.sql	2007-06-07 01:38:03 UTC (rev 1259)
@@ -198,7 +198,7 @@
 
 CREATE TABLE note (id serial primary key, note_class integer not null references note_class(id), 
                    note text not null, vector tsvector not null, 
-                   created timestamp not null default current_date);
+                   created timestamp not null default now());
 
 CREATE TABLE entity_note() INHERITS (note);
 ALTER TABLE entity_note ADD CHECK (id = 1);


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.