Re: PostgreSQL 8.1 vs. MySQL 5.0?

> 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".

http://sql-info.de/mysql/gotchas.html

Of course, one should probably also look at the PostgreSQL Gotchas page
(same guy) just to be fair :-)

http://sql-info.de/postgresql/postgres-gotchas.html

Now whether or not those are still valid or not I have no idea...

-philip