Snort mailing list archives
Re: postgres schema error
From: Frank Knobbe <fknobbe () knobbeits com>
Date: 28 Apr 2003 12:08:00 -0500
On Mon, 2003-04-28 at 11:38, Martin A. Brooks wrote:
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: [...] 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.
Yes, this has been reported a couple times now. :) I'm curious why this is just now being discovered so frequently. Is everyone only recently upgrading from Postgres 6.x to 7? Cheers, Frank
Attachment:
signature.asc
Description: This is a digitally signed message part
Current thread:
- postgres schema error Martin A. Brooks (Apr 28)
- Re: postgres schema error Frank Knobbe (Apr 28)
- Re: postgres schema error Martin A. Brooks (Apr 28)
- Re: postgres schema error Frank Knobbe (Apr 28)