RE: [Dbmail] dbmail-2.0.7 released

2005-09-16 Thread Simon Gray
IL PROTECTED] On Behalf Of Alan Glait Sent: 15 September 2005 16:29 To: DBMail mailinglist Subject: Re: [Dbmail] dbmail-2.0.7 released Perhaps stupid question ... I try to upgrade the port with portupgrade ... and i get bash-2.05b# portupgrade -b -r -i dbmail-mysql ---> Session started at: Thu

Re: [Dbmail] dbmail-2.0.7 released

2005-09-15 Thread Alan Glait
Perhaps stupid question ... I try to upgrade the port with portupgrade ... and i get bash-2.05b# portupgrade -b -r -i dbmail-mysql ---> Session started at: Thu, 15 Sep 2005 12:32:27 -0300 ** No need to upgrade 'dbmail-mysql-2.0.4_1' (>= dbmail-mysql-2.0.4_1). (specify -f to force) ---> Listin

Re: [Dbmail] dbmail-2.0.7 released

2005-09-14 Thread Steven Lynn
That is what I had figured on. I was just wondering cause I ran the script and got that error... Thank you. On Wed, 2005-09-14 at 08:46 +0200, Paul J Stevens wrote: > Steven, > > The create script has been running virtually unchanged since 2.0.0 > > This is very likely something specific to mys

Re: [Dbmail] dbmail-2.0.7 released

2005-09-14 Thread Paul J Stevens
Steven, The create script has been running virtually unchanged since 2.0.0 This is very likely something specific to mysql-5. Steven Lynn wrote: > Has anybody run the mysql_create_innodb.sql script on MySQL 5? > > I get an error on: > > CREATE TABLE dbmail_pbsp ( >idnr bigint(21) NOT NULL

Re: [Dbmail] dbmail-2.0.7 released

2005-09-14 Thread Steven Lynn
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has anybody run the mysql_create_innodb.sql script on MySQL 5? I get an error on: CREATE TABLE dbmail_pbsp ( idnr bigint(21) NOT NULL auto_increment, since datetime default '0' not null, ipnumber varchar(40) NOT NULL, PRIMARY KEY (idnr),

RE: [Dbmail] dbmail-2.0.7 released

2005-09-13 Thread Simon Lange
Hi > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Igor Olemskoi > Sent: Monday, September 05, 2005 9:50 PM > To: DBMail mailinglist > Subject: Re: [Dbmail] dbmail-2.0.7 released > > > * Added 'ON UPDATE

Re: [Dbmail] dbmail-2.0.7 released

2005-09-05 Thread Igor Olemskoi
> * Added 'ON UPDATE CASCADE' to all > foreign key restraints in the MySQL (InnoDB) and Postgresql create_table > files. How to apply this to the existing tables?

Re: [Dbmail] dbmail-2.0.7 released

2005-09-05 Thread Paul J Stevens
Leonel Nunez wrote: > to migrate from 2.0.6 to 2.0.7 > Is there a script to add the ON UPDATE CASCADE for PostgreSQL or > we have to look at the create scripts to see those ALTERS :) > > or does not matter if those ON UPDATE CASCADE are not updated Those ON UPDATE CASCADE-s where ad

Re: [Dbmail] dbmail-2.0.7 released

2005-09-05 Thread Leonel Nunez
Paul J Stevens wrote: Dbmail 2.0.7 released This is a bugfix release only. * Removed all unsafe code from the signal handlers. This should mostly benefit FreeBSD users which may have suffered from unreliable behaviour in the process pool code. * Added 'ON UPDATE CASCADE' to all foreign k

[Dbmail] dbmail-2.0.7 released

2005-09-05 Thread Paul J Stevens
Dbmail 2.0.7 released This is a bugfix release only. * Removed all unsafe code from the signal handlers. This should mostly benefit FreeBSD users which may have suffered from unreliable behaviour in the process pool code. * Added 'ON UPDATE CASCADE' to all foreign key restraints in the M