R: Auto_increment vs SERIAL key types

2006-10-11 Thread Giampaolo Tomassoni
> > Of course, the underlying sql engine has to support views > (5.0, but I use 4.1) > > and, most important, updates to a view. Maybe I'm wrong, but > > this is something that mysql doesn't do. Besides, that's one > > of the reasons for which I prefer much more postgresql. > > > But postgresql

R: Auto_increment vs SERIAL key types

2006-10-10 Thread Giampaolo Tomassoni
> Another issue may be AWL files, (I suppose a spamassassin question > also?). Every 'new' ip/email incoming will create a new PRIMARY KEY > (username,email,ip). If two connections, one on each box, first one > wins, replication stops and you need to manually issue a bunch of > commands to skip

R: Auto_increment vs SERIAL key types

2006-10-10 Thread Giampaolo Tomassoni
> > ...omissis... > > it did does for, say, one year. It may have reached a very high Of course, "high" is instead "low"... > totscore and count. Well, now suppose your reliable source > started sending a lot of spam. Would you like to have to wait a > month or so before its whitelistening sc