postgres schema error

["Martin A. Brooks" <martin () clues ltd uk>]

Hi

I've been attempting to install snort on a Debian system and have it log to 
postgres.  I had a look at the schema before creating the tables and I 
noticed this:

CREATE TABLE schema ( vseq        INT4     NOT NULL,
                      ctime       DATETIME NOT NULL,
                      PRIMARY KEY (vseq));

Postgres 7.3.2 does not have a DATETIME data type, I believe it uses 
"timestamp" instead. So a simple :%s/DATETIME/TIMESTAMP/g cosmetically 
fixes the problem.

Would anyone care to confirm/deny this is the case?

Regards


Martin A. Brooks, Clues Ltd
http://www.clues.ltd.uk/ 



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users