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.dharshi@telus.net

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