Re: PostgreSQL 8.1 vs. MySQL 5.0?

On Thu, Oct 06, 2005 at 01:46:29PM -0500, Scott Marlowe wrote:
> On Thu, 2005-10-06 at 12:23, Jim C. Nasby wrote:
> > On Thu, Oct 06, 2005 at 10:10:14AM -0500, Scott Marlowe wrote:
> > > But what really bugs me is that some things that ARE bugs simply aren't
> > > getting fixed and probably won't.  Specifically, while mysql understands
> > > fk references made at a table level, it simply ignores, without error,
> > > warning, or notice, fk references made in a column.  arg...  Very
> > > frustrating.  If they just didn't support that syntax it would be much
> > > less bothersome, since I'd try it, get an error, and try the other
> > > syntax.  Instead, I spent an afternoon trying to figure out why it
> > > wasn't doing ANYTHING when I declared an FK reference at column level.
> > >
> > > Things like that are, sadly, kinda rampant in MySQL.
> >
> > Are you aware of the MySQL Gotchas website (just google it)? Any time
> > you see MySQL being stupid about something you should probably check
> > there first to see if it's a "feature".
>
> Oh yeah, very aware.  What's amazed me is how often I find something
> that's majorly wrong that isn't in that list.  For instance, this
> particular problem isn't on the gotcha page, although lots of other
> constraint issues are.  Sadly, after talking to the author of the innodb
> table handler, I get the feeling this one isn't going to change.

Please submit any missing items to the author. If he refuses them send
them to me and I'll start an addendum.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461