Re: Notes on converting from MySQL 5.0.x to PostgreSQL

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Jason McManus <mcmanus(dot)jason(at)gmail(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Date: 2006-07-01 00:13:31
Message-ID: 20060701001331.GR17241@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-www

On Fri, Jun 30, 2006 at 11:01:19AM -0700, David Fetter wrote:
> On Fri, Jun 30, 2006 at 01:41:53PM -0400, Tom Lane wrote:
> > David Fetter <david(at)fetter(dot)org> writes:
> > > On Fri, Jun 30, 2006 at 11:39:04AM -0400, Tom Lane wrote:
> > >> It might be worth pointing out that mysql's replication falls
> > >> over if you so much as look at it crosseyed. I have not had to
> > >> use it for production purposes, but I can tell you that the mysql
> > >> replication regression tests fail ... irreproducibly of course
> > >> ... almost one time in two in Red Hat's build environment.
> >
> > > Are those tests, or at least descriptions of them, available?
> >
> > Sure, it's just the standard "make test" sequence in mysql's source.
>
> Uh oh. I'm a little worried about writing tests based on GPLed code
> for Slony-I or other replication systems. Might these need to be
> clean-roomed?

Is there actually a lack of ideas for our regression tests, or a lack of
people/motivation to work on them?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-07-01 00:15:00 Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Previous Message Jim C. Nasby 2006-06-30 23:52:48 Re: Is it possible to disable insert/update/delete triggers for one transaction and not another?

Browse pgsql-www by date

  From Date Subject
Next Message Jim C. Nasby 2006-07-01 00:15:00 Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Previous Message Josh Berkus 2006-06-30 23:13:07 Re: PostgreSQL and success of OSS