Re: Questions about database (PostgreSQL)

[Jed Pickel <jed () pickel net>]

On Thu, Jul 26, 2001 at 04:03:27PM -0400, Jason Robertson wrote:
> Why not for postgres at least, use foreign keys.  
> As I have to change the create_postgresql file each time 
> to tie them in like that.. I use them primarily for cleaning the database.

Good idea... I'll add Postgresql foreign keys in the next version of
the schema.
 
> This is what I have for that though using scheme 102 (I haven't had time to 
> change 103, though the changes do get annoying) (I might actually just 
> do an update script for this, instead)

I'm working on a tool to generate consistent schemas across mysql,
postgresql, oracle, etc that will be more user friendly than the
current method of creating the database tables. This should also make
adding and maintaining support for more databases easier. Once I get
the basics tackled I'll add migration support so upgrading schemas
will be automatic.

* Jed

_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
http://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users