Re: PostgreSQL 8.1 vs. MySQL 5.0?

Now this is rather useful in my opinion. I will be passing it on to some
of my collegues.

Aly.

On Thu, 6 Oct 2005, 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".
>

--
Aly S.P Dharshi
aly(dot)dharshi(at)telus(dot)net

"A good speech is like a good dress
that's short enough to be interesting
and long enough to cover the subject"