[Snort-devel] patch for doc/create_postgresql

Chris Green cmg at ...402...
Fri Apr 25 12:20:01 EDT 2003


Frank Knobbe <fknobbe at ...337...> writes:

> On Fri, 2003-04-25 at 13:16, Chris Green wrote:
>> Does timestamp exist prior to 7.3.x?
>
> It did, but only as a 4 byte long, with 1 sec precision. I check until
> 6.3 back. DATETIME was preferred back then due to a higher resolution,
> being 8 bytes.
>
> Starting with Postgres 7 DATETIME seems to have been abandoned in favor
> of TIMESTAMP which is now 8 bytes with a 1 microsec resolution and valid
> timespan/lifetime past a couple future ice ages (AD1465001).
>
> Time stamp with time zone, while 1 usec precision last only until 2037,
> as pretty much the rest of the known Unix universe :)


Thanks for the knowledge. I will need to add that Postgres 7 is a
requirement for snort+pgsql.

Thanks,
Chris
-- 
Chris Green <cmg at ...402...>
A good pun is its own reword.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 188 bytes
Desc: not available
URL: <https://lists.snort.org/pipermail/snort-devel/attachments/20030425/8f86bbd3/attachment.sig>


More information about the Snort-devel mailing list