Snort DB schema for Postgresql has wrong data type "datetime"

[Roberto Suarez Soto <robe () alfa21 com>]

Hi,
        I've just tried to create the DB schema needed for storing Snort data
in a Postgresql database, and it fails because it uses the "datetime" type,
which is not available. I don't know exactly when it stopped to be available,
but my PG version is 7.3.2r1 (latest in Debian "sid").

        I've substituted it for "timestamp", as I found several references on
the web that adviced it. Now I'm yet to try if it works :-) But I wanted to
comment here in case this is something known for everyone since a long time
ago, and I'm the last to realize r:-)

-- 
Roberto Suarez Soto                                     Alfa21 Outsourcing
    robe () alfa21 com                               http://www.alfa21.com


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